How to bulk assign multiple options to a multi-select custom field from Excel?

English Forum Ask the Community
1

Hi everyone,
I’ve run into a roadblock I hope someone can help with:

I need to create a multi-select custom field (multi_enum) with 300+ options, and then assign multiple of those options to tasks automatically, based on data from an Excel or CSV file.

I’ve already tried importing via CSV, but Asana turns the field into plain text instead of assigning the predefined options and it doesn’t support importing values into multi-select fields from CSV anyway.

My goal:

  • Create a multi-select field

  • Assign multiple options to tasks based on Excel/CSV input

  • Avoid using the API if possible, or at least avoid coding if there’s a tool or workaround

Is there any way at all (even through 3rd-party tools or Asana hacks) to bulk-assign multiple values to a multi-select field per task — either during import or after import?

Thanks in advance for any insight or experience you can share!

2

Welcome, @Carlota_Ruiz,

If you have a column in your csv with comma-separated values, you can do this.

When you import in Asana, after you specify the file, choose the Make changes button, not the Go to project button.

There, click the down arrow in the corresponding column and select Multi-select:

image
image2868×1272 236 KB

You can read a bit more in help.asana.com.

Thanks,

Larry

3

Did you know that when importing there is a “make changes” option, and you can map your column to the custom field you have? It definitely works with single select fields, not sure it does with multi select…