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?
Thank you for your feedback!
Now other members can find, vote, and discuss your idea.
Our Community Team reads every suggestion (yes, every one) then compiles and shares the feedback with our Product Team. Happy posting!
More about Product Feedback
2
Folllowing List for Post: Import from Excel - custom fields
[this list is visible for admins and agents only]
We just did this! Here's how we did it:
Thanks so much for these details (also amazing bonus fact :) )
I will give it a go!
Does this work for updating the values of existing fields or just to create new fields that never existed?
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!
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 Узнайте о самых популярных функциях Wrike и советах по его использованию
Elaine Wrike Team member Узнайте о самых популярных функциях Wrike и советах по его использованию
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. 🙂
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
Hello! I have done this but now have two custom fields with similar names. That way I don't have duplicative fields, how do I merge the fields?
Hi Roxanne Seltzer, as much as I would like to help, there is no way to merge Custom fields in Wrike. The best way to consolidate fields would be to copy-paste all the values into one field from the Table view as you would do in an Excel spreadsheet. It is possible to select several values at once to perform mass changes. Here is an article with more details on editing data in the Table view. Then you can delete the unnecessary field from Account Management.
If merging fields is something that could be useful for your team, I invite you to upvote this Community post and add your feedback there. Our Product team regularly reviews popular requests and takes them into consideration when developing future releases.
Let me know should you have any additional questions 😌
Lisa K. Community Team at Wrike Wrike Product Manager Узнайте о самых популярных функциях Wrike и советах по его использованию
Lisa K. Wrike Team member Узнайте о самых популярных функциях Wrike и советах по его использованию