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).

The Date Format setting only controls how dates are written on export - it doesn't change how DocuClipper read the dates, so there's no need to re-convert.

1. In the project, click Download Data to open the Download your data dialog.
2. Set Output Format to Excel.
3. 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
4. Download the file and open it.

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

The format you pick in the download dialog is saved and preselected for future downloads, for everyone on your team. Pick YYYY-MM-DD once and it stays.

See Customize date format for the download and profile date settings.

Related

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