Last updated: March 5, 2024
Available with any of the following subscriptions, except where noted:
All products and plans
|
To view the history of a property's values across all records, you can export a property's historical data. Once you've exported a property's history, you can use the data to restore past values if properties were updated by mistake.
If you want to export all property values on a specific record, learn how to view a record’s property history instead.
Export a property's historical data
When you export a property's history, the exported file will include all records, the property's current and historical values, and when the values were updated. You can also select to view how the value was changed (e.g., which user or tool triggered the update).
Please note: the limit on the number of revisions saved in each property's history is based on the object. The following limits apply to all revisions, including both those made within HubSpot and via API:
- Contact properties: up to 45 revisions.
- Company, deal, ticket, and custom object properties: up to 20 revisions.
-
In your HubSpot account, click the settings icon in the top navigation bar.
-
In the left sidebar menu, navigate to Properties.
-
Click the Select an object dropdown menu, then select the [object] properties for the object whose property you want to export.
-
Hover over the property, click More, then select Export property history.
-
In the dialog box:
-
Select a File format.
-
To include the user/tool that updated the value in the file, select the Include Source Information checkbox.
-
Click Export.
-
Once the export is processed, you'll receive a download link through email and in your notification center.
Please note: the export file uses the UTC (Coordinated Universal Time) time zone for change dates. You may need to convert the time to your local time zone to confirm the date and time the property value was updated.
Restore property values using historical data
If property values on your records were changed by mistake, you can restore previous values by exporting the property's history, then importing historical data.
- Export the history of a property.
- In the exported file, the values are shown left to right from the most recent to the oldest value. Apply a filter to the column with the most recent values by the date the incorrect change was made. Once filtered, only records updated on that date will remain in the file.
- For the affected records, copy the Record ID column and the column with the next most recent values (i.e. the values prior to the most recent update).
- Create a new file, and paste those columns into the file.
- Import the new file into HubSpot.
Following the import, the property on affected records will be updated to their previous values.
