How to Export Instagram Insights to Excel

Last Modified: April 24, 2024 - 6 min read

Julian Alvarado

Instagram Insights gives you valuable data about your audience and campaigns, but making sense of it all can be a struggle.

What if you could easily export that data to Excel, where you’re more comfortable working?

In this blog post, we’ll show you three ways to get your Instagram Insights data into Excel: Coefficient, Zapier, and Google Sheets App Scripts.

Can I Download Instagram Analytics to Excel?

Instagram doesn’t have a built-in way to download reports, but that doesn’t mean it’s impossible. With the right tools and a bit of know-how, you can export your Instagram Insights data to Excel in just a few clicks.

How to Export Instagram Insights to Excel: 3 Methods

Method 1| Coefficient: No-Code, Fully Automated

Coefficient makes it easy to connect your Instagram business account to Excel, so you can track post performance and create comprehensive dashboards that combine data from all your marketing platforms.

To install Coefficient, open Excel from your desktop or in Office Online.

Click ‘File’ > ‘Get Add-ins’ > ‘More Add-Ins.’

Navigating to 'File', then 'Get Add-ins', and selecting 'More Add-Ins' in Excel to install Coefficient.

Type “Coefficient” in the search bar and click  ‘Add.’

Typing "Coefficient" in the Excel Add-ins search bar.

A pop-up will open up. Follow the prompts to complete the installation.

Following the installation prompts in the Coefficient pop-up window.

Once finished, you will see a “Coefficient” tab at the top navigation bar.

Click ‘Open Sidebar’ to launch Coefficient.

Coefficient tab visible on Excel's top navigation bar after successful installation.

Select ‘Import from…’

Launching the Coefficient sidebar by clicking 'Open Sidebar'.

Scroll down until you find Instagram Insights and click ‘Connect.’

Selecting 'Import from…' within the Coefficient sidebar in Excel.

Follow the prompts to authorize Coefficient to your Instagram account.

Scrolling to find and clicking 'Connect' next to Instagram Insights in Coefficient.

You will be redirected to the Facebook page below where you need to enter your Facebook (Social) email and password, then click “Log In” to authenticate for Instagram. If successful, you will be shifted back to your sheet and you can now start creating Instagram Insights imports.

Authorizing Coefficient to access your Instagram account by following the prompts.

Return to Instagram Insights from the Coefficient menu ‘Import from…’ > ‘Instagram Insights > ‘Start from Scratch.’

clicking start from scratch

Select the Instagram Insight you want to import from then hit ‘Next.’

Returning to Coefficient to select and customize Instagram Insights data for import.

Select the fields you need from the left side tab by clicking the white box beside the field name. The data previewer shows a sample of the data from the fields you select.

further customizing import settings

Customize your import by adding date filters as needed. Click the “Refresh Preview” option to update the sample data based on the customizations that are added. Then “Import”.

Finalizing import settings in Coefficient and clicking 'Import' to export data to Excel.

Click ‘Import’ to automatically export your Instagram Insights data to Excel.

a screenshot of data automatically populating excel

You can also set up automatic data updates to schedule data syncs between Instagram and Excel. Choose whether to run daily, hourly, or weekly automatic data updates.

Setting up automatic data updates between Instagram Insights and Excel in Coefficient.

With automatic data updates, your Instagram data is always up-to-date in your spreadsheet. That means you can build live dashboards and reports on top of the data without performing cumbersome manual updates.

  • Pros:
    • No Code Required: Simply install Coefficient to your spreadsheet and connect it to  Instagram Insights. It’s user-friendly and doesn’t demand any coding expertise.
    • Saves Time: Connecting Instagram Insights to Google Sheets or Excel is quick and straightforward, eliminating manual data transfers and saving valuable hours.
    • Live Data: Changes in your  Instagram Insights data are instantly reflected in your spreadsheet, ensuring you always work with up-to-date information for better reporting and analysis.

Cons: The only downside to Coefficient is that any scheduled automations are not free forever. However, its pricing plans are affordable, and its benefits far outweigh the app’s costs.

Method 2| Zapier

Zapier Integration Zapier is a web-based service that allows you to create automated workflows between different apps, including Instagram Insights and Excel.

Here’s a step-by-step guide on how to set it up:

Log into your Zapier account. Click ‘+ Create’ > ‘New Zap.’

