← Back to the Help Center
Tutorials › Productivity › Fluxor Tables

Fluxor Tables — Excel and Revit: import, sync and export

💡 Bring an Excel spreadsheet into Revit as a table, update it with one click when the spreadsheet changes, and export the project's tables into formatted .xlsx — in one or several files.

What it does

Fluxor Tables connects Revit tables to Excel, in both directions:

  • Import — the spreadsheet shows up in the preview just like in Excel; you drag the region and it becomes a table in the project, with colors, merged cells, borders and logo.
  • Sync — did the spreadsheet change? One click updates the table you imported, without redoing anything.
  • Export — the project's tables, including panel schedules, become sheets in a formatted .xlsx file. You choose how many files and what goes in each one.
ℹ️ Note: Fluxor Tables is free. Just be signed in with your Fluxor account in Revit — without signing in, the button stays greyed out.

Scenario used in this article

An electrical project and the Fluxor Tables Exemplo.xlsx spreadsheet, with the Quantitativo do modelo - Fluxor MEP table on the Quantitativo sheet.

Fluxor Tables Exemplo spreadsheet open in Excel, Quantitativo sheet, with the Quantitativo do modelo - Fluxor MEP table

Part 1 — Import the spreadsheet into Revit

  1. Open the tool and choose the spreadsheet. On the Fluxor ribbon, Productivity panel, click Fluxor Tables. The window opens in 1 · Import (Excel → Revit). Click Choose spreadsheet… and select the .xlsx.
  2. Check the preview. The sheet shows up in the center just like in Excel. At the bottom of the preview are the file's sheets — click to switch. Ctrl + mouse wheel zooms. Preview of the Quantitativo sheet inside Fluxor Tables, with the Quantitativo and Cronograma sheet tabs at the bottom
  3. Drag the region and save it. Click the first cell of the table and drag to the last one. On the right, under Region, the address shows up — here, A1:G20 (20 × 7). Click Save selection. To import the whole sheet without dragging, use Whole sheet.

    Want more than one table? Drag and save each region, even from different sheets: each one becomes a view.

    Region A1:G20 selected and saved in the preview, and the Spreadsheet → Revit panel showing the address
  4. Create it in Revit. Check the View type (Table is the default) and View name, and click Create in Revit. The table is created and opened on screen. Don't like it? Ctrl+Z undoes all of it at once.

    Compare the two sides: structure, colors, merged cells, widths and the logo all came through the same. Numbers come out with a decimal period and left-aligned.

    Original spreadsheet in Excel on the left and imported table in Revit on the right: same structure, colors and logo; numbers with a decimal period, left-aligned
💡 Table or Drafting View? Stick with Table: it goes onto the sheet like any Revit table and can be synced. Drafting View creates loose text and lines, at a scale of your choosing, for when you want to touch it up by hand.

Part 2 — Sync when the spreadsheet changes

  1. Edit and save it in Excel. In the example, the title gets - SINCRONIZAR added to it. Save it (Ctrl+S). In Revit, the table still shows the old text — nothing changes on its own. Excel with the title already changed to Quantitativo do modelo - Fluxor MEP - SINCRONIZAR, the new part underlined in red
  2. Click Sync. Open Fluxor Tables. In Import mode, the TABLES IMPORTED FROM EXCEL list shows every table that came from a spreadsheet, with its sheet, region and source file — no need to choose any file. Click Sync on the table's row. Tables imported from Excel list with the Fluxor Tables Exemplo view and the Sync button
  3. Done. The table in Revit already shows the spreadsheet's current content. A table that gained rows in Excel comes in whole; one that lost rows shrinks. Ctrl+Z undoes it. Table in Revit with the title Quantitativo do modelo - Fluxor MEP - SINCRONIZAR after syncing, the new part underlined in red
ℹ️ If the spreadsheet moved to a different folder, the row shows file not found, and clicking Sync makes the tool ask where it is now. New columns in the spreadsheet aren't tracked: in that case, import the region again.

Part 3 — Export tables from Revit to Excel

Each set is an .xlsx file; each sheet inside it is a table. In the example, two files come out: Legenda de Pontos.xlsx, with two material lists, and QD.xlsx, with the panel schedule.

  1. Check the tables. Click 2 · Export (Revit → Excel). The PROJECT TABLES list brings every table in the model, grouped by type — the panel schedule is under Panel Schedules. Check Lista de Materiais - Disjuntor and Lista de Materiais - Dispositivos Elétricos: each checked table becomes a sheet at the bottom of the preview.

    In the image, the three places that matter: the tables in the model (left), the File name field (top) and the selected sheets (bottom). The set already shows renamed to Legenda de Pontos, which is the next step.

    Export mode with three highlights: the PROJECT TABLES list (tables in the model) with Disjuntor and Dispositivos Elétricos checked, the File name field, and the two sheet tabs at the bottom of the preview (selected tables)
  2. Name the file. In File name:, type Legenda de Pontos. The header confirms: SET · 'Legenda de Pontos.xlsx' will be generated. First set, Legenda de Pontos, with the Lista de Materiais - Disjuntor preview and the two sheet tabs at the bottom
  3. Create the second file. Click New set. It starts out empty, as Arquivo 2. Check QD · QD under Panel Schedules and rename it to QD. The header switches to SETS · 2 files will be generated and the button at the bottom becomes Export 2 files. Click each set in the strip to see its sheets. Strip with the Legenda de Pontos (2 tables) and QD (1 table) sets, QD in focus and highlighted, an arrow pointing at the New set button, the panel schedule preview and the Export 2 files button
  4. Export. Click Export 2 files and choose the folder. With a single set, the button reads Export to Excel and asks for the file name. With Open when done on, the folder opens with the finished files.

    Open QD.xlsx next to the panel in Revit: same title on a yellow strip, same headers, borders and totals. Widths and line breaks may vary a little.

    Comparison labeled REVIT and EXCEL: the QD panel schedule in Revit on the left and QD.xlsx open in Excel on the right, same title, headers and totals, with small differences in width and line wrap
💡 Useful options (right-hand panel): Summable values in Excel turns quantities into numbers, so they can be summed in Excel — by default everything comes out as text. Bring hidden columns includes the table's hidden fields. Resume this selection later remembers what you checked for the next time you open it.

Edit in Excel and bring it back

The exported spreadsheet comes out ready to receive edits and send them back to the model (the Prepare for reimport option, on by default). In Import mode, choose that spreadsheet, click Analyze differences, check the list of what changed, and click Apply to Revit. Only what you check gets written, and Ctrl+Z undoes all of it.

What comes back are the body cells of itemized tables that point to a single element with a writable parameter. Titles, totals, calculated fields, grouped tables and panel schedules are read-only.

Common errors

SymptomWhat to do
Greyed-out button on the ribbonSign in with your account under Fluxor › Sign in
I changed it in Excel and nothing changed in the preview or when syncingThe tool reads the last saved version: Ctrl+S in Excel and try again
file not found in the list of imported tablesClick Sync and point to where the spreadsheet is now
"The file is open in Excel" on exportClose the file, or export under a different name
Numbers don't sum in ExcelTurn on Summable values in Excel before exporting

Video