How to Import Products Data from Bigin into Excel

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

Learn how to import your Bigin Products data into Excel using Coefficient, enabling better product analysis, pricing strategies, and sales reporting.

“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

Having your Bigin Products data in Excel opens up advanced opportunities for product analysis, pricing optimization, and creating detailed sales reports that aren’t possible with Bigin’s standard reporting.

With Coefficient, you can establish a live connection that eliminates the need for manual exports and keeps your product data current in Excel.

TLDR

  • Step 1:

    Install Coefficient add-in through the Office Add-ins store

  • Step 2:

    Connect to your Bigin account

  • Step 3:

    Select Products data from available objects

  • Step 4:

    Import to Excel and set up automatic refreshes

Step-by-Step Guide to Importing Bigin Products into Excel

Step 1: Install Coefficient in Excel

First, add the Coefficient add-in to your Excel environment:

  1. Open Excel
  2. Click on the “Insert” tab in the ribbon
  3. Select “Get Add-ins”
  4. Search for “Coefficient” in the Office Add-ins store
  5. Click “Add” to install the Coefficient add-in
Coefficient sidebar menu with import, export, automations, and AI Sheet Assistant options.

Step 2: Connect to Bigin and Import Products Data

After installing Coefficient, follow these steps to import your Products data:

  1. Open the Coefficient sidebar in Excel
  2. Click “Import” to see available data sources
  3. Find and select “Bigin” from the CRM connectors list
  4. Log in with your Bigin credentials when prompted
  5. From the objects list, select “Products”
  6. Choose which product fields you want to include (e.g., name, price, category)
  7. Apply any filters if needed (e.g., only active products)
  8. Click “Import” to bring the data into your 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 Products data current without manual updates:

  1. Select your imported Products data in Excel
  2. In the Coefficient sidebar, click “Refresh”
  3. Choose “Set up auto-refresh”
  4. Select your preferred refresh schedule (hourly, daily, or weekly)
  5. Configure any notification settings
  6. Click “Save” to enable automatic updates
Auto-refresh options for imported data with daily, hourly, and weekly scheduling.

Available Bigin Data

Available Objects

  • Contacts
  • Companies
  • Pipelines
  • Products
  • Events
  • Tasks
  • Calls
500,000+ happy users
Get Started Now
Connect any system to Google Sheets in just seconds.
Get Started

Trusted By Over 50,000 Companies