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
    Commented Sep 18, 2020 at 7:28

2 Answers 2


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 Commented Mar 15, 2018 at 12:52
  • CSV only contains data, not formatting. Please share a sample numbers file or screenshot that shows your issue. Commented Mar 16, 2018 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
    Commented Jan 10, 2020 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
    Commented Sep 17, 2020 at 22:42

You must log in to answer this question.

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