I have a .CSV file, it opens well in Numbers ~4, but when i do changes in that file (editing row color, etc) i can't correctly save it. If i try to save it as .numbers - when i open that .numbers file, it gives me blank rows, everything is empty.

  • CSV files don't store row color or other formatting details. You will need to save the CSV file in another format like Numbers of export it to XLSX. – jaume Sep 18 '20 at 7:28

Try to keep it as a .csv file.

While you have numbers open go to the menu bar and click on file > Export to > CSV...

  • It produces the same CSV file without my changes :D – Alexander Kim Mar 15 '18 at 12:52
  • CSV only contains data, not formatting. Please share a sample numbers file or screenshot that shows your issue. – Matt Sephton Mar 16 '18 at 15:45
  • Exporting a CSV with Numbers doesn't edit the original file. It only allows you to overwrite it. It doesn't open a CSV as much as import it into a .numbers file. – ponies Jan 10 '20 at 23:52

It seems like Numbers can't edit .csv files.

You can use this tool:

Free .CSV text file editor for Mac OS X?

  • 1
    Numbers can open and export csv. I do this all the time on Mac and iPad version. Could you elaborate on that seems statement? – bmike Sep 17 '20 at 22:42

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .