When HubSpot date properties appear as numbers like 1620710374103 in Google Sheets exports, it indicates the timestamps weren’t converted from Unix millisecond format. This makes date-based analysis impossible until you fix the formatting issue.
Here’s how to ensure HubSpot date properties import as properly formatted dates from the start.
Prevent the number formatting problem using Coefficient
CoefficientHubSpotaddresses this common integration issue through specialized-Google Sheets connectivity that automatically recognizes date properties during import and applies appropriate formatting transformations.
How to make it work
Step 1. Use Coefficient instead of standard HubSpot exports.
Install Coefficient from the Google Workspace Marketplace and connect your HubSpot account through the sidebar. This bypasses the formatting limitations of HubSpot’s standard export methods.
Step 2. Select HubSpot objects and date properties.
Choose your desired HubSpot objects (contacts, deals, companies) and select the date properties you need. Coefficient identifies timestamp fields like creation dates, modification dates, deal close dates, and custom date fields.
Step 3. Import with automatic date formatting applied.
Click “Import” to pull your data. Coefficient automatically converts all timestamp properties into properly formatted dates that Google Sheets recognizes, eliminating the number display issue entirely.
Step 4. Maintain proper formatting with scheduled refreshes.
Set up automatic data refreshes to keep your information current. Each refresh maintains consistent date formatting across all imported records, regardless of the original timestamp precision from HubSpot.
Get clean date data without post-import fixes
Start usingFixing timestamp formatting after export wastes time and creates opportunities for errors. Coefficient ensures your HubSpot date properties import correctly from the start, maintaining data integrity for immediate analysis and reporting.Coefficient for properly formatted HubSpot date imports.