Why do exports to Excel look like this?

Have your Excel exports ever looked like the following screenshot?

ex1

The reason: your computer is not setup to auto-open .CSV files with Microsoft Excel.

To work around this, use the save feature as follows.

ex2

Locate the downloaded file, right click -> open with -> choose default program…

ex3

choose Microsoft Excel and make sure “Always use the selected program…” is checked

ex4

All future exports to .CSV will now open in Microsoft Excel by default.

Leave a Reply