Using Excel .xlsx files with Python! OpenPyXl Tutorial

This tutorial shows you the basics of installing the OpenPyXl module, how to access data and information out of an Excel file, and then how to read the data, modify the data, and save changes!

This is a beginner introduction to using excel with python, if you want to see more advanced operations and automation, let me know in the comments!

Check out my personal channel for more fun science content!

Thanks for watching and good luck with your code!

[surprisemawela]

I struggled for more than a month with openpyxl but you helped me in less than 10 minutes! Thanks you so much

[alexmckinley]

Thanks a lot. I appreciate that you explain the things beginners wouldn't know intuitively.

[shankphadke]

Thank you that was a perfect tutorial - short precise and no nonsense - Awesome job

[rethanon]

Good to see your subscriber numbers going up, you were under 400 not so long ago, now almost at 1, 000! And thanks for taking up my suggestion of zooming in a bit 👍🏻

[AlejandroGarcia-xpuv]

Great video! Tahnks for this clear and brief basics of openpyxl

[saptanilchowdhury]

Really enjoyed this explanation. Thanks :)

[nanbolkeza]

Thanks for the great lecture. Pls I will like to see more data manipulations using excel and python.

[Hakeem]

Very helpful. Thank you and good luck. I subscribed

[kvelez]

from openpyxl import Workbook, load_workbook

book =
sheet = book.active #primary sheet in excel

sheet['A2'].value = "Food"

book.save("food_items.xlsx")

[pranavnyavanandi]

Watched it, good to know. Could you make a video covering properties and the descriptor protocol in python? I never got to understand them.

[KuriVideosOficial]

Hi, if I wanted to show (on a table format) the content of every row but just for specific columns, how could I do it?

[sidellelyne]

Hi, from your video, i can see you have a lot of experience on VBA. Will there be a way of optimizing VBA functions to go more faster? I've been implementing macros that take a LOT of time while running. What can I do to optimize the code and will computing this on Python could accelerate procedures?

[luisgabrielcastilloherrera]

Thank you so much for the amazing tutorial, is their a way to acces the information while the file is opened or being modified while the code is being executed

[nirmaljeyan]

Thanks but how do I import the excel file to pycharm? For example the menu file needs to be first added to pycharm right? I'm using a community version of pycharm I'm not able to find an option to add any excel files to pycharm

[SawekGraczyk]

Thanks a lot, awesome and very practical video
could recommend more videos (yours or others) how to automate work in Excel and other MS office apps
is Python effective to automate daily boring tasks on the computer? more recommends much appreciated
Cheers 🙂

[toddpoon]

why must the excel book be closed in order for the code to work? is it possible that it can be kept opened while running it?

[hussainkhan]

can you please tell me how to remove grid lines from xlsx in odoo or using python code

[farihahasan]

how did you save that excel sheet in pycharm?

[ahmedthebest]

Drum Machine with Python and Pygame – Full Project Course

I am a new subscriber I just subscribed here right now after seeing this video

[NDxmixx]

whenever I try to run the code it tells me that openpyxl isn't installed, I installed it using cmd but I'm running the code using IDLE, could that be why it isn't working?

edit: nevermind, I uninstalled/reinstalled and it started working