Skip to main content

Why is the currency not showing up correctly in the downloaded CSV file?

If currency values look different when you open a CSV in Excel, check the import and number-format settings. Excel uses its current default data-format settings when opening a CSV directly, so changing spreadsheet apps is not a guaranteed fix.
​
Instead of opening the file directly in Excel, you should try creating a new excel file and importing the downloaded CSV into it.
​https://support.microsoft.com/en-au/office/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba#:~:text=You%20can%20import%20data%20from,to%20import%2C%20and%20click%20Import.

Did this answer your question?