How to use Dataset Column Mapper
- Paste the source table or choose CSV, TSV or XLSX. Use Read source headings to populate the mapping choices when needed.
- Enter ordered target columns with the row controls or schema JSON. Mark required targets and supply optional defaults only for columns that will remain unmapped.
- Map each target to the exact source heading, or load a saved mapping profile and check it against this source. A blank mapped value does not receive an optional default.
- Create the result and review excluded source columns, required-value errors and formula-prefix changes. Download mapped-dataset.csv and the reusable column-mapping-profile.json.
Example: Dataset Column Mapper
Rename Email and Full Name, while filling an unmapped optional status with new.
Options
- Source table
- Paste CSV or TSV with distinct headings, or choose a table file. The selected file replaces pasted text; XLSX uses saved values from a visible sheet.
- Target schema JSON
- Ordered columns, each with name and required. Optional default strings fill unmapped columns; they do not replace blank mapped cells.
- Column mapping JSON
- Map target names to exact source headings. Unknown, duplicate and missing required mappings are refused. Unmapped source columns are listed and left out.
- Protect formula-like CSV values
- Adds an apostrophe before cells that a spreadsheet may run as a formula. This changes those exported values; turn off only for a trusted import that needs raw text.
Supported inputs and limits
- Source CSV/TSV/XLSX: 20 MiB, 100,000 rows, 500 columns and 2,000,000 cells.
- Target schema: 1–100 distinct columns; mapping/profile JSON: 30,000 UTF-8 bytes.
- Required targets need nonblank mapped values.
- Defaults fill unmapped optional columns only.
- Profiles store schema and headings, without source rows.
More details
XLSX reads a visible sheet and saved values, without recalculation.
No automatic email, date or identity validation is implied.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
Mapping changes structure without finding missing data
The tool reorders and names supplied columns according to your schema. It does not guess a match from similar names, combine values or replace a blank mapped cell with a default. Review the excluded-source report before relying on the result as a complete export.
Keep the schema with the import recipe
A target system can impose types, unique keys or validation that this text mapper does not check. Retain the schema, mapping and delimiter choices with the source file, then test a small output in the destination application.
Questions about Dataset Column Mapper
Will similar header names be matched automatically?
No. You choose mappings so a similar name cannot silently send values to the wrong destination.
What is saved in a profile?
The schema and mapping needed to repeat the transformation. Inspect the profile before sharing it; it can include your header names.
Why can an exported cell gain an apostrophe?
Spreadsheet formula protection prefixes dangerous formula-like text. The result reports this modification.