A little clarity goes a long way
Make sense of your import file.
Start with the issue in front of you. Each guide explains a concrete problem and links to a working file tool.
Keep commas, quotes, and newlines inside CSV fields
A practical worked example of quoted CSV descriptions, embedded commas, escaped quotes, and multiline fields.
Why a CSV opens as one column
Check comma, semicolon, tab, and pipe delimiters before editing product data or replacing punctuation globally.
Preserve leading zeros in SKUs and barcodes
Protect SKU and barcode strings from spreadsheet number conversion, scientific notation, and irreversible digit loss.
Fix unreadable characters in a product CSV
Check UTF-8, encoding mismatches, and byte-order marks without replacing valid Unicode product names or descriptions.
Review ambiguous prices and decimal separators
Understand why values such as 1,250 need review and why a CSV fixer should not guess prices, quantities, or units.
Review formula risks before opening a CSV in a spreadsheet
Learn why formula-like CSV cells need review and why spreadsheet-safe reports must stay separate from marketplace import files.
Find duplicate or empty CSV headers
Inspect duplicate names, blank headers, and hidden whitespace while preserving every original column and cell.
Review Shopify CSV updates before overwriting products
Understand empty versus omitted fields, protect existing variants, and build an intentional product update file.
Understand Shopify handles, variants, and image rows
See why repeated handles are expected in Shopify CSV files and how to distinguish product, variant, and additional image records.
Review a CSV repair before exporting
A practical workflow for accepting fixes, comparing before and after values, revalidating, and keeping an audit trail.
Map a product file to a marketplace template
Plan an explicit header mapping with country, category, and template version, and distinguish structure checks from marketplace validation.