Changing the CSV Delimiter and Enclosure Characters on a Mac

January 29, 2018
Category: TIL
Tags: Excel

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