Tag: list sheet names Google Sheets

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.

---