Export Import Excel Revit: How to Move Data Both Ways

How-to basics · Updated November 22, 2026

Yes, you can export data from Revit to Excel and import Excel data back into Revit, but the process is not a direct one-click link. Revit does not open Excel files natively; instead, you use schedules, the built-in Export and Import options on the ribbon, or add-ins like Dynamo and Ideate Software to move tabular data between the two programs. The most common workflow is exporting a Revit schedule to Excel for editing, then importing the modified Excel file back into Revit to update parameters.

Understanding Revit Schedules and Excel

Revit stores building information in a database, and schedules are live views of that data. When you export a schedule, you are creating a snapshot of the database at that moment. Excel, on the other hand, is a flat spreadsheet with no live link to the model. This means any change you make in Excel will not automatically appear in Revit—you must import the file back. Conversely, changes in Revit after an export will not update the Excel file unless you re-export.

For most users, the flow is:

  • Create a schedule in Revit (e.g., door schedule, room finish schedule).
  • Export it to Excel using the File > Export > Reports > Schedule command.
  • Edit the data in Excel (add rows, change values, etc.).
  • Import the Excel file back into Revit using File > Import > Import > (choose the file type) or a dedicated add-in.

Revit’s native import is limited to certain file types, so many professionals use third-party tools for a smoother round-trip.

How to Export a Revit Schedule to Excel

Revit’s built-in export creates a text-delimited file (like CSV or TXT) that Excel can open. Here are the exact steps for Revit 2024 or 2025 on Windows:

  1. In the Project Browser, right-click the schedule you want to export and select Export.
  2. Choose File > Export > Reports > Schedule (if you are not in the schedule view).
  3. In the Export Schedule dialog, choose a delimiter: Tab or Comma. Tab works best for Excel.
  4. Select Export column headers and Export group headers if you want them.
  5. Click OK, name the file (e.g., DoorSchedule.csv), and save.
  6. Open Excel, then go to Data > From Text/CSV to import the file, or simply double-click it if Excel recognizes the extension.

On a Mac, Revit is not available (Revit is Windows-only), so this applies to Windows only.

How to Import Excel Data into Revit

Revit does not have a native “Import Excel” button for schedules. The closest built-in method is to import a CSV or text file that matches the schedule’s field structure. However, this only works for creating a new schedule, not for updating existing elements. For updating existing elements, you need a third-party add-in or Dynamo.

Here is the native method for creating a schedule from an Excel/CSV file:

  1. In Revit, go to File > Import > Import and select the CSV file (you may need to change the file type filter).
  2. Revit will prompt you to choose how to handle the data—usually it creates a new schedule with the imported fields.
  3. Map the columns to Revit parameters if prompted.

This method is clunky and often fails if the CSV has extra columns or formatting. For real-world projects, most people use an add-in like Ideate Sticky or Diroots, or write a Dynamo script.

Using Dynamo for Excel Import/Export

Dynamo is a visual programming add-in that comes with Revit. It can read and write Excel files using the Excel nodes. This is the most flexible free method. For example, to update door widths from an Excel sheet:

  • Use the Excel.ReadFromFile node to pull data.
  • Feed the data into Element.SetParameterByName nodes to update each door.

Dynamo requires some learning, but it is the only built-in way to do a true round-trip without paid add-ins.

Common Problems and Misconceptions

One common misconception is that exporting a schedule to Excel creates a live link. It does not—the export is static. Another issue is that Revit’s native export only exports the schedule’s visible fields, not all parameters. If you need hidden parameters, you must add them to the schedule first.

Another frequent problem: when importing a CSV, Revit may not recognize the data types correctly (e.g., numbers become text). To avoid this, ensure your Excel columns are formatted as numbers before saving as CSV, and check the import mapping.

Also, Excel formulas do not transfer to Revit. If you calculate a value in Excel (like total area), you must import the calculated result, not the formula.

Comparing Native Methods vs. Add-ins

Native Revit export/import is free but limited. Add-ins offer more control and often support live linking or two-way sync. Here is a comparison:

  • Native Export: Free, built-in, but only exports schedules as text files; import is limited to creating new schedules.
  • Dynamo: Free, powerful, but requires scripting knowledge.
  • Paid Add-ins (e.g., Ideate, Diroots): Cost money (typically $100–$500 per license), but provide one-click export/import with mapping and error checking.

For a one-off export, native is fine. For ongoing data exchange, an add-in saves time.

Cost and Safety Considerations

There is no cost for the built-in export/import features—they are part of Revit. Dynamo is also free. Paid add-ins vary in price; for example, Ideate Sticky costs around $150 per year. Always download add-ins from official Autodesk App Exchange or the vendor’s site to avoid malware.

When importing data, always back up your Revit project first (save a copy). Importing can overwrite parameters, and mistakes are hard to undo. Also, be careful with shared parameters—if you import data into a shared parameter, it may affect multiple families.

Frequently Asked Questions

Can I link an Excel file to Revit so it updates automatically?

No, Revit does not support live Excel links. You must re-import manually or use a third-party add-in that offers synchronization (e.g., some add-ins can watch a file and update on save).

Why does my exported schedule show # signs or garbled text in Excel?

This usually happens when the delimiter is not set correctly. Use Tab delimiter instead of Comma if your data contains commas. Also, ensure the schedule has no merged cells—Revit exports each cell separately.

Can I import an Excel file to create multiple Revit elements (like doors or rooms)?

Yes, but you need Dynamo or an add-in. Native import only creates a schedule, not model elements. Dynamo can read Excel and create elements by placing them at coordinates or matching existing elements.

What is the best file format for export/import: CSV or TXT?

CSV (comma-separated) is more standard and opens directly in Excel. TXT with tab delimiters is also fine. Just ensure the encoding is UTF-8 to avoid character issues with non-English text.

Does Revit for Mac support Excel import/export?

Revit is not available for Mac. You must run Revit on Windows (or in a virtual machine). The export/import features are the same on Windows only.

Can I export a Revit schedule to Excel with formulas?

No, Revit exports values, not formulas. If you need calculated fields, create them in Revit as calculated parameters, then export those values.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.