How to Import People Data from Basecamp into Excel

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

Learn how to import Basecamp People data into Excel using Coefficient to manage your team members.

“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

Getting your Basecamp People data into Excel helps you manage team lists, track roles, and get an overview of users. Relying on manual exports means dealing with old information fast.

Coefficient provides a direct link that updates your data live.

This guide will walk you through the steps to easily import your People data from Basecamp into Excel.

TLDR

  • Step 1:

    Step 1. Install Coefficient from the Office Add-ins store and connect to your Basecamp account.

  • Step 2:

    Step 2. Choose Import from… and select Basecamp.

  • Step 3:

    Step 3. Select the People object and pick the fields you need.

  • Step 4:

    Step 4. Import the data and set up auto-refresh for automatic updates.

Step-by-step guide to importing Basecamp People into Excel

Step 1: Install and connect Coefficient

Get Coefficient installed in your Excel first.

  1. Open Excel.
  2. Go to the Insert tab.
  3. Click on Get Add-ins.
  4. Search for and install “”Coefficient”” from the store.
  5. Launch the Coefficient add-in from the Home or Add-ins tab.
  6. Click “”Import from…”” in the sidebar and locate the Basecamp connector. Follow the steps to connect your Basecamp account.
Coefficient sidebar menu with import, export, automations, and AI Sheet Assistant options.

Step 2: Import the People data

With your account connected, you can now bring in the data.

  1. In the Coefficient sidebar for Basecamp, choose to import from an **Object**.
  2. Select the “”People”” object from the list provided.
  3. Pick the specific data fields from People that you want in your sheet.
  4. Set any filters or sort orders if needed.
  5. Click the “”Import”” button to pull the data into Excel.
Project management tools including Asana, Trello, Jira, and Notion displayed as connectors.

Step 3: Set up auto-refresh (Optional)

Keep your People data fresh without manual updates.

  1. After importing, find your import in the Coefficient sidebar next to the “”Refresh”” button.
  2. Click the settings icon next to Refresh.
  3. Select “”Schedule”” to set up automatic updates.
  4. Choose the frequency (like daily or hourly) and a time for the refresh to happen.
  5. Save your schedule. Your People data will update automatically.
Auto_refresh options for imported data with daily, hourly, and weekly scheduling.

Available Basecamp Objects

  • People
  • Messages
  • To-Do List
  • Calendar Events
500,000+ happy users
Get Started Now
Connect any system to Google Sheets in just seconds.
Get Started

Trusted By Over 50,000 Companies