Map Columns

Rename columns, change their order, and set each one as text, number, or date.

You can also import a file on the home screen and pick it up here.

Import CSV or Excel file

upload_file Drag and drop file here Up to 1.5 GB · CSV, TSV, XLSX, XLS · encoding & delimiter auto-detected

crm_contacts_raw.csv 684 KB

Preview: crm_contacts_raw.csv

4,210 rows, 6 columns

	Full Name	EmailAddr	Phone #	Signup	Amount Spent	Notes
0	Jane Doe	jane@acme.io	512-555-0190	01/04/2024	$1,204.50	VIP
1	Bob Smith	bob@globex.com	720-555-7781	02/11/2024	$88.00
2	Carla Reyes	carla@initech.net	415-555-3322	03/02/2024	$612.10	renewal
3	Dev Patel	dev@umbrella.co	206-555-9043	03/19/2024	$0.00

Options

Target schema

How would you like to define the target schema?

Build interactively (start from current columns) Import schema JSON Skip (rename / coerce only — no schema)

An interactive build is fastest for one-off cleanup. Import a JSON when you have a fixed contract (a CRM import format, db schema). Skip when you only want to rename or coerce specific columns.

Edit the table to define your target schema. Add rows for fields the input doesn't have yet (with a default), or remove rows for columns you want to drop.

Target name	Type	Required	Default (for added cols)	Aliases (comma-sep, helps fuzzy-match)
full_name	string	✗		Full Name, name
email	string	✓		EmailAddr, email_address
phone	string	✗		Phone #, tel
signup_date	date	✗		Signup
amount_spent	float	✗	0.0	Amount Spent
source	string	✗	crm-import
add add row

6 target fields · 1 added field (source) not present in the input.

Strategy

Preset

rename-only (just rename, leave types alone, keep extras) lenient-schema (rename + coerce + reorder, keep extras) strict-schema (rename + coerce + reorder, drop extras)

Advanced options

Unmapped source columns

keep

check Coerce types per schema

check Reorder to schema order

check Auto-infer mapping (fuzzy match)

Fuzzy match threshold

0.80

check Enforce required fields

Mapping

Source	Target	Auto-suggested
Full Name	full_name	✓
EmailAddr	email	✓
Phone #	phone	✓
Signup	signup_date	✓
Amount Spent	amount_spent	✓
Notes	(unmapped)	✗

Pick a target for each source column. Notes stays unmapped — with the lenient preset it is kept as-is. source is added from the schema default.

Results

Renamed

Dropped

Added

Coerce fails

infoAdded (with defaults): source

warningSome cells could not be coerced and were left as NaN: amount_spent (3)

Resolved mapping

source	target	auto
Full Name	full_name	True
EmailAddr	email	True
Phone #	phone	True
Signup	signup_date	True
Amount Spent	amount_spent	True

Mapped preview (first 10 rows)

	full_name	email	phone	signup_date	amount_spent	source	Notes
0	Jane Doe	jane@acme.io	512-555-0190	2024-01-04	1204.5	crm-import	VIP
1	Bob Smith	bob@globex.com	720-555-7781	2024-02-11	88.0	crm-import
2	Carla Reyes	carla@initech.net	415-555-3322	2024-03-02	612.1	crm-import	renewal
3	Dev Patel	dev@umbrella.co	206-555-9043	2024-03-19	0.0	crm-import
4	Mei Lin	mei@hooli.com	503-555-1188	2024-04-07	NaN	crm-import	trial