Dataset Column Mapper

Map source columns into editable target fields, with required values, defaults and reusable mapping profiles.

On-device No sign-up Free to use

Map columns controls

Showing an example. Edit to see your own.

?

Paste CSV or TSV with distinct headings. A selected file replaces pasted text.

Drop your table file here

or choose one from your device

Chosen file replaces pasted text. XLSX uses saved cells and does not calculate formulas.

    Drop your file here

    or choose one from your device

    Up to 30,000 UTF-8 bytes. Reuses target columns and source mappings, without stored source rows.

      ?

      Ordered columns, each with name and required. Optional default strings fill unmapped columns; they do not replace blank mapped cells.

      ?

      Map target names to exact source headings. Unknown, duplicate and missing required mappings are refused. Unmapped source columns are listed and left out.

      ?

      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.

      Processed in your browser. Your inputs stay on this device.

      Result

      Showing an example.

      Rename Email and Full Name, while filling an unmapped optional status with new.

      Mapped 2 rows into 3 target columns.

      Loading the tool. Your result will appear here.

      https://usefreetools.net/dataset-column-mapper · 20 November 2026

      Was this helpful?

      How to use Dataset Column Mapper

      1. Paste the source table or choose CSV, TSV or XLSX. Use Read source headings to populate the mapping choices when needed.
      2. 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.
      3. 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.
      4. 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.

      You add
      Source table: Email,Full Name,Notes alice@example.test,Alice,Reviewed bob@example.test,Bob,Pending; Target schema JSON: {"columns":[{"name":"email","required":true},{"name":"display_name","required":true},{"name":"status","required":false,"default":"new"}]}; Column mapping JSON: {"email":"Email","display_name":"Full Name"}; Protect formula-like CSV values: true
      You get
      Mapped 2 rows into 3 target columns.

      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.

      Page updated · Project managed by Tony Hines · Report a problem with Dataset Column Mapper