Python Read Excel File using Pandas Example

Hello Dev,

In this tutorial, you will learn python read excel file using pandas. We will use python read excel file xlsx using pandas. you will learn how to read data from excel file in python using pandas. This article goes in detailed on how to extract data from excel using python pandas.

In this example, we will read excel file using python pandas library. we will use read_excel() function to read excel file date using python pandas. so let's see a simple example.

You can use these examples with python3 (Python 3) version.

I simply created data.xlsx file with content as like below, we will use same file for both example:

demo.xlsx

Example 1: using pandas

main.py

# import pandas library as pd
import pandas as pd
   
# get by default 1st sheet of demo excel file
data = pd.read_excel('demo.xlsx')
   
print(data)

Output:

   ID             Name              Email
0   1    Hardik Savani   hardik@gmail.com
1   2  Vimal Kashiyani    vimal@gmail.com
2   3   Harshad Pathak  harshad@gmail.com

I hope it can help you...