olzbits.blogg.se

If you have been supplied with an Excel file that was exported from MS Project, then you simply need to import the file.įigure 1: Click on File to Access the Import Wizardįigure 2: Accessing the Excel File Import Wizard in Microsoft Project

First Example – Importing an Excel file as a New Project that was exported from MS Project The important point is to ask all they can say is no, then you move on.įor the examples below, I have simply used an existing MS Project template. One more tip – If you do find yourself having to import an excel file into Microsoft Project, always first ask the sender whether they exported it directly from Microsoft Project, and if not, can they? Better yet, can they send you the MS project file? Generally, this wouldn’t be an issue within your organisation but it will most likely relate to getting schedules from external contractors.

Important Note – When you import your project file from Excel, remember the ‘Task Name’ column is simply called ‘Name’ – So don’t scroll down to T when looking for the Task column and panic when it is not there – It is there, it is simply called ‘Name’! If it was one of those suppliers that still insist on good-old Excel (yes we all have them), then you may need to do a little bit more work. But we live in the real world where we have various choices (not a bad thing) but at the same time, as a project manager, this can become frustrating when you are trying to integrate different subprojects into Microsoft Project and the file comes in the form of Excel.įirstly, if the file was exported from Microsoft Project into an Excel file, it will be simple to integrate with your project. It would be awesome if everyone worked with the same project software.