Accessing your Basecamp Projects data in Excel helps you track project status, analyze performance, and manage your portfolio. Manually exporting this data is slow and quickly becomes outdated.
Using Coefficient creates a live link that automatically refreshes.
This guide shows you how to easily get your Projects data from Basecamp right 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. Select Import from… and choose the Basecamp connector.
-
Step 3:
Step 3. Pick the Projects object and configure your import options.
-
Step 4:
Step 4. Import the data to your Excel sheet and set up auto-refresh.
Step-by-step guide to importing Basecamp Projects into Excel
Step 1: Install and connect Coefficient
First, you need to get Coefficient for Excel.
- Open Excel.
- Go to the Insert tab.
- Click on Get Add-ins.
- Search for “”Coefficient”” and install it from the Office Add-ins store.
- Once installed, open the Coefficient add-in from the Home tab or the Add-ins tab.
- In the Coefficient sidebar, click “”Import from…”” and find the Basecamp connector. You’ll be guided to log in and connect your Basecamp account.

Step 2: Import the Projects data
Now that you’re connected, let’s get the data.
- In the Coefficient sidebar, with Basecamp selected, choose to import from an **Object**.
- Find and select the “”Projects”” object from the list.
- Choose the specific fields you want to bring into Excel.
- Apply any filters or sorting needed for your data.
- Click the “”Import”” button.

Step 3: Set up auto-refresh (Optional)
Keep your Projects data current without manual effort.
- After your data is imported, look for the “”Refresh”” button in the Coefficient sidebar next to your import.
- Click the refresh options icon (usually a small clock or settings gear).
- Choose “”Schedule”” to set up automatic refreshes.
- Select how often you want the data to update (e.g., daily, hourly) and pick a time.
- Save your schedule. Your Projects data will now update on its own.

Available Basecamp Objects
- People
- Messages
- To-Do List
- Calendar Events
Trusted By Over 50,000 Companies