Let's Get Started: The Official Method
Most versions of Excel come with a special template so you can move data into Project. To find it, open Excel, choose New in the Backstage area, and from your template choices choose Sample Templates. Select the one called Microsoft Project Task List Import Template.
The template will open to a worksheet with a tab that says Info_Table. Do not edit this tab, as it contains template information that Project will access. Instead, click on the Task_Table tab. You can copy and paste your data from the Excel worksheet that you want to import onto this worksheet. Be certain you have column headings on your worksheet.
For my project, I didn’t have a calendar at hand. I simply entered tasks, typed in names of staff who would need to carry them out, and estimated the dates. Save it.
Your next step is to open Project, go to its Backstage, and choose Open. When the Open dialogue box appears, look over to bottom right, beyond the File Name space; you’ll see Microsoft Project Files. Click the drop-down arrow and enter Excel Workbook. If you’re using an earlier version of Excel, choose Excel 97-2003 Workbook.
Find the Excel file you just created and named. Choose it and then click Open. The Import Wizard opens automatically. Click Next.