The three ways to get spreadsheet data into Revit

1. Schedules (built in, free, fragile)

Create a schedule with the fields you need, export it (File → Export → Reports → Schedule) to a delimited text file, edit, then… there is no built-in import. You can paste a column back into the schedule view cell by cell, which works for a dozen rows and fails for a thousand. There is no validation: a typo in a length field silently fails or, worse, writes the wrong value.

2. Dynamo or pyRevit scripts (free, do-it-yourself)

Dynamo ships with Revit and can read Excel (Data.ImportExcel) and write parameters. It is a good fit if someone in the office maintains the graph, handles units, read-only parameters, type vs instance, and missing elements - because every one of those will come up on a real project.

3. A dedicated link add-in (productised)

Tools like Parapet Link and Ideate BIMLink exist because the edge cases are the whole job. What a good link tool does:

Reads Excel (.xlsx), CSV and - in Parapet Link - Google Sheets directly, so consultants can keep editing in a shared sheet.
Lets you choose the key column that identifies the element: Element ID, Mark, Room Number, Type Name…
Maps columns to parameters, including shared and project parameters, and can create missing shared parameters.
Validates before writing: wrong data type, read-only parameter, element not found, unit mismatch - flagged per cell, with a log you keep.
Writes in one transaction so it is one Revit undo.
Exports a selection to the same formats and round-trips edits back in.

Step by step with Parapet Link

Pick a source. In the Parapet ribbon tab click Link; choose an Excel workbook, a CSV file, or sign in to Google and choose a Sheet. Re-link later in one click.

Preview and map. See the rows, pick the key column, map every column to a Revit parameter. Fuzzy matching ("Fire Rating" → Fire Rating, "FR" → your shared parameter) does most of it.

Validate. Parapet Link checks every cell against the target parameter's type and units and tells you exactly which rows will be skipped and why.

Push. One transaction, one undo. Or go the other way: export the selected elements to Excel/Sheets, review offline, pull corrections back.

The round trip: spreadsheet in, validated values into Revit, export and pull corrections back.

Retyping vs linking

Retype from the spreadsheet

One element at a time, or one schedule per category
Typos land in the model silently
No record of what changed
Do it again when the consultant sends v7

Parapet Link

Key on Mark / Number / Element ID - any category, any order
Every cell validated against the parameter type and units
One transaction, one undo, a log you keep
Re-link v7 in one click - Google Sheets stays live

Typical jobs

Room programme from the client's spreadsheet → room names, numbers, departments; area check against target.
Door schedule maintained by the hardware consultant in Google Sheets → door parameters, live.
Equipment lists from MEP engineers (CSV exports) → families and spaces.
Classification (Uniclass, OmniClass, MasterFormat) and cost codes applied by type across the model.
QA: export, review offline, push corrections back.

Parapet Link vs the alternatives

	Parapet Link	Ideate BIMLink	DiRoots SheetLink	Dynamo
Excel				(graph)
CSV				(graph)
Google Sheets	live
Per-cell validation before write			partial	DIY
Create missing shared parameters				DIY
Revit versions	2020-2027	recent releases	recent releases	all
Price (2026)	$12/mo · $99/yr · 30-day trial	firm licensing, quote	free	free

Third-party details are from public vendor information in 2026 and may change; verify on their sites. Corrections welcome at [email protected].

FAQ

Can I import Excel into Revit without an add-in?

Only indirectly: paste into a schedule, or use Dynamo. Revit has no native "import parameters from Excel" command.

Does Parapet Link work with Google Sheets shared by a consultant?

Yes. Sign in with your Google account; any sheet you can open in the browser can be linked, and re-linking later pulls the latest rows.

What if a row's element does not exist in the model?

It is flagged in validation and skipped; nothing else is affected. The log lists every skipped row.

Which Revit versions?

Revit 2020, 2021, 2022, 2023, 2024, 2025, 2026 and 2027, one key for all of them.

Try Parapet Link free for 30 days

$12/month or $99/year after the trial. No card to start. Same installer as Hub and Audit.

Download Parapet Parapet Link details

Link Excel, CSV and Google Sheets to Revit.