Import from Excel - custom fields

Is it possible to populate custom fields when importing from Excel?

If so do I just add the field title to the Excel sheet?

 

1
7 comentários
Spot On Innovative Approach Stellar Advice
Avatar

We just did this!  Here's how we did it:

 

1. Add the columns for Custom Fields at the very end of the .xls template after all obligatory columns. 
  • (new column should be named same as the custom field created in Wrike)
2. Add the value for these columns next to Tasks, Folders, and Projects.
 
3. Import the .xls file and refresh the page after the import.
 
4. Open the imported Folder or Project and switch to the Table View.
 
5. Click Add column and use autosuggest (start typing the title of the Custom Field and pick the one you've added in the xls file). After that, all values for the Custom Fields you've added will be visible for the tasks.
 
Bonus Fact:
When you import a brand new Custom Field (that didn't exist before you imported a file), it's created as a text type fields. However, you can manually change the type of the field.
3
Ações de comentário Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Thanks so much for these details (also amazing bonus fact :) )

I will give it a go!

1
Ações de comentário Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Does this work for updating the values of existing fields or just to create new fields that never existed?

 

0
Ações de comentário Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Strangely some of the custom fields has value after importing while some custom fields are blank....I cannot figure out why it's behaving these way.....I shifted all the custom fields at the end of the excel per post but it's not working....

After populating the fields manually in Wrike itself, I tried downloading and importing exact the same file and amazingly the fields are again blank.....

We are migrating from other platform to Wrike and seems cannot get rid of the manual touch task by task....appreciate if anyone can help here!

0
Ações de comentário Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Hi Pan Chen, I believe our Support team was able to help you with this?

If you need any further assistance, don't hesitate to ask, and welcome to the Community 🙂

Elaine Community Team at Wrike Wrike Product Manager Aprenda sobre as funcionalidades e melhores práticas em Wrike com o nosso Treinamento Webinar Online

Elaine Wrike Team member Aprenda sobre as funcionalidades e melhores práticas em Wrike com o nosso Treinamento Webinar Online

0
Ações de comentário Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Yes! The support team has helped me out. Basically my import file contains public custom fields which have the same name as the other 8 custom fields created by people outside my team. The import function now identifying by the field name and it got cross updated to other field under the same name. The walk around recommended here is to change the field name to a unique name when uploading like adding "..." for example, and it can be changed back after uploading is done. 🙂

0
Ações de comentário Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Good to hear that you were able to find a solution to this Pan Chen! Please let us know if you have any other questions, we'll be happy to discuss 🙌

Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover

Lisa Wrike Team member Become a Wrike expert with Wrike Discover

0
Ações de comentário Permalink

Folllowing List for Post: Import from Excel - custom fields
[this list is visible for admins and agents only]

Alto
Didn’t find what you were looking for? Write new post