Skip to main content

End-User: Get Started with Free HubSpot Excel Dashboard Templates

ExtendInsights | Download HubSpot data into Excel dashboards

CloudExtend offers free Excel dashboard templates for HubSpot. Each workbook includes charts and cards that use data in ExtendInsights tables. Download a workbook, connect to HubSpot, and download the data the dashboard needs.


Available templates

Download the templates from CloudExtend Dashboards.

Template

What it shows

HubSpot data it uses

Sales Team Performance

Win rate, new logo wins, and pipeline generated for weekly sales reviews

Deals

CRM and Sales Performance

Combined deal and contact views

Deals and Contacts

Inbound Leads

Contact data completeness and original source analysis

Contacts

Marketing Attribution and ROI

Revenue by channel using first-touch, last-touch, and position-based attribution models

Deals

Win/Loss Analysis

Win rate, won and lost revenue, deal counts over time, performance by sales rep and lead source, deal age and size patterns, and largest won and lost deals

Deals


Before you begin

Install the ExtendInsights Excel Data Connector and create a HubSpot connection. ➡️ See: Connecting to HubSpot.

To schedule refreshes, store the workbook in OneDrive for Business or SharePoint.


Load HubSpot data into a dashboard

  1. Download a dashboard workbook from CloudExtend Dashboards and open it in Excel.

  2. Open the ExtendInsights add-in. It recognizes the template tables in the workbook.

  3. Select your HubSpot connection.

  4. If the template includes a filter, such as a date range, set the values you want to report on. Turn off the filter to retrieve a larger dataset.

  5. Select Download. If the dashboard uses multiple templates, such as Deals and Contacts, download each one.

  6. Review the dashboard. Its cards and charts update based on the downloaded data.


Update HubSpot records from the workbook

You can edit values in an ExtendInsights table and upload the changes to HubSpot. For example, you can change a deal’s Is Closed value.

  1. Review the changes you made and select the rows to upload.

  2. In the Actions section, select Upload Rows.

ExtendInsights uploads the selected rows to HubSpot. Dashboard formulas that use the table recalculate based on its updated values.


Keep the dashboard current

  • Refresh on demand: download again at any time.

  • Schedule: save the workbook to OneDrive for Business or SharePoint, select Assign Schedule, create a schedule, and assign each template.

Use your own dashboard

If you already have an Excel dashboard, download your HubSpot data with ExtendInsights and update your formulas so they read from the ExtendInsights table.

Tips

  • Download only the date range you need to keep the workbook small.

  • Do not edit the hidden field-ID row above the column headers. It maps each column to a HubSpot property.

  • Use a blank worksheet when inserting a new template; inserting replaces the sheet contents.


💬 Need Help?

Search the CloudExtend Help Center for additional guidance.

If you still need assistance:

Did this answer your question?