How to Export Data from Basecamp and Import It into clariBI

How to Export CSV Data from Basecamp and Import It into clariBI

Basecamp is a project management and team communication tool. While Basecamp's native export format is HTML/JSON rather than CSV, you can still extract and convert your project data for analysis in clariBI.

What You Can Export from Basecamp

• To-do list items with assignees and due dates
• To-do completion status and dates
• Project names and descriptions
• Message board posts and discussions
• Schedule events and milestones
• Document and file references
• Campfire (chat) message logs
• Check-in question responses

Export CSV Data from Basecamp

Method 1: Export Project Data and Convert

1. Log in to your Basecamp account at basecamp.com
2. Navigate to Adminland (click your avatar in the top right and select Adminland)
3. Click Export data from this account
4. Basecamp will prepare an export of all project data, typically in HTML or JSON format

Note: Only account owners can create exports. Regular users do not have access to the Adminland export option.
6. Download the export file when ready
7. Open the downloaded to-do list data in a text editor or JSON viewer
8. Use a JSON-to-CSV converter tool (such as json-csv.com or ConvertCSV.com) to convert the to-do items into CSV format
9. Save the resulting CSV file

Method 2: Copy To-Do Data to a Spreadsheet

1. Open your Basecamp project and navigate to the To-dos section
2. For each to-do list, review the items with their assignees, due dates, and statuses
3. Select and copy the to-do items from the page (or manually enter them into a spreadsheet)
4. Organize the data into columns: Task Name, Assignee, Due Date, Status (Complete/Incomplete), List Name
5. Save the spreadsheet as a CSV file

Method 3: Use the Basecamp API

1. Access the Basecamp API documentation at github.com/basecamp/bc3-api
2. Use API endpoints to retrieve to-do lists and to-do items programmatically
3. Common endpoints include `/buckets/{project_id}/todolists.json` and `/buckets/{project_id}/todos.json`
4. Parse the JSON response and convert the relevant fields to CSV format
5. Save the resulting CSV file for import into clariBI

Method 4: Use a Third-Party Integration Tool

1. Sign up for a tool like Zapier, Make (Integromat), or a Basecamp reporting add-on
2. Connect your Basecamp account to the integration tool
3. Set up a workflow that extracts to-do items, projects, or schedules from Basecamp
4. Configure the output to save as a CSV file or Google Sheet
5. Download the resulting CSV for import into clariBI

Tips for Clean Exports

• Focus on to-do list data for the most structured and analysis-friendly export from Basecamp
• Include the to-do list name as a column to group tasks by category or project phase in clariBI
• Since Basecamp does not natively export CSV, establish a regular workflow (API script or integration tool) to automate the conversion process

Import Your Data into clariBI

1. Log in to your clariBI account at claribi.com
2. Click Data Sources in the left sidebar
3. Click the + Add Source button (top right)
4. Under Direct Upload, select CSV File
5. Enter a descriptive name (e.g., "Basecamp - Project To-Dos Q1 2025")
6. Click the upload area or drag and drop your CSV file
7. Click Create Data Source

Once imported, you can ask clariBI questions like:
- "What percentage of to-do items are completed versus incomplete across all projects?"
- "Which team members have the most overdue tasks?"
- "Show me the to-do completion trend over the past 3 months."

clariBI's AI will automatically analyze your data and suggest relevant insights.