Trello CSV Import on Free Plan: What Works in 2026

Here's an uncomfortable truth that Trello doesn't prominently advertise: there's no native CSV import feature. Not on the free plan. Not on paid plans either. Trello just doesn't have a built-in tool to import spreadsheet data.

If you've spent the last hour searching for a hidden menu or obscure setting to bulk import your tasks from a CSV file, you can stop. Trello's official documentation states it plainly: "Trello doesn't have a generic import tool."

But here's the good news: free plan users get unlimited Power-Ups per board. Not a typo. While Trello restricts boards, collaborators, and file sizes on the free tier, Power-Ups are unlimited. Several CSV import solutions work perfectly on free accounts.

This guide covers every method to import CSV data into Trello on a free plan. We'll rank them by cost, complexity, and what you actually get.

What Trello Officially Offers for Data Import

According to Trello's support documentation, you have three official options:

1. Copy-paste - Paste text into Trello where each new line becomes a new card (titles only)
2. Trello API - Build your own import solution with code
3. Third-party Power-Ups - Install tools that add CSV import functionality

That's it. No hidden import menu. No "File > Import > CSV" option tucked away somewhere.

This limitation shapes which solution makes sense for you. A one-time migration of 50 tasks needs a different approach than weekly imports of sales leads.

Free Plan Features That Actually Matter for CSV Import

Here's what the Trello free plan includes and excludes:

Two features stand out: unlimited Power-Ups and full API access. Every CSV import method below relies on one of these.

The Custom Fields limitation matters if your CSV has fields beyond title, description, due date, labels, and members. Standard card fields work fine. Custom data requires a Standard plan ($5/month) or higher.

Power-Ups That Import CSV on Free Trello Accounts

Power-Ups are Trello's plugin system. Several third-party developers have built CSV import tools that work on free Trello accounts. Here are the main options with current pricing.

Import to Trello by Blue Cat

The most popular option with over 100,000 installs. I think it's the best starting point for most people.

Blue Cat maps most fields you'd expect:

• Card title via name, title, or card name column
• Description via description, desc, or card description
• List assignment via list column
• Labels (comma-separated), due dates (ISO format recommended), member assignment
• Checklists and checklist items

Best for: One-time migrations or infrequent imports. Ten free imports is generous if you consolidate data into fewer, larger CSV files.

Excelefy

A budget-friendly alternative with 10,000+ installs.

Excelefy handles similar fields: list name, card name, description, due date, start date, labels, members, and checklists. It also imports a "due complete" field for marking tasks done, which is a nice touch.

Best for: Teams needing ongoing imports at the lowest subscription cost.

Smart Import from Excel, CSV

Best annual pricing at $24/year, though no free trial (which is annoying).

Smart Import includes visual preview before importing and can write to Custom Fields. You'll need a Standard Trello plan for Custom Fields to exist in the first place.

Best for: Annual subscribers who want the lowest per-month cost.

Power-Up Pricing Comparison

For truly free import, Blue Cat's 10-import allowance is your best bet. For ongoing needs, Smart Import at $24/year ($2/month effective cost) offers the best value.

Completely Free Methods (No Subscriptions)

If you need more than 10 imports but refuse to pay, these methods trade effort for money. Fair warning: some require technical skills.

Method 1: Native Copy-Paste

Simplest method. No Power-Up needed.

1. Open your spreadsheet (Excel, Google Sheets, etc.)
2. Select the column containing task names
3. Copy (Ctrl+C or Cmd+C)
4. In Trello, click "Add a card" on your target list
5. Paste - each line becomes a separate card

What this imports: Card titles only.

What this doesn't import: Descriptions, due dates, labels, members, checklists, or anything else.

This works for simple task lists where you only need card names. You can manually add details after importing, though honestly that defeats much of the point.

Method 2: Trello API (Free, Unlimited, Requires Code)

The Trello API is available on all plans including free. With some JavaScript knowledge, you can build an unlimited CSV import at zero cost.

Key endpoint:

POST https://api.trello.com/1/cards

Here's a working Node.js script:

const createTrelloCard = async (name, description, listId) => {
  const response = await fetch(
    `https://api.trello.com/1/cards?` +
    `key=${process.env.TRELLO_API_KEY}&` +
    `token=${process.env.TRELLO_TOKEN}&` +
    `idList=${listId}&` +
    `name=${encodeURIComponent(name)}&` +
    `desc=${encodeURIComponent(description)}`,
    { method: 'POST' }
  );
  return response.json();
};

// Batch import with rate limiting
const importCSVToTrello = async (records, listId) => {
  for (const record of records) {
    await createTrelloCard(record.name, record.description, listId);
    // Rate limit: 100 requests per 10 seconds
    await new Promise(resolve => setTimeout(resolve, 100));
  }
};

Rate limits:

• 300 requests per 10 seconds per API key
• 100 requests per 10 seconds per token

