Is there any way to do this? I need to use a pipe "|" as my delimiter. On Windows you can change this during the export. On Mac I haven't found a way. As a side note, my files have commas in the data itself.
Customize delimiter character with Excel CSV save-as
csvms office
Related Solutions
Assuming you have a valid/consistent CSV file, create a new workbook and then choose File -> Import. The first option on the list is "CSV file":
Most scripting languages should be able to do this e.g. python, perl, tcl,
Python does this with
- AN odbc pachkage - see Python wiki
- csv package in the standard library
Related Question
- How to open CSV file with Microsoft Excel and get the information into separate columns
- MacOS – Export Outlook Emails (Mac) to Gmail
- Save Excel file as pipe-delimited values file
- Open CSV wtih Excel from Finder
- Separating emails by commas in Outlook 2016 Mac
- How to import text to columns and import numbers to text in macOS Numbers
Best Answer
If you're willing to move away from Excel, you could try using OpenOffice or LibreOffice to create
.csvfiles. They're both free, they both have most of the functionality included in Excel, and they both allow tabulated data to be saved as a.csvfile using any character as a data separator or text delimiter (including the pipe, of course).