Schedule Excel

Work with your Revit schedules in Excel - edit data, make changes, and bring it back to Revit.

What It Does

Schedule Excel lets you export Revit schedules to Excel spreadsheets, make changes there, and then import your updated data back into Revit. This is perfect when you need to use Excel's powerful features or when team members who don't have Revit need to work with the data.

Key Benefits

  • Work in Excel: Use familiar Excel tools for editing and analysis
  • Share Easily: Team members without Revit can review and edit schedules
  • Bulk Edits: Change many rows at once using Excel's find/replace
  • Safe Updates: See what will change before importing back to Revit
  • Flexible: Export one schedule or many at once

How to Export to Excel

Step 1: Select Schedules

  1. Click "Schedule Excel" on the NeroScale ribbon
  2. Choose which schedules you want to export
  3. Select one or export several at once

Step 2: Choose Where to Save

  1. Click Browse to pick a folder
  2. The file name is created automatically from your model name
  3. Choose a location you'll remember

Step 3: Export

  1. Click Export
  2. Wait a moment while it creates the Excel file
  3. You'll see a confirmation when it's done

Step 4: Edit in Excel

Now you can: - Open the Excel file - Make your changes - Use Excel formulas and tools - Share with team members - Save when done

How to Import from Excel

Step 1: Prepare Your Excel File

Before importing: - Keep the column headers exactly as they were - Don't change the Element ID column (if there is one) - Make sure your data types match (numbers stay numbers, text stays text) - Save your Excel file

Step 2: Start Import

  1. Click "Schedule Excel" on the NeroScale ribbon
  2. Choose Import mode
  3. Browse to find your edited Excel file
  4. Click Open

Step 3: Review Changes

  1. The tool will show you what's about to change
  2. Check for any warnings or errors
  3. Make sure everything looks correct

Step 4: Import

  1. Click Import to apply changes
  2. Wait while it updates your Revit schedules
  3. Review the summary of what was updated

Step 5: Check Results

  • Look at your schedules in Revit
  • Verify changes were applied correctly
  • Check if any rows were skipped and why

Tips for Success

When Exporting

  • Name your Excel files with dates so you know which is newest
  • Keep exports organized in one folder
  • Make a note of what you're changing and why

When Editing in Excel

  • Don't change the column headers
  • Keep Element ID columns untouched
  • Use Excel's find and replace for bulk changes
  • Add Excel comments to note important changes
  • Save your work frequently

When Importing

  • Always check the preview before clicking Import
  • Test with a small schedule first
  • Save your Revit model before importing
  • Review any warnings carefully

Working with Teams

  • Make sure only one person edits at a time
  • Use Excel comments to explain changes
  • Keep a log of who changed what
  • Have someone else review before importing

Common Uses

Clean Up Schedule Data

Quickly fix many rows at once: - Use Excel's find/replace to fix naming - Remove duplicate or wrong entries - Make values consistent across rows

Create Reports

Make reports from your schedule data: - Add Excel charts and graphs - Combine with other project data - Format for presentations - Share with clients or consultants

Add Data in Bulk

Enter lots of data at once: - Type data in Excel (easier than Revit) - Copy and paste from other sources - Use Excel formulas to calculate values - Import everything back at once

Review and Approve

Let others check your data: - Send Excel file to team members without Revit - They can review and flag issues - Make corrections in Excel - Import the approved data

Common Questions

My schedule isn't showing up. Why? - Make sure the schedule has data in it - Check that the schedule isn't hidden - Verify you're looking at the right model

Import isn't working. What's wrong? - Make sure column headers match exactly - Check that you didn't change Element ID columns - Verify your data types are correct (numbers vs text)

Some of my changes didn't import. Why not? - Check the import report for skipped rows - Some columns might be read-only - Element IDs might not exist anymore - Review any error messages

Can I add new rows in Excel? - Usually you can only update existing data - To add new items, create them in Revit first - Then export, edit, and import

What if Excel is calculating a column? - Some calculated columns won't import - The tool will skip formula cells when importing - Copy formula results and paste as values if needed

Use With Other Tools

  • ParameterTransfer: Update parameters after editing in Excel
  • RevitExtractor: Get more detailed data exports
  • NeroSpec: Check if your schedule data meets requirements

Where to Find It

  • Open Revit
  • Look for the NeroScale ribbon at the top
  • Find "Schedule Excel" in the Data Exchange section
  • Click to start