Using Numbers on a Mac for editing my spreadsheets, but unable to find a way of downloading a report (export) from Salesforce and doing the following with Numbers: open, edit, and save.

How to open and save a CSV file in Numbers?


There should be export options when you're viewing a report. You should be able to export any report into CSV or XLS format and open in Numbers.

| improve this answer | |
  • I have of course tried this, but the xls version that downloads doesn't open correctly in Number, it opens as an XML file, i.e., all data in one column. The CSV file opens straight up in the browser, maybe it is my browser config, I'll check that. – Bart Apr 4 '14 at 7:45
  • 1
    Rather than double-clicking, which will open in the default app, you might right click -> Open In... or just import from Numbers directly. – Jonathan Hersh Apr 4 '14 at 16:26

Open File: If the file has a CSV extension, not TXT, you should have the following options to open the file:

  • Right click and open it with Numbers,
  • Drop it on the Numbers icon in the dock, or
  • Open Numbers & drop the file into it.

** If it has a TXT extension, try changing it to CSV.

Export File:

  1. List item
  2. Open file,
  3. Click: File > Export
  4. Select: FileType = "CSV"
  5. Name & Save File

enter image description here

(Numbers 2.1 on OSX 10.6.8)

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.