Product and catalogue data for your eShop are exported as a CSV file. These files provide the data in a similar way to a database file. A data set (e.g. the data of a single product) is represented as a row or line. Each line contains separate fields (the actual data), separated by a comma or a semicolon. The export dialog offers you a number of formatting options for the file:
- Object type - The type of data to be exported. You can export products, categories or product-category assignments.
- Formatting - The formatting corresponds to regional settings. It defines the field delimiter (comma for English formatting, semicolon for German formatting), the decimal separator (point for English formatting, comma for German formatting) and the date format.
- Languages - Determines the language in which the contents of language-relevant fields are displayed. If you select English for example, then only the English content of the language-relevant fields, such as description and names, are exported.
As soon as the export is finished you have the option to either open the file directly with Microsoft Excel (if Excel is configured to open CSV files) or download the file to your computer. Select the download option and save the file in a directory of your choice. Opening the file directly in Excel would reformat important file properties. Do not use a version of Excel prior to 2000 to open the export file.
- Start Excel and create a new (empty) spreadsheet.
- On the menu bar, select Data, Get External Data, From text.
- Select the file type All files (*.*), select the file name and click Import. The Text Import Wizard window is displayed.
- In step 1 select the following options:
Original data type - Select Delimited
Start import at row - Enter 1
File origin - Select Windows (ANSI)
Next to continue. In step 2 select the following options:
Delimiters - Select Comma for an English file format or Semicolon for a German file format. Check the Data preview area if you’re not quite sure about the format.
Treat consecutive delimiters as one - Deselect this option.
Text qualifier - Select the double quotes (“) as a text qualifier.
- Click Next to continue. In step 3 select each column of the table in the Data preview area and select as the Column data format.
- Click Finish and select where to put the data..
- After editing the file, select Save As… from the File menu.
- In the Save As window, select CSV (Comma delimited) (*.csv) as the file type and enter the file name. If the message The selected file type does not support workbooks that contain multiple sheets is displayed, click OK to save only the current sheet, which contains your export data. A message, informing you about compatibility issues will appear. Please click Yes to keep the existing file format. You can now import the file to your eShop.