Dates Show as NaN or #VALUE! in Excel

NaN, #VALUE!, or raw text like 15/03/2024 appearing in the Date column of your Excel export means Excel's regional setting doesn't match the date format DocuClipper used when writing the file. Excel couldn't parse the string into a real date, so it kept it as text.

The fix is to pick a different date format when you download (no need to re-convert).

Pick a format that Excel will parse

1. In the project, click Download Data again.
2. In the Date Format dropdown, pick one that matches your Excel regional setting:
   • US Excel → MM/DD/YYYY
   • UK / EU Excel → DD/MM/YYYY
   • Universal / safest → YYYY-MM-DD (ISO); Excel parses this regardless of regional setting
3. Click Download and open the new file.

Still seeing NaN after changing format

If dates remain as text even in ISO format:

• Select the Date column → Data → Text to Columns → Finish. This forces Excel to re-parse the column.
• Or select the cells, right-click → Format Cells → Date → pick a format.

Avoiding it next time

Set your DocuClipper profile date format to YYYY-MM-DD by default:

• Settings → Profile → Date Format.

See Customize date format for per-download, per-profile, and per-project overrides.

Related

• Customize date format
• Correcting the year
• Downloading bank transactions