Export Revit Schedules to Excel and Google sheets
General Revit Tips

Export Revit Schedules to Excel

Schedules are really powerful tools in Revit. They can help you check and validate model data, or quantify materials and elements in a project. They can also do really simple things like create a Drawing List.

Sometimes though, we need to take the information out of your Revit schedule and export it to something more universally used. Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualization and analysis tool. (Note: There is a similar process for Google Sheets!!)

In this quick tip I’ll show you how to easily export your Revit Schedules to excel.

Export Revit schedules to Excel

  1. First thing you want to do is open the schedule you want to export.Export Revit schedules to excel-1
  2. Hit File>Export>Reports>Schedule: Export Revit schedules to excel-2
  3. Save your Schedule as an .txt file (Delimited text file type), and check the options as required: Export Revit schedules to excel-3

Open Excel

  1. In Excel, go to open a file and navigate to your Schedule .txt file. On the file type selection, make sure All Files or Text Files are selected: Export Revit schedules to excel-4
  2. This will Import your Schedule .txt file and will note that the data is delimited. There will be 3 step dialog box to go through or you can just hit Finish: Export Revit schedules to excel-5
  3. BOOM all done! Your Revit Schedule has now been exported for use in Excel! Export Revit schedules to excel-6

BONUS TIP – Export to Google Sheets

  1. To export your Revit Schedule to Google Sheets, follow the same steps in Revit as above.
  2. Create a new blank Spreadsheet in Google sheets, then select File>Import – and upload your Schedule .txt file
  3. Once uploaded, select and hit Import Data: Export Revit schedules to excel-7
  4. BOOM thats it! Your Revit Schedule has now been exported for use in Google Sheets! Export Revit schedules to excel-8

The Scheduling tool in Revit is an awesome feature, but there are times when we need to Export that data for use in other spreadsheets such as Excel and Google Sheets. I hope this quick tip has helped you to achieve this, as it’s easy once you know how!

Any other tips or comments to add? Please leave a comment below!

-Talk soon
P.S – I’d love to connect with you on Twitter: here

Stay up to date with the latest posts, Subscribe!


Article written by:

Structural Revit Technician and BIM/Drafting Manager from New Zealand. Founder of revitIQ.com