How to import data from HubSpot to Spreadsheets

Step-by-step guide to import data from HubSpot to Google Sheets or Microsoft Excel

Google Sheets

1. Preview Data

   After connecting your account, a data preview window will appear, allowing you to modify your Objects and apply various Filters to refine your data.

   
2. Add Associations

   You can also select Associations as per your need. Associations allow you to relationally join data from multiple HubSpot objects together.

   
3. Add/Modify columns

   Add/modify the data fields you want to import. The Fields you selected should start showing up in the data preview section.

   
4. Import Data

   After previewing the data, click on Import and wait for a few seconds. This action transfers all data from your HubSpot account into Google Sheets.

   
5. Setup an Auto-Refresh

   You can schedule a Refresh to automatically update your data hourly, daily, weekly, or monthly at a specific time.

   

If you want to export changes you made in the imported data back into HubSpot, head over to the Export Data tab or click on the box below.

Export Data

Step-by-step guide to export data from Google Sheets to HubSpot

Hope this guide helped you import your data from HubSpot to Google Sheets using Superjoin.

If you have any questions or need further assistance, please don’t hesitate to reach out to our support team. Thank you!

Microsoft Excel

1. Preview Data

   After connecting your account, a data preview window will appear, allowing you to modify your Objects and apply various Filters to refine your data.

   
2. Add Associations

   You can also select Associations as per your need. Associations allow you to relationally join data from multiple HubSpot objects together.

   
3. Add/Modify columns

   Add/modify the data fields you want to import. The Fields you selected should start showing up in the data preview section.

   
4. Import Data

   After previewing the data, click on Import and wait for a few seconds. This action transfers all data from your HubSpot account into Google Sheets.

   
5. You're all set!

   The desired data has been successfully written on to your Excel sheet. Now whenever you want fresh data, just click on the Pull Latest Data button.

   

Hope this guide helped you import your data from HubSpot to Microsoft Excel using Superjoin.

If you have any questions or need further assistance, please don’t hesitate to reach out to our support team. Thank you!