Automate Excel and Word with Python - Excel Sheet to Word Docs [openpyxl, docxtpl]

Use an Excel sheet to generate many Word docs. Generate certificates for students based on their data in Excel.

In this video, you will:
- Build a Python automation project
- Install openpyxl
- Install docxtpl
- Load data from Excel with openpyxl
- Use doxtpl to automate Word documents with Python
- Generate Word documents with Python

Timestamps:
00:00 Introduction and demo
01:27 Installing openpyxl and docxtpl
03:26 Reading rows from Excel with openpyxl
05:48 Generate the certificate Word docs with docxtpl

*************
**Tags**
Python tutorial
openpyxl
openpyxl tutorial
learn openpyx
Python automation project
docxtpl
Python Resume Project
Python Automation GUI Project

[bigrevkev]

Thank you so much! I'm a college registrar and the company that stores and prints our diplomas was just bought out by a bigger company which has jacked up the annual subscription. So I've created our own. I use a database connection instead of a excel file but it works the same!

[ontenzen]

Cool tutorial. I haven't tried it myself, but I will definetly come back to this, when I have a similar use case. Keep up the good work.

[lega]

Спасибо!!! Ты лучшая! Если б мог, то расцеловал!!! Все объяснила очень просто и наглядно!!! ❤❤❤

[lajonas]

Hi Hala, i apricate your effort, .. thank you for the video

[asianpsalmshymns]

Outstanding Explanation Respectable Madam❤

[sayurijurema]

I am beginner in python, and this video is really easy to understand. But i would like to generate all the certificates as 1 file.docx, how can i change it?

[christianmller]

Great video! Is there a way to do the same thing but with tables from excel?

[tarasgolovatyj]

holllyy. I'm so exited to find this way of doing stuff. Thanks so mush. As all that "Microsoft out of a box office ways" makes me feel too stupid

[Abcs-oj]

How one can extract data like (mp2 = -3.2424) from a large txt file using python programme.???
Please instruct me

[sanathkumarr]

Its not Looping over generating documents with different data in my case....
Need help

[alielsheikh]

Hello, how can I make my python PyQT5 app with a button to check for updates and deploy my updates remotely online ?

[BriNgHouZ]

Thanks for the video. How can I make same but for an excel template? Didnt manage to reach the same result with xlwings

[nict]

Hey Hala - this was awesome. I am on to the next step of difficulty here - i have multiple rows of data that i need to combine in a single output. The rows will have a common identifier in tuple[0]. 90% of the data in both rows match, but i need a way to pull the unique values from the 10% of columns to the single docx output. Any advice?

[RadovanPalik]

You should switch from Python to R and C#. You'll find the world will be nicer and the code faster.