Allocatus - Technische Vorhaben schneller umsetzen

Import Excel file into Microsoft Project for the Web

Written by Renke Holert | Jan 8, 2024 10:18:56 AM

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 

Save project plan in Microsoft Excel. 

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

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

Select and open the Excel project file. 

Click next in the Microsoft Project import wizard. 

Click to continue 

Click to continue 

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

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

You will then see the Excel file in MS Project. 

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 

Select Import from Project desktop. 

Select the previously saved project file. 

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