Note the following when editing CSV files with Microsoft Excel.
By default, Excel deletes zeros at the beginning of the entries and sets the data format according to the language settings of the user's computer. To avoid errors when uploading CSV files, entries beginning with zero must be entered with an apostrophe (e.g. '0110) or the cells must be formatted as "text". In addition, the regional data format standards must be taken into account (see Regional Specific CSV File Structure).
- The computer's language setting for Excel editing must match the user's language settings for CSV uploading (see Regional Specific CSV File Structure and Formatting).
- CSV files generated by SupplyOn eInvoicing use UTF-8 encoding, and eInvoicing expects UTF-8 encoding for uploading CSV files. To ensure that special characters (e.g. äöü) are processed correctly with Excel.
- Before you open a CSV file generated by eInvoicing with Excel, you must convert the CSV file to ANSI. This can be done using the Windows Notepad Editor (File -> Open with -> Notepad -> Save as -> Set coding to ANSI -> Save).
- Before uploading a CSV file edited with Excel, convert the edited CSV file to a UTF-8 encoded CSV file (File -> Open with -> Notepad -> Save as -> Set encoding to UTF-8 -> Save).