Master pandas.read_excel: Complete Guide to Importing Excel Data in Python

01 Syntax

The pandas.read_excel function reads Excel files and offers a rich set of parameters; its full signature is shown below.

pd.read_excel(io, sheet_name=0, header=0, names=None, index_col=None,
    usecols=None, squeeze=False, dtype=None, engine=None,
    converters=None, true_values=None, false_values=None,
    skiprows=None, nrows=None, na_values=None,
    keep_default_na=True, verbose=False, parse_dates=False,
    date_parser=None, thousands=None, comment=None,
    skipfooter=0, convert_float=True, mangle_dupe_cols=True, **kwds)

02 File Source

The first argument io can be a local filename, an absolute path, or a URL. Examples:

# string, bytes, Excel file, xlrd.Book, path object, or file‑like object
pd.read_excel('data/data.xlsx')          # relative path
pd.read_excel('data.xls')                # same directory
pd.read_excel('/user/gairuo/data/data.xlsx')  # absolute path
pd.read_excel('https://www.gairuo.com/file/data/dataset/team.xlsx')  # URL

Note that path syntax differs between macOS and Windows.

03 Sheets

The sheet_name parameter selects which sheet(s) to read; if omitted, the first sheet is used.

# string, integer, list, or None (default 0)
pd.read_excel('tmp.xlsx', sheet_name=1)               # second sheet
pd.read_excel('tmp.xlsx', sheet_name='Summary')       # by name
# read multiple sheets, returns a dict of DataFrames
dfs = pd.read_excel('tmp.xlsx', sheet_name=[0, 1, "Sheet5"])
# read all sheets
dfs = pd.read_excel('tmp.xlsx', sheet_name=None)
dfs['Sheet5']  # access by sheet name

04 Header

The header argument defines which row(s) serve as column names; default is the first row.

# integer, list of integers, default 0
pd.read_excel('tmp.xlsx', header=None)   # no header
pd.read_excel('tmp.xlsx', header=2)      # third row as header
pd.read_excel('tmp.xlsx', header=[0,1])  # multi‑level header

05 Column Names

Use the names parameter to specify column names explicitly, overriding the file’s header.

# sequence, default None
pd.read_excel('tmp.xlsx', names=['Name','Age','Score'])
pd.read_excel('tmp.xlsx', names=c_list)               # from a list variable
# when there is no header, set both header and names to None
pd.read_excel('tmp.xlsx', header=None, names=None)

06 Other Parameters

All remaining arguments behave like those of pandas.read_csv. If you need features exclusive to CSV, consider converting the Excel file to CSV for faster loading and broader compatibility.

07 Summary

This guide covered the unique parameters of pandas.read_excel compared with read_csv, emphasizing the importance of mastering Excel data import for everyday data‑analysis tasks. For small Excel files, pd.read_clipboard() can also be a quick alternative.