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 in Others by Kithuzzz
• 20,660 points
59 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 by narikkadan
• 37,660 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 in Others by gaurav
• 22,040 points
314 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 in Others by gaurav
• 22,040 points
607 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 in Others by narikkadan
• 37,660 points
70 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 in Others by narikkadan
• 37,660 points
80 views
0 votes
1 answer

Add .xll as AddIn to Excel

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

answered Feb 17 in Others by gaurav
• 22,040 points
134 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 in Others by narikkadan
• 37,660 points
55 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 in Others by narikkadan
• 37,660 points
55 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 in Others by narikkadan
• 37,660 points
61 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 in Others by narikkadan
• 37,660 points
242 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 in Others by narikkadan
• 37,660 points
90 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