The 100ms delay keeps you safely under limits. You'll import roughly 600 cards per minute.

To get API credentials:

1. Go to https://trello.com/power-ups/admin
2. Create a new Power-Up (or use an existing one)
3. Generate an API key
4. Generate a token with write access

Best for: Developers or anyone comfortable running JavaScript. Free with no limits.

Method 3: Google Apps Script (Free Automation)

If your data lives in Google Sheets, Apps Script provides free automation. Nothing to install locally.

function importCSVToTrello() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const data = sheet.getDataRange().getValues();
  const apiKey = 'YOUR_API_KEY';
  const token = 'YOUR_TOKEN';
  const listId = 'YOUR_LIST_ID';

  // Skip header row
  for (let i = 1; i < data.length; i++) {
    const [name, description, dueDate] = data[i];

    const url = `https://api.trello.com/1/cards?` +
      `key=${apiKey}&token=${token}&idList=${listId}` +
      `&name=${encodeURIComponent(name)}` +
      `&desc=${encodeURIComponent(description)}`;

    UrlFetchApp.fetch(url, { method: 'POST' });
    Utilities.sleep(100); // Rate limiting
  }
}

To use this:

1. Open your Google Sheet
2. Go to Extensions > Apps Script
3. Paste the code above
4. Replace credentials and list ID
5. Run the function

Best for: Non-developers who can follow instructions and already use Google Sheets. Free with no usage limits.

Method 4: Zapier Free Tier

Zapier connects apps without code. Free tier:

Create a Zap that triggers on new Google Sheets rows and creates Trello cards. Limited to 100 card creations per month, but no code required.

Best for: Non-technical users with fewer than 100 imports per month.

Method 5: Make.com (Integromat) Free Tier

Make.com offers more generous free limits than Zapier:

Each module execution costs 1 credit. Importing 100 cards uses roughly 200-300 credits depending on complexity, so you can import 300-500 cards monthly for free.

Make.com has 50+ Trello modules: card creation, label assignment, member assignment, and more.

Best for: Users needing 100-500 imports per month without paying.

CSV Format Tips

Formatting your CSV correctly prevents errors. Most of these issues are frustrating to debug, so get it right the first time.

Recommended Column Headers

Based on Blue Cat Import (the most popular Power-Up):

name,desc,list,labels,due,members,checklist,checklist item
"Card Title","Description text","List Name","Label1, Label2","2026-03-01","username","My Checklist","Item 1"

Date Formatting

Use ISO 8601 format: YYYY-MM-DD (e.g., 2026-03-01). The MM/DD/YYYY format works in most tools too.

Labels

Use color names (red, orange, yellow, green, blue, purple) or label names you've already created in Trello. Multiple labels use comma separation: "Urgent, High Priority"

Members

Use Trello usernames without the @ symbol. Members must already be added to the board.

Multi-Value Fields

Separate multiple values with commas inside quotes:

"Label1, Label2, Label3"

Choosing the Right Method

One-time migration under 10 imports: Use Blue Cat Import (10 free imports). Consolidate data into larger CSV files to stay under the limit.

One-time migration over 10 imports: Technical users should use the Trello API script. Non-technical users: pay for Blue Cat ($19/month), cancel after one month.

Monthly imports under 100: Zapier free tier. No code required.

Monthly imports 100-500: Make.com free tier.

Regular ongoing imports: Smart Import at $24/year ($2/month effective cost) is the best value.

Developers building import features: Trello API directly, or consider ImportCSV for a pre-built component with validation.

What About Butler Automation?

Butler is Trello's native automation tool. It can't import CSV data, but it can automate what happens after import.

Butler can automatically assign labels based on card content, move cards between lists based on due dates, and add checklists to newly created cards.

Free plan users get 250 automation runs per month. If you import via API or Power-Up, Butler can handle the post-processing.

Common Issues and Fixes

Cards going to wrong list: Your list column must match exact list names in Trello, including capitalization. This trips people up constantly.

Members not assigned: Members must already be board members. Use usernames exactly as they appear in Trello.

Labels not created: Some tools only apply existing labels. Create your labels in Trello first, then import.

Rate limit errors (API method): Add longer delays between requests. Try 200ms if 100ms causes issues.

Large file timeout: Split CSV into batches of 500 rows or fewer.

Summary

Trello has no native CSV import, but free plan users have real options:

• Blue Cat Import - 10 free imports, then $19/month
• Native copy-paste - Free but only imports card titles
• Trello API - Free and unlimited, requires JavaScript
• Google Apps Script - Free automation from Google Sheets
• Zapier - 100 free imports/month, no code
• Make.com - 300-500 free imports/month

For developers building applications that need CSV import functionality, ImportCSV provides a drop-in React component that handles validation, column mapping, and error handling. Send the validated data to Trello's API or any other backend.

The real free plan limitation is CSV export, not import. With unlimited Power-Ups and full API access, Trello's free tier supports CSV import just as well as paid plans.