Downloading Standard Reports into Excel

[Mike]

Is there a way, once I create a report from MS Project's Standard Report
function, to download the information into an Excel spreadsheet?

Thanks!

Mike C.

 

[JulieS]

Hi Mike,

No, not directly. Unlike Access you cannot directly save a report
output to Excel.

However, you can export most all of the data from Project into Excel
through a File > Save As > command. Select Excel as the file type which
will launch the Export Wizard, then you can select which fields you wish
to export or base the export on an existing table.

--
I hope this helps. Let us know how you get along.

Julie

Visit http://project.mvps.org/ for FAQs and more information about
Microsoft Project.

 

[John]

Is there a way, once I create a report from MS Project's Standard Report
function, to download the information into an Excel spreadsheet?

Thanks!

Mike C.

Mike,
Just to add one thing to Julie's answer. Some of the built-in reports
are for static data and some are for timescaled data. Julie's suggestion
to use an export map will work fine for reports that contain only static
data. For timescaled data type reports (similar to Task or Resource
Usage views), you will need to either use the utility/add-in "Analyze
timescaled data in Excel" found on the Analysis toolbar, or write your
own VBA code to gather, export and format the data as needed.

John
Project MVP

 

[JulieS]

Mike,
Just to add one thing to Julie's answer. Some of the built-in reports
are for static data and some are for timescaled data. Julie's
suggestion
to use an export map will work fine for reports that contain only
static
data. For timescaled data type reports (similar to Task or Resource
Usage views), you will need to either use the utility/add-in "Analyze
timescaled data in Excel" found on the Analysis toolbar, or write your
own VBA code to gather, export and format the data as needed.

John
Project MVP

Hi John,

Thanks for adding that additional information for Mike. Sometimes my
itchy finger hits the send button before covering all possibilities!

Julie

 

[Mike]

Thanks Julie & John for the recommendations. I had always downloaded the
static data, but me being me, wanted to find an easier way!

Best regards,

Mike

 

[JulieS]

You're welcome Mike. I think you are not alone -- many would like
easier ways to do many, many things

 

[John]

Thanks Julie & John for the recommendations. I had always downloaded the
static data, but me being me, wanted to find an easier way!

Best regards,

Mike

Mike,
You're welcome. "Easy" is a relative term. I personally use VBA anytime
I want to export any kind of Project data to another application. It is
"easy" because once the code is set up, a click on a toolbar button is
all it takes to export the data and format it as needed. I my view
that's easy, but then not everybody is comfortable using VBA.

John