Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Python Excel – Read Write Copy Search Excel Files – OpenPyXL

Python for Excel Automation with Openpyxl - Manipulate & Manage Excel Spreadsheets with Python - Save Time and Effort!
(308 reviews)
29,353 students
Created by


CourseMarks Score®







Platform: Udemy
Video: 2h 18m
Language: English
Next start: On Demand

Table of contents


Learn Python Excel is openpyxl tutorial for beginners. It teaches you how to load workbook into memory and read and write Excel file. How to copy data from cell, row or column to a new sheet or new Excel file. You will also learn how to copy, cut and paste Excel files and how to delete them. How to create a folder, copy a folder or delete it. 

You will also learn how to search for specific flagged data in Excel file and take some action based on that info.
This course provides easy, to the point techniques to deal with MS Excel files in Python. Basic at beginners level simple enough that anyone can grasp the idea, powerful enough that you can use in your daily office tasks.

You will learn

✓ Read write and Manipulate Excel files in Python Efficiently
✓ How to Load a Workbook (Excel File) in Openpyxl
✓ Add or Delete a Sheet in Excel File
✓ Change Sheet Name
✓ Read and Write Data to Cell
✓ Copy Row Column Grid or Sheet
✓ Save and Save As Excel File
✓ Copy Cut Move Delete Excel File
✓ Search Excel File
✓ Create Folder for Excel Files


• Basic info about Python Programming – Print statement, lists and For loop

This course is for

• Anyone who wants to work with Excel files in Python Openpyxl
• Want to be more Efficient – Let Python do the Tasks for you
Data Scientist, IT Consultant, University Teacher
Mudassar Naseem is an IT Consultant and University Teacher. He has background of Programming and data analysis. He feels Programming is an Art, more diverse and vivid than abstract art.
He has experience of more than 15 years in IT industry and he has designed and developed software for different purposes. Data analysis(Machine Learning, Deep Learning) is his area of interest along with Programming. He has experience of programming in Python, C, C++, SQL, R, ABAP,  Java and PHP. 
He has successfully imparted knowledge to hundreds and thousands of students at university level. This platform provides a more wider arena to spread knowledge and help everyone on this planet to learn the skill one would wish for. 
Don’t hesitate and jump in to start learning. Programming is a skill which everyone on this planet should know to be a better person and more useful. It teaches us Logic and Rationale.
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 2h 18m
Language: English
Next start: On Demand

Students are also interested in