When exporting reports to Excel the date field does not match that of the date entered in Hubspot. In reporting, the format v…

Updating solution to original post. The date can be adjusted by selecting the frequency setting on the property when customiz…

Edit your date property field in your report and select daily under frequency and the correct date will appear when exporting…

Thank you for the suggestion, I located that area and made an adjustment to my short date in Advance Settings and seems to he…

Can you explain where these settings are, please? I did change one frequency setting to monthly but the date is still wrong

That fixed the problem. Thank you !

I’m having the same issue. My spreadsheet is set to month day year, but the date still defaults to 1. Nov 23, 2023 = Nov 1, 2…

Report export to Excel Date Errors

karstenkoehler September 21, 2023, 4:28am 2

Could you give a few examples / share screenshots? It sounds like your region settings in Excel might be causing this, not necessarily the raw data.

Best regards

Topic		Replies	Views
Report days between, shows days in Hubspot but hours in export. 💬 RevOps Discussions	2	2690	January 31, 2022
Export of date picker field to Excel using Zapier APIs & Integrations cms-content , contacts , companies , developer-tools	3	5084	September 10, 2021
Exports: Date showing in USA format not the date selected in General Preferences HubSpot Ideas reports , object-importexport	0	90	August 4, 2025
Import: Probleme mit Datumsformat CRM enterprise	1	700	June 26, 2025
Re: Error Date Export Excel CRM	2	1091	November 9, 2021