How To

How to use IQ Tools

Every task in IQ Tools, in plain steps. Start with your first edit below; every other task is in the menu after it.

Your first edit (5 minutes)

IQ Tools never changes your model as you type. Edits wait in the grid, marked as staged. Revit changes only when you click Sync ↑ and confirm in Sync Review. Sync is not Revit's Synchronize with Central: your teammates see the change only after you Synchronize with Central in Revit as usual.

  1. Install IQ Tools and open it from the IQTools tab in Revit.
  2. In the CATEGORIES list, click Doors and click Load. You should see: one row per door.
  3. Double-click one door's Mark cell, type a new Mark and press Enter. You should see: the cell marked as staged, and the button reads Sync ↑ · 1 edit.
  4. Click Sync ↑. Sync Review lists your one change, with the old and new Mark.
  5. Click Sync to Revit. You should see: a message that starts “Synced to Revit —” and the staged mark gone.
  6. Check it in Revit: select that door and look at Mark in the Properties palette.

Changed your mind? Press Ctrl+Z once in Revit to undo the whole sync. See Discard a staged edit for edits you have not synced yet.

One door's Mark cell changed and staged, with the Sync button reading Sync ↑ · 1 edit.
Figure 1. Your first staged edit. Revit has not changed yet.
Sync Review listing one change: a door's Mark, old value and new value.
Figure 2. Sync Review shows the one change before anything is written.

Trial and licence

A new install starts a 14-day trial with every feature on this page. When the trial ends:

  • You can still open IQ Tools, load categories, search, filter and export, and select, zoom to or isolate elements in Revit.
  • You can't stage new edits or sync them to Revit until you activate a licence.
  • Edits you had already staged are kept, ready to sync once you activate.

All tasks

Each task is a few numbered steps. For how staging and Sync work in detail, see the Sync Review model.

Get started

Install IQ Tools and open it

  1. Download the installer from iqtoolspro.com/download.
  2. Close Revit.
  3. Right-click the IQ Tools MSI and choose Install. You need administrator rights; if you don't have them, ask IT.
  4. Start Revit and open your model.
  5. The first time, Revit asks about the signed IQ Tools add-in. Choose Always Load.
  6. You should see: an IQTools tab on the Revit ribbon.
  7. On the IQTools tab, click IQData. The IQ Tools window opens beside Revit and connects to the open model.
  8. You should see: the project name and your trial days in the footer, and the CATEGORIES list on the left.
The IQ Tools footer after it connects, showing the project name and the trial days left.
Figure 3. The footer shows which model IQ Tools is connected to.
The IQ Tools window just after it opens: the CATEGORIES list on the left, an empty grid, and the footer with the project name.
Figure 4. IQ Tools after it connects: pick categories on the left.

Back to all tasks

Reconnect after Revit restarts

  1. If you close and reopen Revit, or open a different model, click ⟳ Reconnect on the toolbar (Ctrl+Shift+R).
  2. IQ Tools connects to the model that is open in Revit.

Back to all tasks

Change, review and sync

Change a value in a cell

  1. Double-click a cell, or select it and start typing.
  2. Press Enter to keep the new value, or Esc to cancel it.
  3. You should see: the cell marked as staged, and the Sync button counting it, for example Sync ↑ · 1 edit. Revit has not changed yet.
  4. If a cell cannot be edited, hover over it. A tooltip says why, for example “Area is read-only for Doors (set by Revit)”.
The tooltip on a read-only cell explaining why it cannot be edited.
Figure 5. Hover a read-only cell to see why: here, Area on Doors.

Back to all tasks

Discard a staged edit

  1. While you are still typing in a cell, press Esc. The cell goes back to its old value and nothing is staged.
  2. To drop an edit you have already made, right-click the staged cell and choose Discard staged edit. The cell goes back to the value Revit holds.
  3. To drop every staged edit at once, click Sync ↑ and choose Cancel all edits in Sync Review.
