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,010 points
919 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,420 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
6,198 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
1,652 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,420 points
592 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,420 points
529 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
918 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,420 points
379 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,420 points
372 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,420 points
1,158 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,420 points
3,065 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,420 points
706 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