topic Re: Interactive schedule export to XL in Project data & BIM

Interactive schedule export to XL

rjwilden — Thu, 18 May 2023 22:22:01 GMT

Can you export a interactive schedule to Excel. I cant seem to find any method or instruction for this.

Richard

Re: Interactive schedule export to XL

Anonymous — Wed, 30 Aug 2006 17:47:33 GMT

click in the schedule to make it active, then File-Save as. It will save as a comma delimited file that Excel can import into a new document.

Re: Interactive schedule export to XL

rjwilden — Wed, 30 Aug 2006 19:07:26 GMT

Yes that works, thanks for that.

Richard

Re: Interactive schedule export to XL

JaredBanks — Wed, 20 Sep 2006 22:44:28 GMT

Exporting to EXCEL this way works great, but I was a little unsure what a "comma delimited file" was. So for the benefit of the next person pulling their hair out trying to figure this out with zero time to wait...

To export a schedule to EXCEL:
(in v9, I assume v10 is similiar though I'm just getting into v10)

go to calculate/interactive sechedule/preview

get your schedule set up correctly

choice output to: text file

then click the create list button

Now open the .txt file in EXCEL and follow the prompts (you'll want to choose delimited, then tab as the delimiter).

BAM!! so so easy, if you know that you can do it!