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.’
Type “Coefficient” in the search bar and click ‘Add.’
A pop-up will open up. Follow the prompts to complete the installation.
Once finished, you will see a “Coefficient” tab at the top navigation bar.
Click ‘Open Sidebar’ to launch Coefficient.
Select ‘Import from…’
Scroll down until you find Instagram Insights and click ‘Connect.’
Follow the prompts to authorize Coefficient to your Instagram account.
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.
Return to Instagram Insights from the Coefficient menu ‘Import from…’ > ‘Instagram Insights > ‘Start from Scratch.’
Select the Instagram Insight you want to import from then hit ‘Next.’
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.
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”.
Click ‘Import’ to automatically export your Instagram Insights data to 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.
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.’
Choose Instagram for Business as your trigger app and select the event that will trigger the workflow (e.g., New Report)
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.
Stop exporting data manually. Sync data from your business systems into Google Sheets or Excel with Coefficient and set it on a refresh schedule.
Select “Create Spreadsheet Row” as the action event.
Follow the prompts to connect your Microsoft account.
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.
Pros:
- Automates data transfer
- No coding required
- Flexible trigger options
Cons:
- 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.‘
The Apps Script editor will open in a new window.
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 = ‘https://graph.instagram.com/me/insights?access_token=’ + accessToken; var response = UrlFetchApp.fetch(apiURL); var json = response.getContentText(); var data = JSON.parse(json); data.data.forEach(function(insight) { sheet.appendRow([insight.name, 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.
Save the script and run it by clicking the play button in the Apps Script editor
Your data will automatically populate your Google Sheets spreadsheet.
Navigate to ‘File’ > ‘Download’ > ‘Microsoft Excel’ to download your .xlsx file.
From here, open Excel and import your file for analysis.
Pros
- Google Apps Script is free.
- There’s a robust community for support, script sharing, and troubleshooting.
Cons
- 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!
