Inputs and size limits
CSV supports UTF-8 (with or without BOM) and UTF-16 with BOM. The converter detects comma, semicolon, tab, and pipe separators and handles quoted multiline values. XLSX supports unencrypted workbooks with up to 24 worksheets and 48 MiB of expanded data. Limits are 8 MiB on disk, 20,000 source rows per sheet, 100 columns, 500,000 cells across a workbook, and 32,000 characters per cell. A header can be selected from the first 50 records. CSV row numbers count records, including blanks and multiline records as single records.
Supported Shopify fields
Title, URL handle, Description, Vendor, Type, Tags, SKU, Barcodes, Price, Option1 name, Option1 value, and Product image URL. Columncraft generates Image position, Status and Published on online store when applicable. It exports one untyped barcode per variant and uses draft status with online-store publication set to false. Files larger than Shopify’s 15 MB product CSV limit are blocked.
Product structures
Use the converter for new physical products with a single default variant or one independent option such as Color. Use a shared handle to group variants and additional product images. Keep product-level values consistent within a handle. Existing product updates, two or more option dimensions, linked options, variant-specific images, typed or multiple barcodes, inventory, shipping fields, market pricing, tax settings and metafields are outside the supported workflow. Review all unmapped columns.
Values and calculations
CSV cells remain text. XLSX uses cached displayed values, so store identifiers as text and use plain numeric prices without currency symbols. Formulas are never evaluated. Use a single currency matching the store, one decimal convention and up to six fractional digits in source prices. Export prices are rounded to two decimals. To avoid formula interpretation, review flagged text and inspect the product CSV in a text editor.
Fictional examples
Download the sample CSV or download the sample workbook. The image URLs are placeholders.