Asana projects can be exported as CSV. With a small amount of column mapping, you can bring your tasks, due dates, and hierarchy into LoopGantt in minutes.
Step 1 — Export from Asana
- Open your Asana project.
- Click the ⋮ (More) button at the top right of the project view.
- Select Export/Print → CSV.
- Save the downloaded CSV file.
Step 2 — Map Asana columns to LoopGantt
Asana's CSV uses different column names than LoopGantt. Open the CSV in Excel or Google Sheets and rename columns as follows:
| Asana column | LoopGantt column | Notes |
|---|---|---|
| Name | Name | No change needed |
| Section/Column | — | Use as Phase name if you have sections |
| Due Date | — | Convert to Duration (Days) from a start date |
| Assignee | — | LoopGantt doesn't use assignees yet |
| Priority | Priority | Map: High→high, Medium→medium, Low→low |
| Tags | — | Optional: use as Description or Color hint |
| Completed | Status | TRUE→completed, FALSE→not_started |
| Notes | Description | No change needed |
Step 3 — Calculate durations
Asana stores due dates, not durations. LoopGantt schedules forward from a project start date using working-day durations.
To convert: in your spreadsheet, add a Duration (Days)column and calculate the working days between the task's start and due date. You can use Excel's =NETWORKDAYS(start, end) - 1 formula for this.
If tasks don't have start dates in Asana, use a reasonable estimate or set all durations to 1 and adjust after import.
Step 4 — Add phases (optional)
If your Asana project uses sections, create phase rows in your CSV. A phase row has:
Phase=YesDuration (Days)=0Milestone=No
Place the phase row above the tasks that belong to it. LoopGantt doesn't have a parent ID column in CSV — it infers parent/child relationships from the order and the WBS column if present.
Step 5 — Import into LoopGantt
- Save your updated file as CSV.
- In LoopGantt, click Import → Import from CSV.
- Select your file and review the preview.
- Click Import.
Alternative: Use AI to convert
If the column mapping feels tedious, paste your Asana CSV into ChatGPT or Claude with this instruction:
Convert this Asana CSV export into the LoopGantt JSON format. Rules: - Calculate Duration (Days) from start date YYYY-MM-DD - Map sections to phases (isPhase: true, durationDays: 0) - Map Asana priorities: High→high, Medium→medium, Low→low - Completed tasks: status = "completed", progress = 100 [PASTE YOUR CSV HERE] Return only valid JSON matching the LoopGantt format.
Then import the resulting JSON file using Import → Import from JSON. See Use Your Own LLM for the full JSON schema reference.