Standardize Formats

Runs 100% locally

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 · international-format phones (+1…) · USD European — DMY input · INTL phones · EUR comma decimal base 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 — based on European, 2 controls changed modified

rule Individual controls win over the preset. You started from European, then changed Ambiguous input order and Decimal separator below — so the preset is now Custom. The controls' current values are what actually run.

Pick a published standard or regional convention as the baseline. Every option below is still individually overridable; overriding any one switches the preset to Custom.

Dates

Output format

YYYY-MM-DD (ISO)

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

MDY (US) DMY (EU)

Winning value: MDY. Overrides the European base (DMY) — 01/02/2024 reads as 2024-01-02.

Phones

Output format

Standard international format (+15551234567)

Default region (ISO-2)

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

Currency

Decimal separator in input changed

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

Winning value: dot. Overrides the European base (comma) — $1,234.5 reads as 1234.50.

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. See Unparseable cells below to review them, or re-classify the column to (skip). (They aren't in the changes audit — nothing was changed.)

Unparseable cells (47)

Cells in typed columns that didn't match a recognizable shape and were left unchanged.

row	column	field_type	value (left as-is)
318	signup_date	date	soon
902	phone	phone	ext. 4471
1,544	amount	currency	TBD
2,087	active	boolean	maybe
3,610	signup_date	date	00/00/0000

… and 42 more.

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)

Showing 5 of 6 columns — notes is set to (skip), so it's omitted here.

	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

arrow_forwardFormats standardized. Next, most files need: Fix Missing Values →