Quick Summary · Updated November 2026

Most failed CSV imports trace back to six silent defects: UTF-8 BOM headers, non-breaking spaces (\u00A0), blank rows, ragged column counts, duplicate primary keys (SKU / Email), and currency symbols inside numeric price columns. Sanitizing locally in browser memory repairs all six before you upload to Shopify, HubSpot, or QuickBooks.

01 / INTERACTIVE BROWSER CSV CLEANERUpload a messy CSV/TSV or test a realistic dirty preset below.

Drop or choose a local CSV / TSV file (up to 10 MB · 50,000 rows) messy-supplier-catalog.csv (7 raw rows)
Or paste / edit raw CSV or TSV text directly
Inspect row-level repair log
    Next: Convert to Shopify CSV ↗

    02 / SIX SILENT CSV DEFECTSWhy spreadsheets look fine in Excel but fail on import.

    1. Invisible UTF-8 BOM on column 1: Excel prepends \uFEFF so Shopify reads \uFEFFHandle instead of Handle and throws “Missing required headers.”
    2. Non-breaking spaces (\u00A0): Copy-pasted product names or SKUs contain hidden HTML spaces that break SKU lookups and duplicate checks.
    3. Semicolon exports from EU Excel locales: European regional settings export ; instead of ,, collapsing an entire product row into a single column.
    4. Duplicate primary keys: Re-exported wholesale feeds often contain duplicate SKU or email rows that silently overwrite earlier records on import.
    5. Ragged rows: An unescaped comma or truncated export row shifts every column to the left, putting stock counts into the price column.
    6. Currency prefixes inside price cells: Values like $64.50 USD or €42.00 fail strict numeric validation in Shopify, WooCommerce, and accounting tools.

    Common questions.

    Does Row & Record upload my CSV file to a server?

    Never. All delimiter detection, trimming, deduplication, and CSV serialization run strictly inside your browser tab memory. Refreshing the page clears the file immediately.

    Will deduplication delete my first row or my latest row?

    Deduplication keeps the first occurrence of each key (or exact row) and removes subsequent duplicates, logging each removed row number in the repair log above.

    Can it convert European semicolon-separated CSVs or TSV files to standard comma CSV?

    Yes. The parser automatically detects comma (,), semicolon (;), and tab delimiters and always exports standard RFC-4180 UTF-8 comma-separated CSV.

    What is the file size limit?

    This browser tool safely processes up to 10 MB and 50,000 rows per file. For 50k–500k+ row datasets, use the zero-dependency Python 3 CLI included in our $9 12-Platform Offline CSV Kit.

    RELATED CSV TOOLSComplete local CSV workflow