CSV Import Fixer

Fix Your CSV to Match an Import Template

Choose a source CSV containing your headers and data, then choose a destination template. Match the columns, catch common import problems, and download a corrected CSV. Your files are processed locally in your browser and never sent to our servers.

Choose and parse a source CSV and destination template.

Choose your CSV files

Select one source file and one destination template to begin.

Contains the headers and data rows you want to fix.

Choose source CSV

or drag and drop one CSV file here

CSV only. Choose a CSV file no larger than 5 MB.

Defines the output headers and column order. Template sample rows are ignored.

Choose destination template

or drag and drop one CSV file here

CSV only. Choose a CSV file no larger than 5 MB.

A reviewable workflow

How to match a CSV to an import template

Move from mismatched columns to an import-ready file without uploading your data or handing decisions to a black box.

  1. Step 1

    Choose both CSV files

    Select the source CSV containing your data and the destination-template CSV that defines the output headers and order.

  2. Step 2

    Confirm the column mappings

    Review deterministic suggestions, choose the source for each target column, and mark target fields as required when needed.

  3. Step 3

    Clean, validate, and preview

    Apply explicit format rules, review issues across every source row, and inspect the transformed preview before export.

  4. Step 4

    Download in template order

    Create a corrected CSV whose headers and columns follow the destination template exactly.

Common import blockers

What CSV Import Fixer helps you correct

The tool focuses on deterministic, visible changes that make a source CSV conform to the structure you provide.

  • Header and column mismatches

    Map differently named headers, reorder columns, and leave unrelated source columns out of the corrected file.

  • Common format differences

    Normalize supported text, date, number, and boolean formats with rules you can review before download.

  • Missing required values

    Mark the target columns that are required for your import and find blank values across the full source file.

  • Formula-like value risks

    See warnings for values spreadsheet software may interpret as formulas without silently changing the normal import export.

Before you start

Frequently asked questions

How local processing, templates, required fields, and export safety work in this version.

Are my files sent to a server?

No. Selected CSV files are read and processed locally in your browser. Their filenames, headers, and cell values are not sent to an application server or saved after you refresh the page.

What is a destination-template CSV?

It is a CSV whose first non-empty row contains the exact output headers and column order required by your destination. Any example or placeholder rows below that header are ignored and never included in the corrected file.

Can the tool know which fields are required?

Not from a generic template alone. A header row defines names and order, but it does not reliably prove which fields a third-party platform requires. You must mark required targets yourself and check the destination platform’s current documentation.

Does it support Excel files?

No. This version supports CSV files only and does not accept .xlsx or .xls workbooks, Google Sheets links, or other spreadsheet formats. You can export a workbook as CSV before using the tool.

Does it use AI?

No. Mapping suggestions and transformations use deterministic local rules. Suggestions remain visible and editable, and no file content is sent to an AI service.

Why are duplicate template headers blocked?

Duplicate destination headers make the expected output ambiguous: two target columns would have the same name, and cells could not be mapped or reviewed reliably. Correct the template headers and select the file again.

What are formula-like value warnings and spreadsheet-safe export?

Formula-like text may be interpreted as a formula when a CSV is opened in spreadsheet software. The normal corrected CSV preserves those values for direct import. If you explicitly create a spreadsheet-safe copy, detected risky text is prefixed with an apostrophe. That changes data, may be unsuitable for direct import, and is off by default; valid negative numbers remain unchanged.