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 Sheets.


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: 

Pro Tips for Renumbering Sheets
  1. 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:
Pro Tips for Renumbering Sheets

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.

Pro tips for renumbering sheets

This is the result:

Renumbering Sheets

Explore recent posts

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.
Manage Model Material Assets Using Ideate BIMLink
November 19, 2025
TRAINING - VIDEO | Edit and swap material assets in Revit with ease! Ideate BIMLink just got even better - now you can swap appearance, physical, and thermal material assets in your Revit projects.
Create New Materials Using Ideate BIMLink
November 19, 2025
TRAINING - VIDEO | Create new materials in Revit… fast! With Ideate BIMLink’s new definition called ‘Material-Create_NEW’, you can now create new materials or add an existing material directly into your Revit models.
Show More