Import Excel file into Planner Premium

For project managers who have been managing their projects with Microsoft Excel, Microsoft now offers a very simple project management solution called Microsoft Planner Premium. If you want to import the tasks from Microsoft Excel into Microsoft Planner Premium, 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 the Microsoft Project desktop app into Planner Premium

Go to Power Apps and open the Planner app.

Select Import from mpp.

Select the previously saved project file and click Import. 

You will then see all the data from Microsoft Excel in Planner Premium.

You can find more on the feature set and licensing in our article on the Microsoft Planner Premium plans. If you need a cross-plan overview, sync your Planner Basic and Planner Premium plans with Altus and add missing features such as baselines, resource management and portfolio management.