This page describes how you can create a valid product data file in the CSV format from an ODS or XLS file. You need to export the data to a CSV file in order to upload it to the Workbench. There are two commonly used software tools and file formats to create CSV files:
Table of Contents:
In order to maintain the structure of your CSV file required for uploading your product data into the Workbench, you should not edit the CSV file in a text editor, but editing the Product Data in an ODS or XLS file and then exporting it to an CSV. This documentation only contains the major steps and export settings to produce a valid CSV file. For more information, please refer to the documentation of LibreOffice or Excel and just simply check our Template and Example Data Files that provides you with a valid file to start with.
Of course, there are many more ways of producing CSV files than from ODS or XLS files, such as more complex export functions from shop systems or PIM (Product Information Management) systems or other databases. Since these are proprietary solutions, they are not covered in this documentation. |
The CSV Export in Excel is more complex and difficult than using LibreOffice. The reason is that there will be no field option dialog shown (see images above). The field delimiter is automatically set due to your operating system language (Source: Windows 10).
The first variant changes the local language to "English (US)". This language uses a comma field delimiter per default, which is needed. The German language uses semicolons as field delimiter and is thus not usable.
The second variant does not require the change of the operating system language. For this variant, a Google account and Google Spreadsheet is needed.