Get ISO date format output from Google Sheets

DateFix converts any text date input into clean ISO 8601 formatted output with a single formula. Ideal for preparing data for APIs, databases, and downstream systems that require a consistent date format.

Get the Add-On See How It Works
Get ISO date format output from Google Sheets

See how DateFix outputs ISO format dates

Google Sheets does not output ISO 8601 by default. DateFix converts any date input into clean ISO formatted output with one formula.

Use DateFix on any sheet or CSV with messy or inconsistent dates
Call DateFix over a single cell to normalize the date output
Call DateFix over a range to normalize all dates
Call DateFix with a second argument of TIME or ISO, or a third argument of EU or US
Call DateFix over a range to normalize all dates
Call DateFix with a second argument of TIME or ISO, or a third argument of EU or US

Use DateFix to clean and normalize messy spreadsheet dates

Built for imported data, broken date columns, regional ambiguity, and real-world spreadsheets that need reliable date output.

Output ISO 8601 format in one step
Output ISO 8601 format in one step

Use =DATEFIX(A2,"ISO") to return clean YYYY-MM-DD output from any date input, regardless of the original format.

Works on any input format
Works on any input format

DateFix accepts dates in any format and converts them to ISO output. Mixed formats, regional variations, and text strings all work.

Clean an entire column at once
Clean an entire column at once

Run DateFix over a range to produce an ISO formatted output column ready for export or paste into another system.

Combine with datetime output
Combine with datetime output

Use =DATEFIX(A2,"ISO") alongside the TIME argument to produce full ISO datetime strings where needed.

How to use DateFix

Install the add-on, open it in your sheet, and use a simple formula in a new column.

Example formulas

=DATEFIX(A2:A100)

=DATEFIX(A2,"ISO")

=DATEFIX(A2,,"US")

Support & FAQs

ISO 8601 date format is YYYY-MM-DD, for example 2024-04-15. It is the standard format used by most APIs, databases, and data systems because it is unambiguous and sorts correctly as text.

Yes. DateFix processes each cell individually and outputs ISO format regardless of the input format in each cell. Pass "ISO" as the second argument: =DATEFIX(A2:A100,"ISO").

Yes. Use both the ISO and TIME arguments to produce full datetime output. Contact us for details on combining arguments for your specific use case.

DateFix is a Google Sheets add-on that helps clean and normalize messy or inconsistent date values with a simple custom function like =DATEFIX(A2:A10).

DateFix is free to use up to 100 rows per day. If that's insufficient, we offer an unlimited version for $19.99 / month, which allows an unlimited number of DateFix calls. You may upgrade within the DateFix add-on by clicking the upgrade button from the sidebar. Upgraded subscriptions may be cancelled at any time.

Still have questions? Get in touch

Related: Dates showing as text · CSV import dates not recognized · CRM export dates

arrow-up icon