How to get sheet names using openpyxl in Python?

In this article, we will show you how to get all the sheet names found in an excel file using Python's openpyxl library.

Assume we have taken an excel file with the name sampleTutorialsPoint.xlsx containing multiple sheets with some random data. We will return all the sheet names found in a given excel file using the sheetnames attribute.

Sample Excel File Structure

Our example file sampleTutorialsPoint.xlsx contains three sheets:

firstSheet

SheetTwo

3rdsheet

Installation

First, install the openpyxl library using pip ?

pip install openpyxl

Algorithm

Following are the steps to get sheet names from an Excel file ?

• Import the openpyxl module
• Create a variable to store the path of the input Excel file
• Load the workbook using load_workbook() function
• Access sheet names using the sheetnames attribute
• Iterate through the list and print each sheet name

Example

The following program prints all the sheet names found in an input Excel file ?

# importing openpyxl module
import openpyxl

# input excel file path
inputExcelFile = "sampleTutorialsPoint.xlsx"

# creating or loading an excel workbook
newWorkbook = openpyxl.load_workbook(inputExcelFile)

# printing all the sheetnames in an excel file using sheetnames attribute
print('The Sheet names of the given excel file: ')

# Getting the sheetnames as a list using the sheetnames attribute
sheetNames = newWorkbook.sheetnames

# Traversing in the sheetNames list
for name in sheetNames:
    print(name)

Output

The Sheet names of the given excel file: 
firstSheet
SheetTwo
3rdsheet

Alternative Method ? Direct Access

You can also directly print the sheet names without storing them in a variable ?

import openpyxl

# Load the workbook
workbook = openpyxl.load_workbook("sampleTutorialsPoint.xlsx")

# Print sheet names directly
print("Sheet names:", workbook.sheetnames)

Sheet names: ['firstSheet', 'SheetTwo', '3rdsheet']

Conclusion

The sheetnames attribute of openpyxl's workbook object provides a simple way to get all sheet names from an Excel file. This is useful for dynamically processing multiple sheets or validating sheet structure before data operations.