cvs files

How to convert a TextEdit list of data to a cvs file into Numbers


Posted on Mar 23, 2021 3:48 PM

Reply
Question marked as Top-ranking reply

Posted on Mar 23, 2021 4:02 PM

You don't need to convert anything. A comma separate vars file is just text with the variables (columns) separated by commas. Just add a .csv (not cvs) extension to the text file.

TextEdit will default to adding .txt to the file unless you disable that in the Preferences.

You should then be able to open the file in Numbers.


If any fields contain commas, then you need to enclose that entire field with double quotes (not curly quotes).

1 reply
Question marked as Top-ranking reply

Mar 23, 2021 4:02 PM in response to gl-dml

You don't need to convert anything. A comma separate vars file is just text with the variables (columns) separated by commas. Just add a .csv (not cvs) extension to the text file.

TextEdit will default to adding .txt to the file unless you disable that in the Preferences.

You should then be able to open the file in Numbers.


If any fields contain commas, then you need to enclose that entire field with double quotes (not curly quotes).

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

cvs files

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.