)
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 exports dates as 13-digit Unix timestamps that appear as incomprehensible numbers like 1620710374103 in Google Sheets. While you could manually convert these using complex formulas, there’s a much simpler automated solution.
Here’s how to automatically convert HubSpot timestamps into properly formatted dates without writing a single formula.
Skip the formulas and get automatic date conversion using Coefficient
CoefficientHubSpoteliminates the timestamp conversion headache by automatically recognizing and formattingdate properties during import. When you pull data from HubSpot through Coefficient, those 13-digit numbers instantly become readable dates like 05/11/2021.
How to make it work
Step 1. Install Coefficient and connect your HubSpot account.
Add Coefficient to your Google Sheets from the Google Workspace Marketplace. Open the Coefficient sidebar and select “Connected Sources” to link your HubSpot account with the necessary permissions.
Step 2. Select your HubSpot data source and objects.
Choose the HubSpot object you want to import (contacts, deals, companies, etc.). Coefficient will display all available properties, including date fields that would normally export as timestamps.
Step 3. Choose your date properties and import.
Select the date fields you need like create date, last modified date, or custom date properties. Click “Import” and watch as Coefficient automatically converts all timestamp fields into properly formatted dates in your Google Sheets.
Step 4. Set up scheduled refreshes to maintain formatting.
Configure automatic data refreshes (hourly, daily, or weekly) to keep your data current. Each refresh maintains the proper date formatting without requiring manual intervention or formula updates.
Get clean HubSpot date data without the conversion hassle
Try CoefficientConverting HubSpot timestamps manually gets tedious fast, especially with large datasets. Coefficient handles the technical complexity automatically, giving you immediately usable date data for analysis and reporting.and skip the timestamp conversion formulas entirely.