Initiating the setup of a new Zap by selecting '+ Create' > 'New Zap'.

Choose Instagram for Business as your trigger app and select the event that will trigger the workflow (e.g., New Report)

Choosing Instagram for Business as the trigger app in the Zap setup.

Choose Instagram for Business as your trigger app and select the event that will trigger the workflow (e.g., New Report). Follow the prompts to connect your Instagram for Business account to Zapier.

Connect your Instagram for Business account to Zapier by providing your API key, following the steps above.

Choose Microsoft Excel Online as your action app.

Coefficient Excel Google Sheets Connectors
314,000 Pros Sync Live Data from Their Business Systems into Spreadsheet

Stop exporting data manually. Sync data from your business systems into Google Sheets or Excel with Coefficient and set it on a refresh schedule.

Choosing Microsoft Excel Online as the action app in the Zapier workflow setup.

Select “Create Spreadsheet Row” as the action event.

Setting 'Create Spreadsheet Row' as the desired action event in Zapier’s workflow.

Follow the prompts to connect your Microsoft account.

following the prompts to connect

From here:

  • Map the data fields from Instagram for Business to the corresponding columns in your Excel spreadsheet.
  • Test your Zap to ensure it’s working correctly.
  • Turn on your Zap, and it will automatically add new Microsoft Ads data to your Excel spreadsheet as it comes in.


  • Automates data transfer
  • No coding required
  • Flexible trigger options


  • Requires a Zapier subscription for advanced features
  • May have customization limitations

Method 3| Google Scripts to Excel

If you’re comfortable with JavaScript, you can use Google Sheets App Scripts to import Instagram Insights data and then download it as an Excel file.

What you’ll need:

  • Basic understanding of JavaScript.
  • An Instagram Access Token, obtained by creating an app on the Facebook Developer site.
  • The Instagram API endpoint URL for fetching Insights data.

Navigate to Google Sheets and on ‘Extensions’ > ‘Apps Script.‘

Accessing the Apps Script editor from the Google Sheets Extensions menu

The Apps Script editor will open in a new window.

Pasting a custom script into the Google Sheets Apps Script editor for Instagram Insights integration

Copy and paste the following script into the Apps Script editor:

function importInstagramData() {  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(“Instagram Insights”);  var accessToken = ‘YOUR_INSTAGRAM_ACCESS_TOKEN’;  var apiURL = ‘’ + accessToken;  var response = UrlFetchApp.fetch(apiURL);  var json = response.getContentText();  var data = JSON.parse(json); {    sheet.appendRow([, insight.period, insight.values[0].value]);  });}

Script Breakdown:

  • The script targets a specific sheet tab for data storage.
  • Replace ‘YOUR_INSTAGRAM_ACCESS_TOKEN’ with your actual Instagram Access Token.
  • The script automatically retrieves and adds Instagram Insights data to your Google Sheet.
Running the custom script in Google Sheets Apps Script editor for Instagram data import.

Save the script and run it by clicking the play button in the Apps Script editor

Setting up automatic data update triggers in Google Sheets Apps Script for Instagram Insights.

Your data will automatically populate your Google Sheets spreadsheet.

Navigate to ‘File’ > ‘Download’ > ‘Microsoft Excel’ to download your .xlsx file.

Exporting the populated Google Sheets spreadsheet as a Microsoft Excel file via 'File' > 'Download'.

From here, open Excel and import your file for analysis.


  • Google Apps Script is free.
  • There’s a robust community for support, script sharing, and troubleshooting.


  • Google Apps Script requires a good grasp of coding for basic functions.
  • There are daily quotas on automation capabilities.
  • Scaling and managing scripts across multiple sheets or users can be complex.

Take Control of Your Instagram Data

Don’t let Instagram Insights data overwhelm you. Choose the export method that works best for your skills and needs, and start making data-driven decisions to grow your presence on the platform.

For a fast, easy, and reliable solution, try Coefficient. Get started today for free!

Sync Live Data into Your Spreadsheet

Connect Google Sheets or Excel to your business systems, import your data, and set it on a refresh schedule.

Try the Spreadsheet Automation Tool Over 350,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 350,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Julian Alvarado Content Marketing
Julian is a dynamic B2B marketer with 8+ years of experience creating full-funnel marketing journeys, leveraging an analytical background in biological sciences to examine customer needs.
350,000+ happy users
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies