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.
What is the decimal delimiter for numeric values [ . ] or [ , ]?
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! ⬆️