Standardize Formats

Make dates, phones, currency, and names look the same throughout.

description Using customers_export.csv from the upload screen.

Preview: customers_export.csv

18,442 rows, 6 columns

	full_name	phone	amount	signup_date	active
0	jane DOE	(512) 555-0190	$1,234.5	01/04/2024	Y
1	bob smith	720.555.7781	$99	2024-2-11	yes
2	ALICIA REYES	+1 415 555 2233	$45,000	Mar 3, 2024	n
3	m. okafor	2125550148	$7.999	2024/04/22	true

Options

Column types

Assign each column to a field type. Auto-detected suggestions are pre-filled; pick (skip) to leave a column untouched.

full_name

Name

phone

Phone

amount

Currency

signup_date

Date

active

Boolean

notes

(skip)

Format options

Standards preset

US (default) — ISO 8601 dates · E.164 phones · USD European — DMY input · INTL phones · EUR comma decimal UK — DD/MM/YYYY · GB phones · Yes/No booleans ISO Strict — ISO 8601 · bare-number currency · true/false Legacy US — MM/DD/YYYY · National phones · Yes/No Custom — keep current settings

Pick a published standard or regional convention as the baseline. Every option below is still individually overridable.

Dates

Output format

YYYY-MM-DD (ISO)

Ambiguous input order (e.g. 01/02/2024)

MDY (US) DMY (EU)

Phones

Output format

E.164 (+15551234567)

Default region (ISO-2)

Region used when the input has no country code. US, GB, DE, etc.

Currency

Decimal separator in input

dot (1,234.56) comma (1.234,56)

Round to decimals

Preserve original precision (don't round)

Preserve currency code (emit USD 1234.56, EUR 99.00, etc.)

Names

Casing

Title Case

Booleans

Output style

True/False

Results

Cells scanned

92,210

Cells changed

61,838

% changed

67.1%

Unparseable

info 47 cell(s) in typed columns didn't match a recognizable shape and were left as-is. Check the changes audit below to find them, or re-classify the column to (skip).

Changes by column

column	field_type	cells_changed
amount	currency	17,902
full_name	name	16,041
phone	phone	14,388
signup_date	date	11,205
active	boolean	2,302

Examples (first 25 changes)

row	column	field_type	before	after
1	full_name	name	jane DOE	Jane Doe
1	phone	phone	(512) 555-0190	+15125550190
1	amount	currency	$1,234.5	1234.50
1	signup_date	date	01/04/2024	2024-01-04
1	active	boolean	Y	True
2	full_name	name	bob smith	Bob Smith
2	phone	phone	720.555.7781	+17205557781
2	signup_date	date	2024-2-11	2024-02-11
3	signup_date	date	Mar 3, 2024	2024-03-03
4	amount	currency	$7.999	8.00

Standardized preview (first 10 rows)

	full_name	phone	amount	signup_date	active
0	Jane Doe	+15125550190	1234.50	2024-01-04	True
1	Bob Smith	+17205557781	99.00	2024-02-11	True
2	Alicia Reyes	+14155552233	45000.00	2024-03-03	False
3	M. Okafor	+12125550148	8.00	2024-04-22	True