Exporting schedules to Excel

Any referenced datasets can be downloaded from "Module downloads" in the module overview.

00:01

Unfortunately, not everybody is a Revit genius like you.

00:04

Also, there are some estimating applications that really only work for Excel spreadsheets.

00:10

As much as I don't like doing this, it's a necessary evil.

00:13

So, let's export some schedules into Excel.

00:16

It's pretty simple really.

00:19

So, what I want to do is let's open our Revit model.

00:24

In the project browser, let's open up our Rebar length schedule.

00:31

Go to the File tab.

00:35

Let's go to Export.

00:38

It's hidden. Let's scroll down here. Hover over that little bar.

00:42

Let's go to Reports.

00:45

Let's go to schedule.

00:47

I'm going to put it somewhere that makes sense to me, maybe put it in my schedule Rebar folder.

00:53

I'll click "Save".

00:58

Let's just accept the defaults and click "OK".

01:02

Now let's open up Microsoft Excel.

01:07

Let's come down here to open other workbooks.

01:14

Let's go to browse.

01:16

Who knows where it's going to take us.

01:18

I'm going to browse to my bridge course.

01:22

Now, notice that we can't see it here.

01:23

I know we put it here.

01:25

So, for my file name, instead of all Excel files, I just select "All files".

01:30

Hey, there it is.

01:32

Rebar length schedule.

01:37

Let's click "Open".

01:42

Let's just accept the defaults in this wizard here.

01:45

Click "Next".

01:48

Let's click "Next".

01:51

I guess this is fine. Let's click "Finish".

01:55

There we go.

01:56

Now the thing is all these cells are dumb, right?

01:59

So, if I click into here, in Revit, that's keeping a calculation.

02:02

This is just a straight up number.

02:04

So, when we do this, remember, this is only a snapshot in time.

02:08

If people need these Excel spreadsheets,

02:10

well, maybe their application has a Revit add on, like our bridge add on, or maybe you just need to keep exploiting schedules for them.

Video transcript

00:01

Unfortunately, not everybody is a Revit genius like you.

00:04

Also, there are some estimating applications that really only work for Excel spreadsheets.

00:10

As much as I don't like doing this, it's a necessary evil.

00:13

So, let's export some schedules into Excel.

00:16

It's pretty simple really.

00:19

So, what I want to do is let's open our Revit model.

00:24

In the project browser, let's open up our Rebar length schedule.

00:31

Go to the File tab.

00:35

Let's go to Export.

00:38

It's hidden. Let's scroll down here. Hover over that little bar.

00:42

Let's go to Reports.

00:45

Let's go to schedule.

00:47

I'm going to put it somewhere that makes sense to me, maybe put it in my schedule Rebar folder.

00:53

I'll click "Save".

00:58

Let's just accept the defaults and click "OK".

01:02

Now let's open up Microsoft Excel.

01:07

Let's come down here to open other workbooks.

01:14

Let's go to browse.

01:16

Who knows where it's going to take us.

01:18

I'm going to browse to my bridge course.

01:22

Now, notice that we can't see it here.

01:23

I know we put it here.

01:25

So, for my file name, instead of all Excel files, I just select "All files".

01:30

Hey, there it is.

01:32

Rebar length schedule.

01:37

Let's click "Open".

01:42

Let's just accept the defaults in this wizard here.

01:45

Click "Next".

01:48

Let's click "Next".

01:51

I guess this is fine. Let's click "Finish".

01:55

There we go.

01:56

Now the thing is all these cells are dumb, right?

01:59

So, if I click into here, in Revit, that's keeping a calculation.

02:02

This is just a straight up number.

02:04

So, when we do this, remember, this is only a snapshot in time.

02:08

If people need these Excel spreadsheets,

02:10

well, maybe their application has a Revit add on, like our bridge add on, or maybe you just need to keep exploiting schedules for them.

Exporting a Schedule to Excel

Unfortunately, not everybody is a Revit genius like you. Also, there are some estimating applications that really only work from Excel spreadsheets. As much as I don’t like doing this, it’s a necessary evil, so I should show you how it’s done. It’s pretty simple actually.

  • Open the model you have been working in.
  • In the Project Browser, find REBAR LENGTH SCHEDULE and open it.

  • Go to the blue File tab
  • Go to Export
  • Go to Reports
  • Go to Schedules

  •     Browse to a place to put the .txt file.
  •     Keep the defaults in the next dialog and click OK

  Open Microsoft Excel

  •  Click Open Other Workbooks
  • Click Browse
  • Make sure All files is selected.

 

  • Click Next through the wizard
  • Click Finish

Was this information helpful?