Importing projects from Excel into Wrike

 It seems it is currently impossible to import projects and project attributes (start date, end date, owner, description etc) on the project level from Excel into Wrike. Currently it is only possible to import folders and tasks from Excel into Wrike.

I have a list of 50+ projects and it would be very time consuming to import them as folders and then manually convert each of them from a folder into a project and then manually add project attributes to each project.

Can you please prioritize this issue?

Thanks,

Leonila

8
14 Kommentare
Spot On Innovative Approach Stellar Advice
Avatar
Stephen

Hi Leonila, thanks for your post and welcome to the Community 🙂
 
You're correct, currently, only Folder/tasks can be directly created in Wrike from a Wrike formatted, Excel template.
 
You may already be aware you can create the Project in Wrike first and then import the Excel information to that Project. Once a Project is created, you can choose to import by selecting the Project's options (3 dots on the top righthand side) and choose 'Import'. Once you've formatted the Excel document, all the information will be imported to that Project you created including the attributes you've mentioned above.
 
I understand that creating 50+ Project files is time consuming so I can see why being able to create Projects from an Excel template would be useful here so thank you for sharing this feedback so others can vote and discuss this option 👍
1
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Good afternoon! I don't see an option to import (from within the new project -- the 3 dots on the top, righthand side of the project do not show "Import" as an option. Is this not a feature in the free version? Please let me know. Thank you!

0
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar
Stephen

Hi Kat, you're correct, importing Excel files is a feature of paid accounts only. If it's something you're interested in and if you'd like a call back to discuss your options, let me know here and I can arrange this for you.

As an aside, on all articles on our Help Centre, you'll see underneath the article's title for which user types and account types the feature is available 👍

0
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice

Hi, 

Is there a way to upload Excel schedules to Wrike as a project rather than a folder? We have a lot of courses that we will need to convert and it will be much more convenient if we can upload as projects. Is that possible? 

0
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar
Stephen

Hi Jennifer, I understand if you have a lot of Projects to import this may be time-consuming. Right now, you can import Excel to any format except Projects so you will need to convert.

You're not alone with this request however, Elke has raised this with us so it would be great for our Product Team's visibility if you could add your vote to his post 👍

1
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar
Stephen

Hi everyone - good news!

It's now possible to import Projects via excel. Here's an example of what the template should look like.

Note: You need to assign a Status to the Project for it to appear in your Folder Tree.

Any questions, let me know 🙂

0
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Hi is it possible to include images and/or custom fields in the excel?

 

Also is it possible to perform the import via API?

 

 

1
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Hi when I upload using the template above, and assign a project status "Green" into that column for projects, I receive an error upon upload that the Task state value green is not recognized

 

0
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Still trying to figure this out myself.

All our records on previous systems are at the project level. 10,000+ records of data that needs to be imported.

Every time i try and use the sample file it just creates folders.  don't need to be able to import tasks as they will all happen in the future or ad-hoc as we go. I need to structure as below:

•     Client Folders populated with client contact data custom fields 
          - Project populated with description, budget, supplier info etc custom fields

eg:

- Client Name (folder)

     - project 1
     - project 2
     - project 3

 

I hope that makes sense, importing is quite difficult in it's current method

1
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Hello - trying to import my existing projects into the Wrike system as PROJECTS. I've tried doing the template and have entered info into the "Status" column, however it's just coming up with an error for me and not taking this info on board for migration. Are there specific options that need to be entered into the STATUS column in order to work? What data should i be putting here? I've tried adding "Active" in but this isn't working.

0
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Hi, please your help! When I try to create projects instead of folders but I can't... what am I doing wrong? Some of you could share some example...

 

 

 

 

1
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar
Hugh

Hey Luis Aguilera, I'd recommend checking out this article about importing data in Excel. If you have any other questions let me know 😊
 
0
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Hi guys, Like the folks above I still can get to import excel information as Projects. No matter what I do It always comes up as folders.

The easiest way to troubleshoot this is to export a project from Wrike to Excel. For example, a project that looks like this:

Will come up like this:

You can see the correct workflow under project and status.

But when importing the same data, it imports like this:
A folder with no status

 

UPDATE:  For other that find their way here.  It turns out that if you press the refresh button, wrike will refresh the folder to projects. 

1
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar
Hugh

Hi Alvaro Yurrita, thank you for sharing this workaround!

0
Aktionen für Kommentare Permalink

Folllowing List for Post: Importing projects from Excel into Wrike
[this list is visible for admins and agents only]

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