)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
HubSpot’s Unix timestamp milliseconds appear as 13-digit numbers like 1620710374103 in spreadsheet exports, making date analysis nearly impossible. These epoch time values need conversion to standard date formats before you can use them for reporting or calculations.
Here’s how to automatically transform these timestamp numbers into readable dates without managing complex conversion formulas.
Automatically convert timestamp milliseconds during import using Coefficient
CoefficientHubSpot’sHubSpotrecognizestimestamp format and automatically converts epoch time values into standard dates during import. This works for contact creation dates, deal close dates, and custom date properties across bothobjects.
How to make it work
Step 1. Connect HubSpot through Coefficient’s sidebar.
Install Coefficient in your spreadsheet application and navigate to “Connected Sources” in the sidebar. Add your HubSpot account with the appropriate permissions for the objects you want to import.
Step 2. Select your HubSpot objects and timestamp fields.
Choose the HubSpot objects containing the timestamp data you need. Coefficient displays all available properties, automatically identifying which fields contain timestamp data that requires conversion.
Step 3. Import with automatic timestamp conversion.
Select your desired timestamp fields and click “Import.” Coefficient processes the 13-digit millisecond values and converts them to properly formatted dates that your spreadsheet recognizes for sorting, filtering, and calculations.
Step 4. Configure scheduled refreshes for ongoing data.
Set up automatic imports to run hourly, daily, or weekly. Each scheduled refresh maintains the proper date formatting, ensuring your timestamp conversion stays consistent as new data flows in from HubSpot.
Stop wrestling with timestamp conversion formulas
Get startedManual timestamp conversion becomes unmanageable with large datasets and multiple date fields. Coefficient handles the millisecond-to-date transformation automatically, giving you clean, analysis-ready data from the start.with automated HubSpot timestamp conversion today.
