How to Get a List of Sheet Names in Google Sheets (Step-by-Step)

—

by

Himanshu
in

Google Sheets doesn’t offer a built-in formula to list sheet names directly like Excel VBA might. However, you can achieve it easily using Google Apps Script. Here’s how:

✅ Step 1: Open Google Apps Script

  1. Open your Google Sheets file.
  2. Click on Extensions > Apps Script.

✅ Step 2: Paste This Script

In the script editor, paste the following code:

javascriptCopyEditfunction listSheetNames() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheets = ss.getSheets();
  const sheetNames = sheets.map(sheet => [sheet.getName()]);
  
  const outputSheetName = "Sheet List";
  let outputSheet = ss.getSheetByName(outputSheetName);
  
  if (!outputSheet) {
    outputSheet = ss.insertSheet(outputSheetName);
  } else {
    outputSheet.clear();  // Clear old data
  }
  
  outputSheet.getRange(1, 1, sheetNames.length, 1).setValues(sheetNames);
}

✅ Step 3: Save and Run

  1. Click the 💾 Save icon and name your project.
  2. Click the ▶️ Run button.
  3. If prompted, authorize the script to access your spreadsheet.

✅ What Happens Next?

  • A new sheet called “Sheet List” will be created (or updated).
  • It will display the names of all sheets in your file—automatically.

🚀 Want to Master Google Sheets from A to Z?

🎯 Whether you’re just starting out or looking to boost your spreadsheet superpowers, our premium Google Sheets course is your gateway to mastery.

🔗 Enroll Now – Unlock the Power of Google Sheets

🔥 Offer: ₹1,299 ₹449 (Limited-Time Deal)

What You’ll Get:

  • 📹 29 videos totaling 3 hours 46 minutes
  • ✅ From beginner basics to advanced data analysis
  • 📈 Learn formulas, pivot tables, data validation, automation & more
  • 💼 Ideal for students, professionals, entrepreneurs

💡 With real-world examples and practical exercises, you’ll quickly become confident in handling data, automating tasks, and making smarter decisions.

Related Products