Python — How to Read Multiple Excel Sheets or Tabs

As a data engineer or python developer and you have to read the data from an excel data file having multiple sheets or tabs and save the data into other data sources like SQL Server database or SQLite then it can be easily possible in Python.

There is no limitation of rows in csv or text file format but in case of excel file, there are only 1000000 rows allowed in per excel sheet or tab.

As we know, Python is one of the fastest growing programming languages. Whether it’s data manipulation with Pandas, creating…

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Ryan Arjun

BI Specialist || Azure || AWS || GCP — SQL|Python|PySpark — Talend, Alteryx, SSIS — PowerBI, Tableau, SSRS