DoItAl

Data utility

CSV Column Mapper & Import Prep

Map a local CSV export into a destination column layout, review missing and omitted fields, preview every structural change, and download a complete import-ready CSV.

Browser-local • No upload

1. Add the source export

Drop a CSV or TSV file here

or choose a file from this device

or paste data

2. Confirm the source structure

Input rows

—

Input columns

—

Delimiter

—

Input size

—

A unique, non-empty header row is required. UTF-8 inputs are limited to 10 MB. Values remain text, including IDs such as 00123.

3. Define the destination layout

Paste the exact destination header row, or add and reorder columns below. Exact matching names map automatically; mismatched names stay unresolved.

Load a source file or paste a destination header row to begin.

4. Review import readiness

Export stays blocked until every destination column is mapped or explicitly blank and the source structure is unambiguous.

Input rows

—

Output rows

—

Input columns

—

Output columns

—

Unmapped required · 0

None

Other unresolved · 0

None

Source columns omitted · 0

None

Add source data and a destination layout to preview the complete output.

The download includes every input data row in original order. No values are converted, trimmed, inferred, or partially exported.

Continue with

Prepare a destination layout without editing cell values

CSV Column Mapper & Import Prep changes column structure only. Define destination headers in order, connect each to an exact source header or explicitly produce a blank column, review omitted fields, and export every source row. Leading-zero identifiers, quoted commas, escaped quotes, empty cells, and embedded newlines remain text.

Invalid or ambiguous imports stay blocked

Empty or duplicate source headers, ragged rows, duplicate destination headers, unresolved mappings, and missing saved source identities stop export. Saved mappings never fall back to a same-position column when a later file changes headers.

Choose the adjacent CSV tool by job

CSV Cleaner repairs values and structure. CSV Merge & Join combines files. CSV Split & Partition creates multiple outputs. CSV Filter & Extract Rows chooses records. This mapper only renames, reorders, omits, and intentionally blanks destination columns.

Private, bounded browser processing

Files, filenames, headers, mapping names, and cell values stay on this device and are excluded from URLs, logs, and analytics. Free accepts one UTF-8 file up to 10 MB; Pro batches accept ten files and 30 MB combined. V1 does not edit cells, calculate formulas, guess with AI, or promise compatibility with a named service.

What this tool does

Builds a destination-first column layout from exact source headers, including renaming, reordering, omitting, and intentional blank columns.

How to use it

  1. Open a headered CSV/TSV with unique, non-empty headers.
  2. Define destination columns and select each source identity or an explicit blank.
  3. Resolve mapping warnings, review the preview, and download every row.

Worked example

Map source ‘customer_id’ to destination ‘Customer ID’, source ‘email’ to ‘Email’, and add ‘Notes’ as blank. An ID such as 00127 stays cell text rather than becoming a number.

Processing and explanation

Mapping changes the column structure while preserving cell text and row order. Source columns use exact header identity, so resolve missing source selections before exporting.

Limits and common mistakes

Single input up to 10 MB. Empty or duplicate headers, ragged rows, unresolved mappings, and duplicate destination names block safe export. This is not an importer into a third-party service.

Privacy and your input

Header names, destination names and values remain in this browser. The mapped CSV is generated locally.

Frequently asked questions

Why add an intentional blank column?
A receiving layout may require a column that the source does not contain. Select an explicit blank rather than mapping unrelated data into it.
Does this filter rows?
No. Use Filter & Extract Rows to select records, then map the resulting columns.

Material content update: