Guides: cleaning the data that real files hold
Each guide takes a column as it appears in real files, cleans it with Data Cleaner and shows the answer.
- Day-first or month-first? Cleaning a column of dates like 03/04/2025
Is 03/04/2025 the 3rd of April or the 4th of March? Clean a whole column of slash dates to ISO 8601 and see which cells were ambiguous. - Dates written in words: German, French and Italian months to ISO 8601
4 März 2025, 12 janvier 2024, 3 aprile 2023: turn dates written with month names in German, French or Italian into ISO 8601 dates. - Swiss and European number formats: 1'234.50 and 1.234,50 to plain numbers
Clean numbers written with Swiss apostrophes (1'234.50) or European separators (1.234,50) into plain decimal numbers you can sum. - Months and quarters: Jan-24 and Q3 2024 as sortable periods
Turn month and quarter labels such as Jan-24 or Q3 2024 into sortable ISO-style periods (2024-M01, 2024-Q3) instead of text or the first day of a month. - Currency amounts: 1.234,50 € and $1,200.00 to a currency code and a number
Split amounts such as 1.234,50 €, € 99,90 or $1,200.00 into an ISO currency code and a plain number, with a flag where a symbol stands for several currencies. - Timestamps in mixed formats: ISO 8601 with offsets, Z and European dates
Clean a column of timestamps written as 2025-03-04T10:00:00+01:00, 2025-03-04T08:30:00Z or 04.03.2025 10:15 into one ISO 8601 format, keeping each offset.