Asana CSV Import: Map Columns & Choose Workflow
To import a CSV into Asana correctly, you map each column in your spreadsheet to a corresponding field in Asana (such as Task Name, Assignee, Due Date), and you choose the workflow—either a new project or an existing one—based on where you want the tasks to live. The import tool walks you through column mapping step by step, and the right workflow depends on whether you’re starting fresh or adding to ongoing work.
What the CSV Import Tool Does
Asana’s CSV importer lets you bring tasks from a spreadsheet into a project. It reads the first row of your CSV as headers and each subsequent row as a task. You can import into a brand-new project or an existing project, and you can map columns to standard fields like Task Name, Notes, Due Date, Assignee, and Tags. The tool also supports custom fields if your project has them defined.
The import is a one-time operation—it does not sync. If you update the CSV later, those changes won’t flow into Asana. You also cannot import subtasks, dependencies, or attachments via CSV; those must be added manually or through other integrations.
How to Map Columns Correctly
Column mapping is the core of the import. Here’s the process:
- Export your data as a CSV file with clear headers in the first row (e.g., “Task Name”, “Due Date”, “Assignee”).
- In Asana, click your profile photo, select Settings, then Apps, and find CSV Importer. Alternatively, create a new project and choose “Import” from the project menu.
- Upload your CSV file.
- Review the auto-detected column mapping. Asana tries to match headers to fields, but you can manually change each dropdown.
- For each column, choose the Asana field it should populate. If a column doesn’t map to anything, select “Don’t import this column.”
- Confirm the import. Asana will create tasks and notify you when done.
Common mappings include:
- Task Name – required; this becomes the task title.
- Notes – the task description.
- Due Date – must be in a format Asana recognizes (e.g., YYYY-MM-DD or MM/DD/YYYY).
- Assignee – must match the exact name or email of a user in your Asana workspace.
- Tags – comma-separated tag names; Asana will create them if they don’t exist.
- Custom Fields – only appear if the target project already has those fields defined.
Choosing the Right Workflow: New vs. Existing Project
The workflow you choose depends on your goal:
- New project – Use this when you’re migrating a standalone list or starting a fresh initiative. You’ll name the project, and Asana will create it with all imported tasks. This is ideal for moving from Excel or Google Sheets into Asana for the first time.
- Existing project – Use this when you want to add tasks to a project that already has structure, custom fields, or team members. The import will append tasks to the project, and you can map to that project’s custom fields.
If you’re unsure, consider whether the tasks are part of ongoing work. For example, importing a backlog of bugs into an existing product development project makes sense. Importing a one-time event planning list might warrant a new project.
Common Problems and How to Avoid Them
Several issues frequently trip up users:
- Date format errors – Asana expects dates in a specific format. If your CSV uses a regional format like DD/MM/YYYY, the import may misinterpret it. Convert to YYYY-MM-DD before importing.
- Assignee mismatches – If the assignee name doesn’t exactly match an Asana user, the task will be unassigned. Use email addresses to be safe.
- Duplicate tasks – The importer does not check for duplicates. If you run the import twice, you’ll get two sets of tasks.
- Missing custom fields – If you map to a custom field that doesn’t exist in the target project, the import will fail. Create the custom fields first.
- Encoding issues – CSV files with special characters (like accents) may import incorrectly if saved with the wrong encoding. Save as UTF-8.
How the Import Handles Data
Asana processes the CSV row by row. Each row becomes a task. The importer will show a preview of the first few rows so you can verify mapping before committing. After import, you’ll receive a notification, and tasks appear in the project. If you need to undo, you can delete the tasks manually—there’s no automatic rollback.
For large imports (over a few hundred rows), the process may take several minutes. Asana recommends breaking very large imports into smaller batches to avoid timeouts.
Comparing CSV Import to Other Methods
CSV import is one of several ways to get data into Asana:
- Manual entry – Best for a few tasks; gives full control but is time-consuming.
- CSV import – Best for bulk data from spreadsheets; one-time, no ongoing sync.
- Integrations (e.g., Zapier, Unito) – Best for ongoing sync between tools; requires setup and may have costs.
- Asana API – Best for developers who need to automate imports programmatically; offers full control but requires coding.
Choose CSV import when you need a quick, free, one-time bulk upload. Choose an integration if you need continuous updates.
Frequently Asked Questions
Can I import subtasks via CSV?
No. The CSV importer only creates top-level tasks. You cannot specify parent-child relationships in the CSV. To create subtasks, you’ll need to add them manually after import or use the API.
What if my CSV has a column for section names?
You can map a column to the “Section” field if your target project has sections defined. The importer will place each task into the matching section. If the section doesn’t exist, the task goes to the top of the project.
Can I import into multiple projects at once?
No. The importer works with one target project per import. If you need tasks in multiple projects, split your CSV or run separate imports.
Does the import overwrite existing tasks?
No. The import always adds new tasks. It never updates or deletes existing tasks. To update tasks, you’d need to use the API or a third-party integration.
What file formats are supported?
Asana accepts CSV files. Excel files (.xlsx) are not directly supported—you must save your spreadsheet as a CSV before importing.
Can I import attachments or comments?
No. The CSV importer does not support attachments, comments, or file uploads. Those must be added manually after the import.
Related
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.