Export products to CSV

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.