Why do dates in my CSV import as text instead of dates in Excel or Google Sheets?

Spreadsheet tools use regional date format expectations. If your CSV contains dates in a format that does not match the application's locale (e.g., DD/MM/YYYY in a US-locale Excel), they are treated as text strings. Normalizing the CSV to the expected format before import resolves this.

Will normalizing numeric columns fix values that appear as text in my pivot table?

Yes. Numeric normalization rewrites values to a clean numeric format without symbols or formatting characters, which spreadsheet tools reliably interpret as numbers rather than text on import.

Can I automate this normalization step for recurring CSV imports?

Currently this tool is a manual upload-and-download workflow. For recurring imports, you can make normalizing the source file a standard step before triggering your automation each time.

Does this tool change any columns I do not specify?

No. Only the columns you name, or those auto-detected as numeric or date, are modified. All other columns are passed through unchanged.

Normalize CSV Types So Your Spreadsheet Automations Stop Breaking

Spreadsheet automations — whether Power Query refreshes, Excel macros, or Google Sheets importRange formulas — fail silently or loudly the moment a source CSV contains dates or numbers in unexpected formats. Deliteful's CSV Normalize Data Types tool standardizes your source files upfront so your automations run cleanly every time.

Create free account

Anyone who has built a spreadsheet automation around a recurring CSV import knows the frustration: the logic works perfectly until the source file arrives with dates formatted differently than last month, or with numeric values that include currency symbols the formula cannot parse. SUMIF returns zero, DATEVALUE throws an error, and the pivot table breaks. The root cause is not the formula — it is the inconsistent source data. Fixing it at the source is faster than defending against it with formula workarounds.

This tool gives you a clean, consistently formatted CSV every time. Upload your source file, specify or auto-detect the numeric and date columns that feed your automation, and download a normalized version. The output CSV will have dates in a single format and numeric values in a consistent representation — so your VLOOKUP, pivot table, or Power Query load works without modification.

How it works

1
Upload your source CSV
Upload the CSV file that feeds your spreadsheet automation or recurring import.
2
Name the columns to normalize
Enter the date and numeric column names that your formulas or automations depend on, or use auto-detection.
3
Choose your date output format
Match the date format your spreadsheet formulas or regional settings expect.
4
Download the normalized file
Replace your source CSV with the normalized version and run your automation as normal.

Frequently asked questions

Why do dates in my CSV import as text instead of dates in Excel or Google Sheets?: Spreadsheet tools use regional date format expectations. If your CSV contains dates in a format that does not match the application's locale (e.g., DD/MM/YYYY in a US-locale Excel), they are treated as text strings. Normalizing the CSV to the expected format before import resolves this.
Will normalizing numeric columns fix values that appear as text in my pivot table?: Yes. Numeric normalization rewrites values to a clean numeric format without symbols or formatting characters, which spreadsheet tools reliably interpret as numbers rather than text on import.
Can I automate this normalization step for recurring CSV imports?: Currently this tool is a manual upload-and-download workflow. For recurring imports, you can make normalizing the source file a standard step before triggering your automation each time.
Does this tool change any columns I do not specify?: No. Only the columns you name, or those auto-detected as numeric or date, are modified. All other columns are passed through unchanged.

Create your free Deliteful account with Google and normalize your CSV source files so your spreadsheet automations run without reformatting errors.