Excel to Shopify CSV converter to import products from Excel to Shopify

A supplier sends a new price list every week, another sends a monthly catalog workbook, and both need attention before the next product update. A US store owner or ecommerce operations manager has to identify the product tab, compare supplier column names with the Shopify template and preserve SKU and barcode text. An Excel to Shopify CSV workflow should make those preparation choices repeatable while leaving product review with the person who knows the catalog.

Start with the Shopify product CSV template and arrange your workbook to match the intended import. Select comma and UTF-8 when converting, then inspect the output before upload. The UTF-8 CSV conversion guide explains the encoding options. When several vendor workbooks arrive together, batch convert Excel to CSV with the same sheet and export settings. Batch conversion applies settings across files; supplier headers still need preparation or a pipeline schema template.

How to convert Excel to Shopify CSV in three steps

1. 1Prepare the product rows and headers in Excel using the Shopify template. Remove unwanted populated columns, store SKU and barcode columns as text, and arrange variant and image rows before uploading the workbook. Choose the first sheet, a named tab or all tabs as appropriate.
2. 2Choose CSV, comma and UTF-8. Apply cleanup only where appropriate, convert and review the downloaded file. Confirm the header row, handles, image links and file size. Shopify documentation says a product CSV cannot exceed 15 MB, regardless of the workbook size accepted by your conversion plan.
3. 3In Shopify admin, follow Products > Import > Add file > Upload and continue > Import products. Review the optional Publish new products to all sales channels and Overwrite products with matching handles checkboxes. According to Shopify documentation, matching handles are ignored when overwrite is not selected.

Match the Shopify product CSV template before exporting Excel

According to Shopify documentation, the first CSV line is the header row and only Title is required for new products. URL handle is required when adding variants, and updates require both the handle and Title. Handles contain letters, numbers and dashes without spaces. Shopify generates a blank handle from Title, so Black Sunglasses becomes black-sunglasses. XlsConverter does not generate handles. Keep existing handles where you intend to identify existing products, and review them before selecting an overwrite.

Shopify documentation allows Collection as the only column added to the template; any other added column breaks the format. Remove supplier notes and unsupported populated columns in Excel, since dropping empty columns does not remove populated data. Having both Barcode and Barcodes columns makes the file fail. Some columns also depend on others. Variant columns such as SKU or Weight value (grams) need Option1 name and Option1 value, with up to 3 options per product. Renaming a header alone does not supply those dependent values.

Keep UPC, barcode and SKU columns stored as text in Excel to protect leading zeros. Excel loses precision beyond 15 digits and can turn long numbers into scientific notation; a later CSV export cannot recover digits already changed. Formulas export as calculated values, so check supplier price calculations before conversion. Shopify documentation also distinguishes an empty cell from a missing column during overwrite. A blank non-required cell replaces the existing value with blank, while a column omitted from the file leaves the existing value unchanged.