Exporting Multiple Sheets As Csv Using Python
Last Updated :
27 Mar, 2024
In data processing and analysis, spreadsheets are a common format for storing and manipulating data. However, when working with large datasets or conducting complex analyses, it's often necessary to export data from multiple sheets into a more versatile format. CSV (Comma-Separated Values) files are a popular choice due to their simplicity. In this article, we'll explore two different methods for exporting multiple sheets as CSV using Python, along with code examples.
Exporting Multiple Sheets As Csv Using Python
Below are examples of exporting multiple sheets as CSV using Python. Before exporting multiple sheets as CSV files, we need to install the Pandas and Openpyxl libraries, which help us convert sheets into CSV. To install these libraries, use the following command:
pip install pandas
pip install openpyxl
File Structure:

file.xlsx

Example 1: Exporting Multiple Sheets As Csv Using Pandas
In this example, below code reads an Excel file into a Pandas ExcelFile object, iterates through each sheet, converts each sheet into a DataFrame, and exports it to a CSV file with the same name as the original sheet.
Python3
import pandas as pd
# Read Excel file into a Pandas ExcelFile object
xls = pd.ExcelFile('file.xlsx')
# Iterate through each sheet in the Excel file
for sheet_name in xls.sheet_names:
# Read the sheet into a DataFrame
df = pd.read_excel(xls, sheet_name)
# Export the DataFrame to a CSV file
df.to_csv(f'{sheet_name}.csv', index=False)
Output
sheet1.csv
ID ,Name
1A,Apple
1B,Ball
1C,Cat
1D,Dog
After file Structure

Example 2: Exporting Multiple Sheets As Csv Using openpyxl and csv
In this example, below Python code uses the 'openpyxl' and 'csv' modules to convert each sheet from an Excel workbook ('file.xlsx') into separate CSV files. It iterates through each sheet in the workbook, opens it, and writes its contents row by row into a newly created CSV file with the same name as the original sheet. This process allows for efficient extraction of data from multiple sheets in Excel into CSV format using Python.
Python3
import openpyxl
import csv
# Open the Excel workbook
workbook = openpyxl.load_workbook('file.xlsx')
# Iterate through each sheet in the workbook
for sheet_name in workbook.sheetnames:
# Open the sheet
sheet = workbook[sheet_name]
# Create a CSV file
with open(f'{sheet_name}.csv', 'w', newline='') as csvfile:
writer = csv.writer(csvfile)
# Iterate through rows in the sheet and write to CSV
for row in sheet.iter_rows(values_only=True):
writer.writerow(row)
Output
sheet1.csv
ID ,Name
1A,Apple
1B,Ball
1C,Cat
1D,Dog
After file Structure

Conclusion
In conclusion , Exporting multiple sheets as CSV using Python can greatly streamline data processing tasks, allowing for easy manipulation and analysis in various software environments. In this article, we explored two methods for achieving this: using the Pandas library and using openpyxl along with the csv module. Whether you prefer the simplicity of Pandas or the flexibility of openpyxl.
Similar Reads
Python Tutorial - Learn Python Programming Language Python is one of the most popular programming languages. Itâs simple to use, packed with features and supported by a wide range of libraries and frameworks. Its clean syntax makes it beginner-friendly. It'sA high-level language, used in web development, data science, automation, AI and more.Known fo
10 min read
Python Interview Questions and Answers Python is the most used language in top companies such as Intel, IBM, NASA, Pixar, Netflix, Facebook, JP Morgan Chase, Spotify and many more because of its simplicity and powerful libraries. To crack their Online Assessment and Interview Rounds as a Python developer, we need to master important Pyth
15+ min read
Non-linear Components In electrical circuits, Non-linear Components are electronic devices that need an external power source to operate actively. Non-Linear Components are those that are changed with respect to the voltage and current. Elements that do not follow ohm's law are called Non-linear Components. Non-linear Co
11 min read
Python OOPs Concepts Object Oriented Programming is a fundamental concept in Python, empowering developers to build modular, maintainable, and scalable applications. By understanding the core OOP principles (classes, objects, inheritance, encapsulation, polymorphism, and abstraction), programmers can leverage the full p
11 min read
Python Projects - Beginner to Advanced Python is one of the most popular programming languages due to its simplicity, versatility, and supportive community. Whether youâre a beginner eager to learn the basics or an experienced programmer looking to challenge your skills, there are countless Python projects to help you grow.Hereâs a list
10 min read
Python Exercise with Practice Questions and Solutions Python Exercise for Beginner: Practice makes perfect in everything, and this is especially true when learning Python. If you're a beginner, regularly practicing Python exercises will build your confidence and sharpen your skills. To help you improve, try these Python exercises with solutions to test
9 min read
Python Programs Practice with Python program examples is always a good choice to scale up your logical understanding and programming skills and this article will provide you with the best sets of Python code examples.The below Python section contains a wide collection of Python programming examples. These Python co
11 min read
Spring Boot Tutorial Spring Boot is a Java framework that makes it easier to create and run Java applications. It simplifies the configuration and setup process, allowing developers to focus more on writing code for their applications. This Spring Boot Tutorial is a comprehensive guide that covers both basic and advance
10 min read
Python Introduction Python was created by Guido van Rossum in 1991 and further developed by the Python Software Foundation. It was designed with focus on code readability and its syntax allows us to express concepts in fewer lines of code.Key Features of PythonPythonâs simple and readable syntax makes it beginner-frien
3 min read
Python Data Types Python Data types are the classification or categorization of data items. It represents the kind of value that tells what operations can be performed on a particular data. Since everything is an object in Python programming, Python data types are classes and variables are instances (objects) of thes
9 min read