You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Comma Separated List

Can I create a comma separated list in Numbers without going to Excel?

Posted on Nov 17, 2019 9:23 AM

Reply
Question marked as Top-ranking reply

Posted on Nov 17, 2019 12:35 PM

Hi Holly,


In CSV (Comma Separated Values or, more generally, Character Separated Values) files, each value in a row is separated from the next with a comma (or other character named as the delimiter), and each row is separated from the next with a carriage return.


If you want your list to be displayed horizontally, you need to place the values in a row.


Examples:


The Numbers file was created as a single table file using the format shown as CSV sample 1, then exported to a csv file using that name.

The menu Table menu item Transpose Rows and Columns was then used to re-order the table to the format shown on the right, and the (still single table) document was again exported to a csv file with the name CSV sample 2.


I then duplicated the single table, repeated the Transpose Rows and Columns command on one of the two copies, named the two tables to match the name of the corresponding file, and arranged them as shown for the screen shot above.


Below are screen shots of the two sample files opened in TextEdit, and in Numbers.


TextEdit


Numbers:


Regards,

Barry


5 replies
Question marked as Top-ranking reply

Nov 17, 2019 12:35 PM in response to HollyH

Hi Holly,


In CSV (Comma Separated Values or, more generally, Character Separated Values) files, each value in a row is separated from the next with a comma (or other character named as the delimiter), and each row is separated from the next with a carriage return.


If you want your list to be displayed horizontally, you need to place the values in a row.


Examples:


The Numbers file was created as a single table file using the format shown as CSV sample 1, then exported to a csv file using that name.

The menu Table menu item Transpose Rows and Columns was then used to re-order the table to the format shown on the right, and the (still single table) document was again exported to a csv file with the name CSV sample 2.


I then duplicated the single table, repeated the Transpose Rows and Columns command on one of the two copies, named the two tables to match the name of the corresponding file, and arranged them as shown for the screen shot above.


Below are screen shots of the two sample files opened in TextEdit, and in Numbers.


TextEdit


Numbers:


Regards,

Barry


Comma Separated List

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