Two small things to check on Spendesk, three simple steps on Excel!

Before you import your data - on Spendesk

Review your setup in 'Settings>Exports' for the template that you use.
1. What is the decimal delimiter for numeric values [ . ] or [ , ]?
2. What is the column delimiter for the CSV [ , ] or [ ; ]?
Obviously, you need now to export your journals or data from Spendesk ;)

After you exported your data - on Excel

Import your data via the "Import" function
Select the correct column delimiter [ , ] or [ ; ]
Select the correct decimal delimiter [ . ] or [ , ]

Three simple steps to import a CSV to Excel

Import your data via the "Import" function

Open a new Excel spreadsheet (do not double click on the CSV)
Go on "File" and then on "Import"
Select "CSV file" and click on "Import"
Select your Spendesk journal and click on "Get data"
Please verify that the import action is set to "Delimited" and that the start import at row is set to "1"
Please change the File origin to "Unicode (UTF-8)"
Click Next

Select the correct column delimiter [ , ] or [ ; ]

Please select your delimiters [ , ] or [ ; ] (depending on your setup on Spendesk) and click on Next

Select the correct decimal delimiter [ . ] or [ , ]

Click on "Advanced" and verify the decimal separator [ . ] or [ , ] (depending on your setup on Spendesk)
Click on Finish and select whether you want to import the data into the existing sheet or a new sheet

Three simple steps to import a CSV to Google Sheets

Go to File and then Import
Go to the Upload option and select the CSV file to upload
Select the correct delimiter [ , ] or [ ; ] and make sure to select the option "convert text to numbers, dates, and formulas"

↪️ Tip: if you are using a Mac computer, feel free to open the document in Numbers and then save it as CSV - UTF-8. This way, when you open it in Excel, you will obtain a readable format.

Also, if you are using Google drive, the format should be correct. If not use one of the solutions above! ⬆️