CAD/BIM Tips & Tricks
How to Import Excel into Revit and Keep It Updated
21 October 2026
The Excel™ schedule looked perfect. The trouble started when you needed to get it into Revit®.
That’s because Revit has no built-in tool for placing or linking an.xlsx file directly on a sheet. Users who want to link Excel to Revit must find another route, often involving extra conversion, repetitive work or a third-party plugin.
Even after the spreadsheet appears in Revit, another problem arises. In no time at all, someone has changed three quantities, added two notes and widened a column in the Excel source file. Aargh.
One of these is the truth. The other merely resembles it.
Now Excel contains the latest information while the data in your project is already out of date. If you’ve ever wondered whether two versions of the truth can coexist, you’ve just found the answer. One of these is the truth. The other merely resembles it.
If you need to import Excel into Revit, the first paste is only part of the answer. The real tests lie in the formatting and in what happens when the original spreadsheet changes. Can you update the Revit content without pasting it again? Can you control when revisions enter the Revit file? Will the formatting survive?
Microsoft Office Importer™ for Revit is designed to handle that ongoing relationship. This Revit plugin imports Excel content as native Revit elements and keeps the paste linked to its source workbook, so displayed values can be refreshed when the spreadsheet changes.
How Do You Import Excel Into Revit and Keep It Linked?
Office Importer creates a link when Excel content is pasted into Revit. That link allows the Revit content to be updated from the source workbook.
There isn’t a linked-or-static toggle for the user to choose during every paste. Pasted content is linked by default. What users control is whether links update automatically and whether a particular paste should continue to receive updates.
That matters when a project contains different kinds of spreadsheet content. A live Revit schedule may need every approved revision. A table showing an issued milestone may need to remain exactly as it appeared on that date.
Update only what needs changing. Keep everything else exactly as you left it.
The useful question isn’t simply, “Is this spreadsheet linked?” It’s, “When should this paste be updated, and is there any reason to keep it as it is?”
Does Excel Update Automatically in Revit?
It can. Office Importer provides three ways to refresh linked Excel content.
- It can update automatically, without being asked, when the Revit file opens. This works when users always need to see the latest Excel values.
- It can request your approval when the file opens. You then decide whether spreadsheet revisions should enter the project.
- It can be updated manually through the Manage or List of Links dialog boxes. This lets teams choose exactly when a refresh takes place.
You don’t have to stop every linked spreadsheet from refreshing merely because one table needs to remain unchanged.
Automatic updates make sense when the workbook is trusted and everyone needs the latest values. A prompt gives the user a chance to check first. Manual updates suit projects where revisions need to enter Revit at carefully chosen times.
Users can also prevent a specific paste from being updated. You don’t have to stop every linked spreadsheet from refreshing merely because one table needs to remain unchanged.
Can One Excel Workbook Supply Multiple Revit Tables?
Yes. One workbook can supply multiple linked pastes from different worksheets or cell ranges.
One range might contain room data, another might show equipment information and a third might contain general project notes. Each selection can be pasted where it belongs instead of forcing the entire workbook into one unnecessarily large table.
The imported cell range can also be changed later. The original selection isn’t permanent. If the spreadsheet grows, a heading is added or the required data moves within the worksheet, the range can be adjusted.
One Excel workbook can supply multiple linked tables throughout the Revit project.
Spreadsheets rarely remain unchanged. Rows appear, sections expand and a table from schematic design grows far beyond its original scope.
Do Excel Formulas Update in Revit?
If a cell contains a formula, Office Importer brings the displayed result into Revit, not the formula itself.
Suppose an Excel formula calculates a total quantity. Revit receives the total shown in the cell rather than the calculation behind it. When the workbook changes and the linked paste is refreshed, the newly displayed value can be brought into Revit.
Excel therefore remains responsible for the calculation. Revit displays the current result, but Office Importer isn’t recreating Excel’s formula logic inside the model.
Excel remains the master file.
Office Importer keeps imported document content current with its source, but it isn’t a bidirectional parameter-exchange tool that sends Revit edits back into Excel. Excel remains the master file.
Does Excel Formatting Stay Intact in Revit?
The formatting retained depends on the source, the paste settings and whether the content is pasted as a Schedule or as Notes and Lines.
Both methods support fonts, font sizes, bold, italic, underline, text color, borders, line weights, horizontal and vertical alignment, merged cells, wrapped text, row heights and column widths.
Schedule pastes also support fill color, while Notes and Lines pastes support images.
Office Importer creates native Revit elements. Depending on what is pasted and the selected settings, the elements may form a detail group. The result isn’t simply a screenshot of the spreadsheet.
How Do You Manage Excel Links in Revit?
The List of Links feature displays all linked pastes in the current Revit file in one dialog box. Users can review them, make individual changes and perform certain changes in bulk.
That beats the heck out of touring the entire model, trying to remember which table came from which workbook.
What If the Excel File Is Moved or Renamed?
A linked paste needs a valid route back to its workbook. If the source file is moved or renamed, the Revit content won’t update via the old link. The existing content doesn’t vanish, but future refreshes can’t reach the source until the link points to its new location. The workbook may be exactly where somebody intended to put it while Revit continues looking for an old path.
A moved workbook isn’t the only link problem a large Revit project may contain. Projects with massive numbers of linked files may also benefit from LinkFixer Advanced™, included in Axiom’s Productivity Toolkit™ for Revit. LinkFixer Advanced supports both Autodesk Revit and Microsoft Excel file types and can protect file links before files are moved or renamed.
The workbook may be exactly where somebody intended to put it while Revit continues looking for an old path.
That protection is worth using before a folder reorganization, server change or cloud migration. Office Importer supports Excel files stored in SharePoint, OneDrive, BIM 360 and Autodesk Construction Cloud (ACC).
Stop Repasting the Same Spreadsheet
Importing Excel into Revit shouldn’t create a new chore every time someone changes a value or adds a row.
With Office Importer, linked pastes can update automatically, request approval or refresh on command. Specific pastes can be held back, cell ranges can change as the spreadsheet develops and links within the current Revit file can be reviewed together. Office Importer can also import Word documents and PDFs into Revit.
Linked content doesn’t mean surrendering control to anyone who happens to edit the workbook. The Revit team still decides which pastes are updated and when. A spreadsheet import isn’t merely a one-time event. It becomes a connection the team can easily manage and maintain throughout the project.
Axiom's President
Oscar Albornoz
Feel free to share this article on your social media:
