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

Automated, Connected, and Protected Project Data with File Sync and Ideate Automation
February 19, 2026
BROCHURE - PDF | Ideate Automation and File Sync work together to standardize, synchronize, and safeguard project data across your AECO ecosystem.
Revit Content Creation Made Easy with Ideate Automation
February 10, 2026
TRAINING - ARTICLE | Ideate Automation provides a purpose-built solution for Revit content creation automation, allowing teams to use Microsoft Excel to drive data directly into Revit models and families.
Shell-ebrating Richard Taylor on His Birthday
January 4, 2026
NEWS - ARTICLE | This January 4th, we pause to remember and celebrate our friend and colleague Richard Taylor—a kind and generous person, a passionate technologist, and someone whose curiosity and joy for discovery infused the spirit of Ideate Software.
Material Passports and Ideate Software with Ideate BIMLink and Ideate Automation
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.
Show More