What can we help you with?

e.g. Gantt chart, Creating tasks, Sharing folders

Import from Excel - custom fields

3 comments

  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Justin Hwang

    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.
    Is this helpful? 1
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Anne Huckvale

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

    I will give it a go!

    Is this helpful? 1
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Ryan Okelberry

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

    ย 

    Is this helpful? 0

Please sign in to leave a comment.

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

Community

Welcome ๐Ÿ––

Hi there! ๐Ÿ™‚ Want to become a black belt Wrike Ninja? Here's how to earn a Wrike badge

Welcome ๐Ÿ–– Have you checked out this week's Release Notes yet?

Hey! ๐Ÿ‘‹ Curious about something? Visit How To to search and ask the Community for answers.

Welcome! ๐Ÿ‘‹ Figured out a good tip or trick? Share it in Best Practices.

Want to connect your existing software to Wrike? Learn and ask how in the API section.