SM
Spiro Media
Created Dec 14, 2023How to open Reports in Mac Numbers
The downloadable reports in Spiro are a CSV (comma separated) file. However because much of the data in the reports includes a "," we have chosen to use a different separator value.
All of the reports are separated by a "|" (bar) which can be entered by holding shift + \ on your keyboard.
On Mac Numbers you will need to change the separator (delimiter) from a "," to a "|"
5
1
Open the Report in Numbers (Mac)
You will see that the columns are incorrect
2
Click the bubble "Table data was imported and can be adjusted"
3
Set the "Custom Delimiter" to |
4
Click "Update Table"
5
Now all of your Columns will appear correct!
Well done!
Create how-to guides like this in a snap. Get Tango now.