The right-click menu on a staged cell with Discard staged edit highlighted.
Figure 6. Discard one staged edit.

Back to all tasks

Review and sync your changes to Revit

  1. Click Sync ↑ on the toolbar. It shows how many edits are staged.
  2. Sync Review lists every staged change: element, parameter, old value and new value. A type rename is listed once, with the number of elements it affects.
  3. Check the list, then click Sync to Revit. Click Close to go back without syncing, or Cancel all edits to drop them.
  4. You should see: a message that starts “Synced to Revit —”, the staged marks gone, and the button back to Sync ↑. IQ Tools re-reads the categories you edited, so the grid shows the values Revit now holds.
  5. To undo a sync, press Ctrl+Z once in Revit. A sync is one step in Revit's Undo list, named IQTools: Sync. IQ Tools shows Revit's values again the next time you Load that category.
  6. Sync is not Revit's Synchronize with Central. Your teammates see the change only after you Synchronize with Central in Revit as usual.
The Sync Review window listing two staged changes with old and new values.
Figure 7. Sync Review: every change, before anything is written.

Back to all tasks

Load and find

Load a category into the grid

  1. In the CATEGORIES list, click the category you want, for example Doors. Type in Filter categories… to find it quickly.
  2. Click Load.
  3. You should see: one row per element in the grid, with that category's default columns.
  4. To load more than one category, Ctrl+click each one before you click Load. The first column is then Category, and it stays in place when you scroll right.
Doors selected in the CATEGORIES list and loaded into the grid, one row per door.
Figure 8. Click a category, then Load.
Doors and Windows loaded together, with the Category column first in the grid.
Figure 9. Two categories in one grid, with the Category column first.

Back to all tasks

Choose the columns you see

  1. With a category loaded, use the COLUMNS list in the sidebar. Tick a parameter to show it, untick it to hide it.
  2. Or right-click a column header and choose Hide column, Show all columns or Columns….
  3. Click Reset in COLUMNS to return the category to its default columns.
The COLUMNS list in the sidebar with some parameters ticked, and the Reset button.
Figure 10. Tick the parameters you want as columns.

Back to all tasks

Filter a column

  1. Click the funnel button in a column header, or right-click the header and choose Filter….
  2. On By value, tick the values to keep. On By condition, pick a condition such as is blank or begins with. Click Apply.
  3. To remove filters, click Clear filter in the same place, or ✕ Clear filters on the filter bar to clear them all.
  4. To search inside each column, click Search row on the filter bar (Ctrl+Shift+F). A search box appears under every column header; * and ? work as they do in Excel.
A column filter open on the Level column, with some levels ticked.
Figure 12. Each column has its own filter.
The Search row turned on, with a search box under every column header and an asterisk pattern typed in one.
Figure 13. Search row: one box per column.

Back to all tasks

Group rows by a column

  1. Right-click a cell or header in the column you want to group by.
  2. Choose Group by this column. Rows are grouped under each value, with a count.
  3. Use Expand all groups, Collapse all groups or Remove Grouping from the same menu.
Doors grouped by Level, with group headers and counts.
Figure 14. Grouped by Level.

Back to all tasks

List in-place families and CAD references

  1. In the sidebar's MODEL list, click In-place families to load every category that has an in-place family, filtered to the in-place elements.
  2. In the REFERENCES list, click CAD references (DWG) to list the DWG files in the model, grouped by file or by placement.

Back to all tasks

Edit and fill

Edit in the Inspector

  1. Select one row. The Inspector on the right shows the element's parameters in sections. Use Expand all or Collapse all to open or close them.
  2. Change a value in the Inspector. It is staged, exactly like a grid edit.
  3. Select several rows to edit them together. The Inspector header says how many elements are selected, for example “12 elements selected”, with a count per category when there is more than one. A parameter whose values differ shows Varies (N), where N is the number of different values. Type one value and it is staged for every selected element.
  4. Type parameters are in the Type Parameters section, at the bottom. A type parameter belongs to the type, so changing it changes every element of that type, including ones you have not selected. After a bulk change to a type parameter in the grid (for example Fill Down or Paste Update), the footer shows how many rows were in the batch and how many other elements inherit the change; click it to select them. A single edit in the Inspector does not show this count.
