Chuck Grimmett

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

Chuck Grimmett

Posted by Chuck Grimmett. Learn more on his About page.

Comments

Leave a Reply

Webmentions

If you've written a response on your own site, you can enter that post's URL to reply with a Webmention.

The only requirement for your mention to be recognized is a link to this post in your post's content. You can update or delete your post and then re-submit the URL in the form to update or remove your response from this page.

Learn more about Webmentions.