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 "|"
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!
