Bulk Sheet Tab Name Cleaner

You hit Save and Excel throws the error straight back at you: a tab name it won’t accept. Then another. Then another. Forty tabs, three of them called ‘Summary’, one with a slash in it, one so long it runs off the bar. Renaming them one by one would eat your whole afternoon. Paste the whole list into this free bulk sheet tab name cleaner instead — illegal characters come out or turn into underscores, long names get trimmed to 31 characters, and duplicates get numbered on their own.

Illegal characters (\ / ? * [ ] 🙂
Duplicate names after cleaning

What this bulk sheet tab name cleaner fixes

Excel and Google Sheets both reject the same six characters in tab names: backslash, forward slash, question mark, asterisk, square brackets, and colon. Paste in a list containing any of them and the cleaner strips each one out — or, if you’d rather, swaps each for an underscore so your words stay separated.

Tab names are also capped at 31 characters. Anything longer gets cut down to 31, with trailing spaces tidied so the result still reads naturally. Blank lines are skipped outright, and names wrapped in single quotes lose those quotes, since Excel won’t accept a name that starts or ends with one.

One name gets special treatment: “History”. Excel keeps it for its own use, so the cleaner leaves the name alone but flags it clearly instead of letting it slip through unnoticed. Every other name gets a per-row note saying exactly what changed — illegal characters removed, truncated to 31, duplicate renamed, blank skipped, or reserved name flagged.

How to clean tab names in bulk

Here’s the quickest way to run a full list through the bulk sheet tab name cleaner.

  1. Paste your tab names into the box, one per line. The list can be as long as you like.
  2. Choose how illegal characters are handled: remove them entirely, or replace each one with an underscore.
  3. Choose the duplicate rule: auto-number repeats Excel-style (“Name”, “Name (2)”, “Name (3)”), or flag them only and leave the names untouched.
  4. Results appear as you type. Each row shows the original name, the cleaned name, and exactly what changed.
  5. Copy the cleaned list with one click, or download it as a CSV with the full before-and-after table.

Fix illegal tab names and length limits in one paste

Paste the list of tab names and the cleaner fixes the characters Excel forbids and trims names that run past the length limit. Duplicates and blanks are flagged, and the summary counts show what changed.

Worked example: a pasted list of tab names, cleaned

Click Load example (or paste these seven lines): Q1 Sales Report, Q1/2025 Regional, Marketing?Plan, This Is A Really Long Sheet Name That Exceeds The Limit, Q1 Sales Report, History, ‘Quarterly Summary’.

Q1/2025 Regional becomes Q12025 Regional, tagged “illegal character(s) removed”. Flip the option to underscore mode and you get Q1_2025 Regional instead — the same choice turns Marketing?Plan into MarketingPlan.

This Is A Really Long Sheet Name That Exceeds The Limit runs to 55 characters, so it’s truncated to This Is A Really Long Sheet Nam — exactly 31 characters — and tagged “truncated to 31 characters”.

The second Q1 Sales Report collides with the first after cleaning, so it becomes Q1 Sales Report (2), tagged “duplicate renamed”. A third copy would become Q1 Sales Report (3), always staying inside the 31-character limit.

History stays exactly as it is but gets flagged as a reserved name, and ‘Quarterly Summary’ sheds its surrounding quotes to become Quarterly Summary. The summary bar reads: 6 names cleaned, 1 already fine, 1 duplicate renamed, 0 blanks skipped.

Duplicates, blanks, and the summary counts

Duplicate detection runs after cleaning, so two names that only differ by an illegal character still count as duplicates. Matching ignores case, because Excel treats “Total” and “TOTAL” as the same tab. In auto-number mode the first occurrence keeps its name and each repeat takes the next free number; in flag-only mode repeats are listed but left alone.

Blank lines never break the run. They’re listed as skipped and left out of the copied list and the CSV, and the summary counts them separately so you can spot accidental gaps in your paste.

More cleanup tools

Clean tab names are only one part of a tidy workbook. When several sheets share the same layout, Multi-Tab Combiner & Count-by-Week stacks them into one table and counts rows by week. If you need to tally answers from dropdown columns, Count Dropdown Values Across Sheets does the counting for you. And when a date column turns up in five different formats, Messy Date Cleaner turns it into one sortable format.

FAQs

Which characters does Excel forbid in tab names?

Six of them: the backslash (\), forward slash (/), question mark (?), asterisk (*), square brackets ([ ]), and colon (:). This bulk sheet tab name cleaner removes each one or swaps it for an underscore — your choice — and it also strips leading and trailing single quotes, which Excel rejects too.

What happens to duplicates?

After cleaning, names are compared without caring about case. In auto-number mode the first occurrence keeps its name and each duplicate becomes “Name (2)”, “Name (3)”, and so on, with the base shortened if needed to stay within 31 characters. In flag-only mode duplicates are marked in the “What changed” column but the names stay untouched.

Is anything uploaded?

No. Every calculation runs in JavaScript in your own browser, so your tab names never leave your computer — and there’s
nothing to sign up for.

What is the character limit for an Excel tab name?

Excel allows 31 characters in a tab name and forbids characters like colon, backslash, slash, question mark, asterisk and square brackets. The cleaner checks every name in your pasted list against those rules and fixes the ones that break them.

Can I clean tab names in bulk instead of renaming them one by one?

Yes. Paste the whole list and the cleaner returns fixed names for every tab at once, with duplicates and blanks flagged. The cleaned list pastes back into your sheet names without renaming each tab by hand.

Note: all processing happens in your browser – nothing you paste into this bulk sheet tab name cleaner is uploaded or stored anywhere.

Leave a Comment