Skip to main content
SupplyOn AG SupplyOn Support Center

SupplyOn Support Center Menu

  • SupplyOn Support Center
  • SupplyOn Help Pages
  • English
    English Deutsch Français Español Italiano Português 日本語 繁體中文
Login
  1. Home
  2. SupplyOn Support Center

Editing CSV files with MS Excel

SupplyOn Portal - Invoice Upload via CSV or Excel

Editing CSV files with MS Excel

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).
Was this article helpful?
Why wasn't this article helpful?

To contact the Support-Team please click here

  • Getting started
    • Benefits of Uploading invoices
    • Technical and content requirements for CSV
    • Technical and content requirements for Excel
  • Invoice Creation with CSV
    • Editing CSV files with MS Excel
    • Step 1 - Example invoice
    • Step 2 - Create CSV export
    • Step 3 - Routing data
    • Step 4 - Generate the CSV file
    • Transmitting CSV invoices
  • Invoice Creation with Excel
  • Error handling for CSV
    • Content errors
    • Error in file formatting - Format setting
    • Error in the file structure
    • Errors detected by the customer
    • Invoice number has already been used
    • Order is not valid
    • Routing triple is faulty
    • Shipping notification was not created
  • Error handling for Excel
  • Archive rules

Footer EN

  • Contact
  • Imprint
  • Legal notes
  • Privacy policy
  • Security/Certificates

© SupplyOn AG