Sample Header Ad - 728x90

Changing CSV Delimiting Character in Numbers

5 votes
1 answer
4343 views
I have a CSV file which is delimited with semicolons. I would like to open it in Numbers and edit. Currently, when I open it, it jumbles all the data, including the semicolons, into one column. It appears that the issue is that the delimiting character is set to something other than the semicolon. How can one change it? P.S. I have tried manually replacing the semicolons with commas using a text editor, and it fixed the issue. However, I would still like to know a more straightforward way to do so via Numbers.
Asked by MadPhysicist (187 rep)
Jun 18, 2021, 10:31 AM
Last activity: Jun 18, 2021, 05:55 PM