Skip to content

Export products to CSV

The CSV export produces files that are designed to be re-importable. Empty referential type attribute values - including empty referential type elements in multi-valued attributes - are exported as empty cells rather than the NULL keyword. This ensures that re-importing the exported file preserves empty values correctly without creating index gaps. For details on how NULL and empty values are handled during import, see the CSV specification.

Bizzkit recommends

Opening a CSV export file in Excel

Microsoft Excel is a popular editor that can be used to open CSV files exported from Bizzkit PIM. However, there are known issues with encoding and formatting where Excel may not always interpret the exported data correctly.

To ensure proper handling of CSV files in Excel, follow these steps:

  1. Open a new blank workbook in Excel - do not double-click the CSV file, as this will open the file in a wrong way
  2. Go to the Data tab on the ribbon
  3. Click From Text/CSV
  4. Select your CSV file and click Import
  5. In the preview window, make sure the following options are selected:
    1. File Origin: 65001: Unicode (UTF-8)
    2. Delimiter: Semicolon
    3. Data Type Detection: Based on first 200 rows
  6. Click Transform Data
  7. Click the Use First Row as Headers button on the ribbon
  8. Click the Close & Load button on the ribbon

Alternatively, other tools besides Excel can be used for editing CSV files.