How do I split a product catalog by supplier in Excel?

Upload your catalog export to Deliteful and enter the supplier column name. The tool creates one .xlsx file per supplier containing only their rows, with the original header preserved.

Can I split order data by fulfillment region or warehouse?

Yes — enter the column header for your region or warehouse field and Deliteful produces one file per unique value. This works for any column in your export.

Does this work with Shopify or WooCommerce CSV exports saved as Excel?

Yes, as long as the file is saved as .xlsx or .xls with consistent column headers. Deliteful reads the first worksheet containing your specified column.

What if a product row has a blank category or supplier value?

Rows with empty values in the split column are grouped into a single output file so no rows are dropped from your dataset.

How many supplier or category files can the tool generate at once?

Up to 200 output files per input file. If your catalog spans more than 200 unique values in the split column, rows beyond that limit are excluded from output.

Split Product or Order Excel Exports by Category, Supplier, or Region

E-commerce managers working with large product catalogs or order exports constantly need to break data out by category, supplier, or fulfillment region before uploading to a marketplace or sharing with a vendor. Doing this manually in Excel — filtering, copying, saving — is repetitive and scales poorly as SKU counts grow.

Create free account

A typical catalog export from Shopify, WooCommerce, or a PIM system might contain thousands of rows spanning dozens of categories or hundreds of suppliers. When you need to send a supplier only their own SKUs, or load a category-specific feed into a marketplace, you need those rows isolated into separate files. The manual filter-and-export loop for 30 suppliers takes hours and introduces copy-paste errors.

Deliteful reads your master Excel file and outputs one .xlsx per unique value in whatever column drives your split — 'Category', 'Supplier', 'Warehouse', 'Marketplace'. Each output file is clean, header-intact, and ready to upload or forward. The tool handles up to 200 unique values per run, covering virtually any catalog or order dataset.

How it works

1
Create a free Deliteful account
Sign up with Google in about 3 clicks — no credit card required.
2
Upload your catalog or order export
Drop in your .xlsx or .xls file from Shopify, WooCommerce, or your ERP.
3
Enter the column to split on
Type the exact column header — e.g., 'Supplier', 'Category', or 'Region'.
4
Download your split files
Get one Excel file per unique column value, each ready to send or upload.

Frequently asked questions

How do I split a product catalog by supplier in Excel?: Upload your catalog export to Deliteful and enter the supplier column name. The tool creates one .xlsx file per supplier containing only their rows, with the original header preserved.
Can I split order data by fulfillment region or warehouse?: Yes — enter the column header for your region or warehouse field and Deliteful produces one file per unique value. This works for any column in your export.
Does this work with Shopify or WooCommerce CSV exports saved as Excel?: Yes, as long as the file is saved as .xlsx or .xls with consistent column headers. Deliteful reads the first worksheet containing your specified column.
What if a product row has a blank category or supplier value?: Rows with empty values in the split column are grouped into a single output file so no rows are dropped from your dataset.
How many supplier or category files can the tool generate at once?: Up to 200 output files per input file. If your catalog spans more than 200 unique values in the split column, rows beyond that limit are excluded from output.

Sign up free with Google and split your next supplier or category export into individual files without touching a filter or macro.