8 min read

Import Excel file into Microsoft Project for the Web

Featured Image

For project managers who have been managing their projects with Microsoft Excel, Microsoft now offers a very simple project management solution called Project for the web. If you want to import the tasks from Microsoft Excel into Microsoft Project for the web, there are three steps to follow: 

Create a project plan in Microsoft Excel 

import-project-tasks-from-microsoft-excel-to-microsoft-project-step-1

Save project plan in Microsoft Excel. 

Import project plan from Microsoft Excel file into Microsoft Project desktop app 

import-project-tasks-from-microsoft-excel-to-microsoft-project-step-2

Open the Microsoft Project desktop app and select New from Excel workbook. 

import-project-tasks-from-microsoft-excel-to-microsoft-project-step-3

Select and open the Excel project file. 

import-project-tasks-from-microsoft-excel-to-microsoft-project-step-4

Click next in the Microsoft Project import wizard. 

import-project-tasks-from-microsoft-excel-to-microsoft-project-step-5

Click to continue 

import-project-tasks-from-microsoft-excel-to-microsoft-project-step-6

Click to continue 

import-project-tasks-from-microsoft-excel-to-microsoft-project-step-7

Select the task and deactivate the import of column headers in the example and click next. 

import-project-tasks-from-microsoft-excel-to-microsoft-project-step-8

Assign the columns from Excel to the columns in Project. In the example, click Name, Start and End and continue 

import-project-tasks-from-microsoft-excel-to-microsoft-project-step-9

You will then see the Excel file in MS Project. 

import-project-tasks-from-microsoft-excel-to-microsoft-project-step-10

Save the task list as an MS Project file. 

Import project plan from Microsoft Project Desktop App into Microsoft Project for the Web 

Open Project for the Web 

import-project-tasks-from-microsoft-excel-to-microsoft-project-step-11

Select Import from Project desktop. 

import-project-tasks-from-microsoft-excel-to-microsoft-project-step-12

Select the previously saved project file. 

import-project-tasks-from-microsoft-excel-to-microsoft-project-step-13

You will then see all the data from Microsoft Excel in Project for the web. 

5 min read

Microsoft Planner tip: Create tasks from Microsoft Teams chat

Tasks from Microsoft Teams chatsoftengetlost Youtakepart in manychats and tasksarisefromthem. These areoften

3 min read

MS Project processes in Microsoft Teams

Distributing and updating the project plan is time-consuming As a project manager, you work with Microsoft Project...

3 min read

Microsoft Teams - Problem reaching the app

Error in Microsoft teams Whenusingthe Windows Desktop App from Microsoft Teams, themessageThere was a problem...