Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
I tried to import a csv-file in numbers. The result is one column were alle the informations of the row are into, only separated by double quotation marks. How can I manage to have one column per information?
iMac, Mac OS X (10.6.8)
Numbers does best when the delimiter is a tab,
so open the file and replace the existing delimiter with a tab, then select all, copy
now paste into a table in numbers
Numbers does best when the delimiter is a tab,
so open the file and replace the existing delimiter with a tab, then select all, copy
now paste into a table in numbers
Thanks for your answer. Unfortunately I failed in doing so: my delimiter were <",">. So I opened the file in Textedit, replaced those delimiter by Tab and than imported the file in numbers. I still got one column.
Make sure you click only once in a cell before typing command-v to paste.
SG
You should be able to open a CSV in Numbers and get it to create columns and rows. Given that it did not work and given that it also failed when tab-delimited, I believe there is something wrong with your file. If you look at the file in TextEdit, are there improperly placed quotation marks or missing quotation marks?
It should look like
1,2,3
4,5,6
or
"1","2","3"
"4","5","6"
or, if there is text in a cell that had quotes as part of the text you might see something like this (double quotes)
"""hello""",2,3
4,5,6
how can I import a csv-file and separate the informations in colons
