visibility Static layout preview of Standardize Formats, shown with a file imported from the upload screen and a completed run (results + changes audit + standardized preview). All pages →

# 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)
US
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
2
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
47
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 →