- Revit How-To
- Schedules & Data
How to Import Excel into Revit
Six steps in Revit, or one sentence in Mira.
Do it with MiraRevit has no built-in Excel import. To show a spreadsheet on a sheet, rebuild it as a schedule or place it as an image. To write a spreadsheet's values into elements, edit them through a schedule.
Or, just ask Mira, a free add-in, to match each row to an element by its Mark and fill the parameters in one pass.
How to do it in Revit
Step 1: Decide which job you need
People search for this when they want one of two things, and Revit treats them very differently:
- Show a spreadsheet on a sheet. A code summary, a consultant's equipment list, a hardware set table. The data doesn't need to live in the model; it needs to print.
- Write a spreadsheet's values into elements. Fire ratings, hardware sets and finishes for 300 doors, from a table someone else maintains. The data has to land in each door's parameters, so schedules and tags read it.
The first job has workarounds. The second is very time-consuming.
Step 2: To show it on a sheet, pick a route
Revit can't link or embed an Excel file. Pick the route that matches how often the table changes.
- Rebuild it as a schedule. If the table describes model elements (doors, rooms, equipment), make a schedule and let Revit fill it from the model. See Revit schedules. If the table is typed values that aren't in the model, a key schedule holds typed rows and places on a sheet like any schedule.
- Place it as a picture. Save the range from Excel as a PDF or an image, then use Insert tab › Import panel › PDF or Image and place it on the sheet. It prints well. It doesn't update.
- Use a link add-in. Several Revit plugins keep a live link between a workbook and a schedule. Check that your firm's IT has approved one before you build a sheet set on it.
The picture route causes the most trouble later. It shows the data as it was on the day someone exported it, and nothing in the model warns you when the spreadsheet changes.
Step 3: To write values in, make sure the parameters exist
Revit reads and writes parameters, not files. The round trip goes out through a schedule and back in by hand or with a tool.
Revit fills only parameters the elements already have. For new data, add a project or shared parameter first in Manage tab › Settings panel › Project Parameters.
Step 4: Export a schedule with a key column
Include Mark, or another value that's unique per element, plus every field you plan to change. The steps are in export a schedule to Excel (Autodesk Help: Export a Schedule).
Step 5: Edit the values in Excel
Keep Mark as text, so 007 doesn't turn into 7.
Step 6: Bring the values back
For a few dozen rows, type them into the schedule: editing a schedule cell changes the element's parameter. For more, use a Dynamo graph that reads the workbook, an add-in, or Mira.
What to watch for
Type parameters change every element of that type. In many door families, Fire Rating is a type parameter. Writing "90 MIN" to one door's row changes every door of that type, including doors on sheets someone else finished.
Units come in wrong. Revit stores lengths in feet internally. A script that writes "2.5" into a length parameter without converting sets 2.5 feet, not 2.5 inches.
Marks repeat or go missing. Two doors marked 104 means one row updates both, or one of them silently. A row whose Mark no longer exists updates nothing, and nothing tells you.
Some parameters are read-only. Calculated values such as area can't be written, whatever the spreadsheet says.
Updating 12 doors by hand is fine. The trouble starts when the hardware consultant reissues their schedule for 340 doors the week before a deadline. The errors are easy to miss: a Mark typed twice, a value in the wrong unit, a type parameter that changed doors nobody meant to touch. Revit doesn't tell you which rows didn't land, so someone checks the printed schedule line by line.
Or, just ask Mira to do it.
Mira is an AI thinking partner for Revit that automates the work you repeat and builds tools your team needs.
- Type this in Mira
Update these door parameters from this table.
Paste the rows from Excel, Mark column included. Mira matches each row to a door by Mark, tells you about any Mark it can't find or finds twice, and shows how many elements and parameters it will change before it writes.
Can you link an Excel file to Revit?
Can Revit update parameters from Excel?
Why did my values come in wrong?
Do I need Dynamo to import Excel into Revit?
Will Mira create a parameter that's missing?
Try it yourself.
Or bring it to the firm.
The download is free and takes a minute. The firm conversation is where your standards, your library, and your rollout get built. Start wherever makes sense.