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.