Changing the CSV Delimiter and Enclosure Characters on a Mac

TIL that you can’t change the CSV delimiter or enclosure characters on Excel for Mac or Apple Numbers. You have to use Open Office, and even there it is tricky. You need to go to File > Save As, select Text CSV, then make sure you check the “Edit Filter Settings” checkbox:

CSV Open Office Filter Settings

Then you get the field option AFTER you hit Save, only if the Edit Filter settings box is checked:

CSV Open Office Field Settings

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: