Pro Tips for Renumbering Sheets

Ideate BIMLink can be utilized to batch rename and renumber sheets in your Revit project.

The Revit interface has limitations in terms of editing large amount of data. Ideate BIMLink allows you to edit model data by exporting it to Excel and pushing it back into Revit. The basic steps for this process are covered in our Help topic: How to Batch Rename or Renumber Sheet s.

If you need to tackle some more complex challenges, in this blog post I’ll highlight the power of Excel functions and formulas when utilizing Ideate BIMLink for sheet renumbering.

Here is an example:

Utilize the adjacent column to enter the following formula, then drag down to autofill the values.

=LEFT(A1,1)&"."&TEXT((RIGHT(A1,3)+10),"000")

List of Excel functions utilized in this function:

2. Copy the resulting information from column B and use the Paste Special>Values function to move the data back into Sheet Number column, save Excel, and import it back into Revit via Ideate BIMLink.

This is the result:

< Older Post

Newer Post >

Explore recent posts

Material Passports and Ideate Software

November 25, 2025

TRAINING - ARTICLE | One specific area of digital transformation, regulatory shifts, or market demands is the Circular Economy  - which aims to eliminate waste and keep materials in use for as long as possible.

DWG Exports to ISO 19650 using Ideate Automation

November 25, 2025

TRAINING - ARTICLE | Creating DWG exports from Revit models is still an important deliverable in most AEC projects. When exporting to DWG from Revit, there is no way to control the names of the resulting dwg exports. We are limited to the choice of Short (sheet number) or Long (Revit model name, sheet, etc.).

Generate Curtainwall Elevations in Revit Using Ideate ViewCreator

November 19, 2025

TRAINING - VIDEO | Easily create curtain wall elevations in Revit! Creating curtain wall elevations doesn’t have to be time-consuming. With Ideate ViewCreator, you can quickly generate curtainwall elevations from 2D view or 3D elements customize view naming, apply view templates, avoid duplication, etc.

Generate Material Quantity Takeoffs Using Ideate BIMLink

November 19, 2025

TRAINING - VIDEO | Generate material quantity takeoffs in Revit… automatically! Say goodbye to manual material exports. With Ideate BIMLink’s new ‘Material_QTO link definition, you can quickly export material instance data, areas, and volumes directly from your Revit projects.