PunkFix

Normalize Dates to ISO

Convert various date formats to ISO 8601. 100% private—your data stays in your browser.

No uploadsNo signupInstant results
1

Upload CSV

Drop file with inconsistent dates.

2

Parse & Format

We detect formats and convert to ISO 8601.

3

Download ISO File

Get standard YYYY-MM-DD dates.

Click to upload or drag & drop

Supported files: CSV, TXT, JSON (Max 20MB)

Drop your file here

or click to browse

CSV with mixed date strings.

Max 20MB 100% Private

What This Tool Does

This tool parses '1st Jan 2024', '01/01/24', and other formats, converting them all to the international standard YYYY-MM-DD.

How It Works

1Upload your file.
2Select the date columns.
3The tool intelligently parses the dates.
4It rewrites them as ISO stamps.

Input Format

CSV with non-standard dates.

Output Format

CSV with ISO-8601 dates.

When to Use This Tool

  • Preparing data for SQL database import.
  • Standardizing data for analysis.
  • Sorting by date isn't working in Excel.

Related Tools

Normalize Header Row

Clean up headers: trim spaces, standard casing, remove duplicates.

Remove Duplicate Rows

Find and remove exact duplicate lines within the CSV.

Split Huge CSV

Split large files into smaller chunks.

Merge CSV Files

Combine multiple CSVs into one (Union).

Browse all tools →