The Inspector showing one door's parameters in sections, with one value being edited.
Figure 16. The Inspector for one element.
The Inspector with twelve doors selected; a parameter shows Varies (3).
Figure 17. Several elements: values that differ show Varies (N).

Back to all tasks

Change an element's type

  1. Load the category, for example Doors, and show the Type column (Revit's Type parameter).
  2. Click the Type cell of the element. The dropdown lists the types you can change it to. Type part of a name to narrow the list.
  3. Choose the new type. The change is staged, and the row's type values update to the new type's values so you can check them before you sync.

Back to all tasks

Fill Down

  1. Select the rows you want to fill (click the first, Shift+click the last).
  2. Right-click the cell that holds the value you want, in the column to fill, for example Comments, and choose Fill Down. Every selected row gets that value in that column, and each change is staged.
  3. Don't fill Mark down: every element would get the same Mark. To number Marks, use Fill Down Sequential.
Five rows selected and the right-click menu, opened on a Comments cell, with Fill Down highlighted.
Figure 20. Select the rows, then right-click the Comments cell with the value and choose Fill Down.

Back to all tasks

Fill Down Sequential (numbering)

  1. Select the rows you want to number. They are numbered from top to bottom.
  2. Right-click a cell in the column to number, for example Mark, and choose Fill Down Sequential….
  3. Set the Prefix, Start, Step and Suffix, for example prefix D- and start 101, and click Apply. The new values are staged.
The Fill Down Sequential dialog with a start value and step filled in.
Figure 21. Number a run of cells in one go.

Back to all tasks

Find & Replace in a column

  1. Right-click any cell in the column and choose Find & Replace in this column…. It works on text columns of instance parameters, such as Mark or Comments. It is not offered on type parameter columns (such as Type Mark or Description), or on Rooms and Areas columns in this version.
  2. Type the text to find and the Replace with text. Choose whether to match part of a cell or the whole cell, and check the count of cells that will change.
  3. Click Apply. The changes are staged.
The Find & Replace dialog for one column.
Figure 22. Find & Replace works on one column.

Back to all tasks

Normalize values (merge spelling variants)

  1. Normalize merges spelling variants of the same value into one. Right-click a cell in the column you want to tidy and choose Normalize values….
  2. IQ Tools lists the column's values. Select the variants to merge, for example “Fire Rated”, “fire rated” and “FireRated”, and type the one value to keep under Normalize to.
  3. Click Apply. The changes are staged.
The Normalize values dialog with two spellings of the same value selected and the value to keep typed in.
Figure 23. Fold variant spellings into one value.

Back to all tasks

Rename types and materials

  1. To rename a type, edit the Type Name cell of any element of that type. The type is renamed once, and every element of that type shows the new name.
  2. To rename a material, load Materials and edit the Name cell.
  3. A name Revit would refuse is refused as you type it, with a short reason in the status line.
  4. Renaming a type changes the name everywhere Revit shows it, such as tags and schedules. View filters, schedule filters, Dynamo scripts or spreadsheets that match the old name may need updating. Linked models keep their own type names.
A Type Name cell edited, with every door of that type showing the new staged name.
Figure 24. One type rename shows on every element of that type.

Back to all tasks

When Revit refuses a change

  1. If Revit refuses a change, Sync Review says how many synced, for example “1 of 2 synced”, and lists each refused row with the reason in plain words. The other rows still sync.
  2. Click Keep for Retry to keep the refused edits staged, fix the cause, and sync again. Or click Cancel Failed Edits.
  3. If Revit shows one of its own questions during a sync, IQ Tools waits and says so in the footer. Answer the question in Revit and IQ Tools carries on.
Sync Review after a sync, with one row refused and its reason shown.
Figure 25. “1 of 2 synced”: the refused row keeps its reason and stays staged.

Back to all tasks

Set a view's View Template

  1. Load Views.
  2. Click the View Template cell of a view. It is a dropdown.
  3. Choose a template, or none. The change is staged.
The View Template dropdown open on the Level 1 floor plan, listing None and the model's view templates.
Figure 26. Pick a template, or none.

Back to all tasks

Enter keynote values

  1. Load a category whose types carry a Keynote, for example Walls, and show the Keynote column.
  2. Click a Keynote cell. The dropdown lists every code in the model's keynote file as “code — description”. Type any word of the description to narrow the list.
  3. Choose a code. The change is staged, like any other edit.
  4. You can also type a code by hand. It is accepted when it is in the keynote file, and refused with “not a keynote code in this model's keynote file” when it is not.
  5. If no keynote file is loaded, the dropdown offers the values already used in the model, and the column header's tooltip says so.
  6. After you edit the keynote file in Revit, click ⟳ Reconnect to reload it.

Back to all tasks

Mirror your Revit selection

  1. Tick Live selection above the pane below the grid.
  2. Select elements in Revit. They appear in the pane, with their parameters.
  3. Use ▦ Columns in that pane to choose which parameters it shows.
The Live selection pane under the grid showing two elements selected in Revit.
Figure 29. What you select in Revit shows below the grid.

Back to all tasks

Select, Zoom and Isolate in Revit

  1. Select one or more rows in the grid.
  2. Right-click and choose Select, Zoom or Isolate.
  3. Revit selects those elements, zooms the active view to them, or isolates them in the active view.

Select, Zoom and Isolate work with or without a licence.

Three rows selected and the right-click menu showing Select, Zoom and Isolate.
Figure 30. Find the rows' elements in Revit.
After Select, the Live selection pane below the grid lists the same three doors, now selected in Revit.
Figure 31. After Select, the Live selection pane shows what Revit now has selected.

Back to all tasks

Edit and renumber in the Live selection pane

  1. Tick Live selection above the pane below the grid.
  2. In Revit, click the elements one at a time, in the order you want them numbered. The pane lists them in that order, and the # column shows it.
  3. To number them in another order, click a column header in the pane to sort it. The numbering follows the rows from top to bottom as the pane shows them.
  4. In the pane, click the first row and Shift+click the last to select them.
  5. Right-click a cell in the column you want to number, for example Mark, and choose Fill Down Sequential…. Set the prefix, start and step, and click Apply.
  6. Fill Down, Find & Replace in this column…, Normalize values… and typing in a cell all work in the pane, just as in the main grid.
  7. Click Sync ↑ and check Sync Review.
  8. If you click elements very quickly, or select several at once with a window, Revit reports them together and the pane lists them in element ID order. Check the # column before you renumber, or sort first.
The Live selection pane listing four doors in click order, with the # column, the rows selected and Fill Down Sequential on the right-click menu.
Figure 32. The pane lists your Revit selection in click order. Renumber from the right-click menu.
The Live selection pane after renumbering: the Mark cells read D-101 to D-104, staged.
Figure 33. The new numbers follow the pane's rows, top to bottom.

Back to all tasks

Find elements with warnings

  1. Load a category. The Warnings column shows how many Revit warnings name each element. If you hid it, tick Warnings in COLUMNS.
  2. Use the Warnings column's filter, or sort it, to bring the elements with warnings to the top.
  3. Select those rows, right-click and choose Select, Zoom or Isolate to find them in Revit.
  4. Or right-click in the Warnings column and choose Select flagged in Revit. Every visible row with a warning is selected in the grid and in Revit.
Doors sorted by the Warnings column, with the right-click menu showing Select flagged in Revit.
Figure 34. The Warnings column counts the Revit warnings on each element.

Back to all tasks

Why can't I see this element?

  1. Select one element, in the grid or the Live selection pane.
  2. In the Inspector, open the VISIBILITY section and click Diagnose.
  3. IQ Tools checks the element against Revit's active view and shows a verdict: visible, or the first reason it is hidden. The list below shows each check it ran.
  4. If the active view is a sheet, legend or schedule, IQ Tools checks the first model view it can use instead. It cannot diagnose a view template.
The Inspector's VISIBILITY section after Diagnose: the verdict says the door is hidden because it falls outside the view range, with the 14 checks listed and View Range marked as failed.
Figure 35. Diagnose explains why an element is or is not visible in the active view.

Back to all tasks

Work with Excel

Export the grid to Excel (CSV)

  1. Set up the grid the way you want it: columns, filters, search.
  2. Click ⤓ Export… on the filter bar, or press Ctrl+E. The Export grid view window opens.
  3. Choose CSV file and click Export…, then open the file in Excel. Or choose Copy to clipboard (TSV) and paste straight into a sheet.
  4. Saves you building a Revit schedule and exporting it just to get a list into Excel.
The Export grid view window with CSV file selected.
Figure 36. Export what the grid is showing.

Back to all tasks

Copy rows to Excel

  1. Select the cells or rows you want.
  2. Right-click and choose Copy (with headers) or Copy values only.
  3. Paste into Excel.
  4. Saves you exporting the whole grid when you only need a few cells.
The right-click menu with Copy (with headers) and Copy values only.
Figure 37. Copy with or without the column headers.

Back to all tasks

Paste Update from Excel

  1. Start from an export: export the grid, then edit the values in Excel. Keep the header row and a column that identifies each element, such as ElementId or Mark.
  2. In Excel, select the block (headers included) and copy it.
  3. In IQ Tools, click ⧉ Paste Update… on the filter bar, or press Ctrl+Shift+V. The Paste Update window shows what is on the clipboard.
  4. Check the Match key: the column IQ Tools uses to find each element in the grid. Then check the column mapping (pasted column → parameter).
  5. Click Apply. The changes are staged for Sync Review.
  6. If two parameters share a name, such as a project parameter “Mark” and Revit's own Mark, check the parameter in Sync Review before you sync, or paste with both columns loaded.
  7. Saves you opening each element's properties to type values in one by one.
The Paste Update window showing the clipboard row count, the match key and how each column maps to a parameter.
Figure 38. Map the Excel columns, then Apply.

Back to all tasks

Common jobs

Renumber doors or rooms along a corridor

  1. Tick Live selection, then in Revit click the doors or rooms one by one along the corridor, in walking order. See Edit and renumber in the Live selection pane.
  2. Check the # column in the pane matches your walking order.
  3. Select every row in the pane, right-click a Number (rooms) or Mark (doors) cell and choose Fill Down Sequential….
  4. Enter a prefix and start, for example W- and 101, and click Apply.
  5. Click Sync ↑, check the old and new numbers in Sync Review, and click Sync to Revit.

Back to all tasks

Fill in missing Marks

  1. Load the category, for example Doors.
  2. Open the Mark column's filter, click By condition, choose is blank and apply it. The grid shows only the elements with no Mark.
  3. Press Ctrl+A in the grid to select every row the filter shows.
  4. Right-click a Mark cell, choose Fill Down Sequential…, enter a prefix and start, and click Apply.
  5. You should see: the rows leave the filtered list as they are numbered, because their Mark is no longer blank. An empty list means every element has a Mark.
  6. Sync.
The Mark column filter on the By condition tab, with is blank chosen.
Figure 40. is blank shows the elements with nothing in that column.

Back to all tasks

Check sheets are complete before an issue

  1. Load Sheets. Drawn By, Checked By and Sheet Issue Date are among the default columns.
  2. Filter Sheet Issue Date by the condition is blank. The grid shows the sheets with no issue date.
  3. Press Ctrl+A, then type the date once in the Inspector's Sheet Issue Date row. It is staged for every selected sheet.
  4. You should see: the sheets leave the filtered list as soon as the date is staged, because they are no longer blank. The Inspector still shows them selected, with the staged date. An empty list means every sheet has a date.
  5. Clear that filter and repeat for Checked By and Drawn By.
  6. Sync.

Back to all tasks

Remove a prefix from many values

  1. Load the category, for example Doors, and filter the Mark column by the condition begins with and the prefix, for example “TMP-”.
  2. Right-click a Mark cell and choose Find & Replace in this column….
  3. Type the prefix in the find box and leave Replace with empty. Keep Substring, and set Scope — rows to the current filtered rows.
  4. Check the count of cells that will change and click Apply.
  5. Sync.

Back to all tasks

Update rooms from a program spreadsheet

  1. Load Rooms, with the columns you will update, for example Department.
  2. In Excel, copy the program table with its headers, including a column with each room's Number.
  3. In IQ Tools, press Ctrl+Shift+V. Set Match key to Number and check the column mapping.
  4. Read the match report, for example “38 matched · 2 unmatched · 0 ambiguous”. Unmatched rows are listed so you can follow them up; they are not staged.
  5. Click Apply, then Sync and check Sync Review.
Paste Update matching program rows to rooms by Number: 7 rows on the clipboard, 6 matched, 1 unmatched and 0 ambiguous, with the unmatched Number listed.
Figure 43. The match report says exactly what will and will not update.

Back to all tasks

Issue sheets for a permit set

  1. Load Sheets.
  2. Filter Checked By and Drawn By each by the condition is not blank. The filter bar shows them as Checked By ≠ Ø · Drawn By ≠ Ø, and the grid shows only the sheets that are ready to issue. Use Check sheets are complete first if some are missing.
  3. Press Ctrl+A (or select the sheets you are issuing), then type the issue date in the Inspector's Sheet Issue Date row. Fill any issue parameter your project uses the same way.
  4. Sync and check Sync Review.
  5. For a transmittal, keep the filter, choose the columns you want (Sheet Number, Sheet Name, Drawn By, Checked By, Sheet Issue Date), press Ctrl+E and export a CSV file.
Sheets filtered to Checked By ≠ Ø and Drawn By ≠ Ø, all three selected, with the issue date staged in the Inspector.
Figure 44. Filter to issue-ready sheets, set the date once, then sync.

Back to all tasks

Licence and account

Buy a licence

  1. Open the menu at the top right (☰, or F10).
  2. Choose Buy a licence…. The pricing page opens in your browser. You can also buy at iqtoolspro.com.
  3. Your licence key arrives by email.
The ☰ menu open, showing Licence… and Buy a licence….
Figure 45. The menu at the top right.

Back to all tasks

Activate your licence

  1. Open the menu (☰) and choose Licence…, or click the licence text in the footer.
  2. Paste the licence key from your email and click Activate online.
  3. No internet on this computer? Type your key in the same window and it shows an activation request as a QR code and as text. On any device with internet, scan the QR code or open the request on the account page to get an activation code. Type the code (30 groups of six characters) into the window and click Activate with code.
  4. When the trial ends, editing stops until you activate. Your staged edits are kept.
The Activate licence window with an empty key box and the Activate online button.
Figure 46. Paste your key, then Activate online.

Back to all tasks

Move your licence to another computer

  1. Email support@iqtoolspro.com and say which computer you are moving to. Please do not send your licence key.

Back to all tasks

Get help

  1. Email support@iqtoolspro.com with what you did, what you expected and what you saw. A screenshot helps.
  2. Attach the logs from the time it happened: the IQ Tools log in %LOCALAPPDATA%\IQData\logs\ and the Revit add-in log in %LOCALAPPDATA%\IQData\addin\logs\. Paste the path into File Explorer's address bar to open the folder.

Back to all tasks