Mapping fields when importing csv file

:light_bulb:

I am importing a set of tasks into a project. Some of the fields in my csv file should map to the Section, Task, and Subtask. I’ve been unsuccessful doing that so far.

Any guidance?

Hi @Daniel_Cohen-Vogel welcome to the Asana community forums :slightly_smiling_face: have a look at the following article https://help.asana.com/s/article/preparing-data-for-csv-import?language=en_US it goes into detail on “Preparing data for CSV import

For your sections just make sure there’s a section column as for your tasks and subtasks see the following article https://help.asana.com/s/article/advanced-csv-import-options?language=en_US#gl-dependencies that should go over how you should prepare the csv for subtasks. You’ll want to make a column called Dependents :innocent:

Let me know if this has helped and if you need any further assistance just reply back

Yeah, that’s what I was using as a guide. I have a Section column in the csv import file, and I’ve ordered the columns as noted in this article. The project I’m importing to has sections named identically to the values shown in my import file Section column. Still, all data are dumped into the section labeled No Value.

Hi @Daniel_Cohen-Vogel , when you import a CSV, it’s always a good idea to select ‘Make changes’ instead of letting it import directly. This gives you more control over how columns in your CSV are mapped into Asana.

Once you select ‘Make changes’, you can click on the header for Sections and make sure it maps to Asana’s ‘Sections’.

The import should create new Sections for you; it will ignore any existing sections in the project - it will not map tasks into those - that is expected.

Also make sure your Group button is set to ‘Sections’ so you can see the result.

1 Like