How to Import Excel Worksheet into Microsoft Project

0 votes

I want to import the following Microsoft Excel worksheet into Microsoft Project (2010):

Worksheet

Basically, the worksheet comprises columns A for tasks and subtasks, B for start dates, and C for finish dates. The start and end dates are used to determine the conditional highlighting you see. The spreadsheet is saved as a standard Excel workbook because there are no macros—only formulas.

I tried using Project to open the workbook. Although it successfully locates the name of the source worksheet, it is unable to identify any fields to map to. See the illustration below:

Import Failure

What can I do to resolve this? I've never used Project before, but I would like to be able to import the "Key Milestones" and "Subtasks", along with their respective "Start" and "Finish" dates. Any help is much appreciated.

Oct 14, 2022 in Others by Kithuzzz
• 38,000 points
1,346 views

1 answer to this question.

0 votes

Solution:

Wizard's preliminary settings:

  • New map
  • As a new project
  • Tasks, Resources, Assignments: all selected
  • Import includes headers

Sheet names: "Sheet1"... as by default: OK.

While "Sheet1" renamed to:

"#2 MacroPlan": Not OK
"2 MacroPlan": Not OK
"MacroPlan": OK
"#2_MacroPlan": Not OK
"2_MacroPlan": OK

Hence: Use "_" instead of space, don't use "#" and probably other odd symbols (didn't test more).

answered Oct 14, 2022 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
1 answer

How to import data from a HTML table on a website to excel?

Hello  To import any HTML file in excel there ...READ MORE

answered Feb 10, 2022 in Others by gaurav
• 23,260 points
7,958 views
0 votes
1 answer

How to import excel file in Oracle SQL live

Hello, there are a few steps You'll ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 23,260 points
2,157 views
0 votes
1 answer

Excel, How to split cells by comma delimiter into new cells

The Excel manual method: choose Text to Column ...READ MORE

answered Oct 3, 2022 in Others by narikkadan
• 63,600 points
917 views
0 votes
1 answer

Excel: How to merge two columns into one (from different sheets or separated columns)

This equation is completely adjustable. Your two ...READ MORE

answered Oct 7, 2022 in Others by narikkadan
• 63,600 points
879 views
0 votes
1 answer

Add .xll as AddIn to Excel

Hi, for adding an xll as Addln ...READ MORE

answered Feb 17, 2022 in Others by gaurav
• 23,260 points
1,213 views
0 votes
1 answer

JavaScript API does not work for Excel 2013?

Each method in the Office.js APIs is ...READ MORE

answered Sep 26, 2022 in Others by narikkadan
• 63,600 points
787 views
0 votes
1 answer

How to Paste JPEG as a gif in excel?

Solution  Step 1 Navigate to the folder that contains ...READ MORE

answered Oct 2, 2022 in Others by narikkadan
• 63,600 points
748 views
0 votes
1 answer

How to merge two cells in excel with same field name

Insert 2 new columns, G & H. Enter ...READ MORE

answered Oct 7, 2022 in Others by narikkadan
• 63,600 points
1,625 views
0 votes
1 answer

How to get the JasperReports into Excel format with proper alignment

Remove at least one parameter: exporter.setParameter(JRXlsExporterParameter.IS_COLLAPSE_ROW_SPAN,Boolean.TRUE) Note that JRXlsExportParameter is deprecated the correct ...READ MORE

answered Sep 21, 2022 in Others by narikkadan
• 63,600 points
3,880 views
0 votes
1 answer

How to compress Excel buffer into ZIP buffer?

The problem is that something you're using ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,600 points
1,181 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP