How to Import CSV/XLSX into a Pivot Catalog

The tabular source is convenient for price lists, balances, directories and supplier files in Excel.

When to use

Use CSV/XLSX import if each row describes a product, offer, price, stock, or feature.

How to set up

1. Upload CSV or XLSX as source.
2. Check the sheet, headings and separator.
3. Create a union catalog upload profile.
4. Match the columns with the catalog fields.
5. Run the import and check for errors line by line.

What will happen

Table rows will turn into products, offers, or catalog property updates.

What is important to remember

• Articles and barcodes are best read as text.
• Empty lines and service headers must be excluded before importing.