How to Import All Help Centers Data from Intercom into Excel

using Coefficient excel Add-in (500k+ users)

Learn how to efficiently import Intercom Help Centers data into Excel using Coefficient to analyze knowledge base performance and improve customer self-service.

“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.”

5 star rating coeff g2 badge

Importing All Help Centers data from Intercom into Excel helps you analyze your knowledge base performance and optimize self-service content. Coefficient makes this process seamless and automatic.

This guide will show you how to import your Intercom Help Centers data into Excel using Coefficient.

TLDR

  • Step 1:

    Step 1. Open Excel > Insert tab > Get Add-ins > Install Coefficient from Office Add-ins store.

  • Step 2:

    Step 2. Connect your Intercom account and select the All Help Centers object to import.

  • Step 3:

    Step 3. (Optional) Enable auto-refresh to keep your data updated automatically.

Step-by-Step Guide to Import Intercom Help Centers Data into Excel

Step 1: Install Coefficient in Excel

First, you need to install the Coefficient add-in from the Office Add-ins store:

  • Open Excel
  • Go to the Insert tab
  • Click on Get Add-ins
  • Search for “Coefficient”
  • Click Add to install the add-in
  • Once installed, click on the Coefficient icon to open the sidebar
Coefficient sidebar menu with import, export, automations, and AI Sheet Assistant options.

Step 2: Connect to Intercom and Import All Help Centers Data

Now, connect Coefficient to your Intercom account:

  • In the Coefficient sidebar, click on “Import from…”
  • Scroll to find and select “Intercom” from the list of available connectors
  • Log in with your Intercom credentials when prompted
  • Once connected, select “All Help Centers” from the list of available objects
  • Choose the fields you want to import
  • Click “Import” to bring the data into your Excel spreadsheet
CRM and sales connectors like Salesforce, HubSpot, Pipedrive, and Gong shown in list view.

Step 3: Set Up Auto-Refresh (Optional)

To keep your Help Centers data up to date automatically:

  • Click on the three dots (…) next to your imported data
  • Select “Auto-refresh”
  • Choose your preferred refresh schedule (hourly, daily, or weekly)
  • Click “Save” to activate auto-refresh
Auto-refresh options for imported data with daily, hourly, and weekly scheduling.

Available Intercom Objects

  • Teams
  • Company Segments
  • Conversations
  • All Help Centers
  • All Collections
  • News Items
  • Tickets
  • Articles
  • Companies
  • Contacts

Frequently Asked Questions

  • How to get All Help Centers from Intercom?

    down-chevron

    Accessing Help Centers information in Intercom requires navigating through their admin interface, which doesn’t easily provide comprehensive data for analysis.Coefficient creates a direct connection between Intercom and Excel, allowing you to import Help Centers data with a few clicks for immediate analysis and reporting.

  • How do I get a list of All Help Centers in Intercom?

    down-chevron

    Within Intercom, you can view Help Centers in their interface, but extracting metadata and performance metrics as a comprehensive list requires multiple steps.With Coefficient, you can pull a complete list of all Help Centers from Intercom directly into Excel, making it easy to track and optimize your knowledge base strategy.

  • How do I import All Help Centers from Excel to Intercom?

    down-chevron

    Creating or modifying Help Centers in Intercom typically requires working through their interface, which is time-consuming for comprehensive updates.Coefficient’s two-way sync functionality allows you to prepare Help Center structures in Excel and push them back to Intercom, streamlining your content management workflow.

  • How do I update All Help Centers from Excel to Intercom?

    down-chevron

    Updating Help Centers information in Intercom requires manual navigation through their content management system for each change.With Coefficient, you can make bulk edits to your Help Centers data in Excel and sync those changes back to Intercom in one action, saving significant time for content teams.

  • How to automate importing Intercom All Help Centers to Excel daily?

    down-chevron

    Manually exporting Help Centers data from Intercom on a regular basis is time-consuming and often neglected, leading to outdated analytics.Using Coefficient’s auto-refresh feature, you can schedule daily updates of your Help Centers data, ensuring you always have the latest information for performance tracking and optimization.

500,000+ happy users
Get Started Now
Connect any system to Google Sheets in just seconds.
Get Started

Trusted By Over 50,000 Companies