Generate MS Word documents in bulk based on an Excel list using Python

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
In this video, I am going to show you how to save a lot of time by generating MS Word documents in bulk based on an Excel list using Python. No more copy-pasting, making mistakes and wasting time!

🌍 𝗟𝗜𝗡𝗞𝗦:

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:

[CodingIsFun]

*I will be here in the comments section. If you have any questions, please let me know.*
Quick note: At 06:42 min, the Word document's date is different compared to the Excel screenshot. Reason: I have edited the video a couple of days after the initial recording. When I took the screenshot from the Excel file, I did not adjust the 'today' formula. This is causing the 'difference'.

[ermalgashimramori]

As always, you deliver. It's going to save a week for the accountants at my office, and error rate is going to go down drastically, thank you. :)

[viniciusmateus]

You are the best, man. With your help I managed to solve a big problem in my company even knowing the basics of Python.

[lindsayreads]

This was so much easier than every other "tutorial" I found out there. Thank you!

[bc]

How about combining multiple text files together into one, like a table of contents and heading sections all saved as separate files? Part of the goal is to avoid tracking down all the places a boilerplate has been used, versus changing a the boilerplate in a central file and having that update in every file that includes it. The other part is to have more granular version control and to make it easier to handle a document - to just hold a chapter at a time, rather than a whole book.
Cheers, thanks for your thoughts and your videos! Your channel is the most important and valuable to my work. I don't have users looking for me to code apps for them; I just have a ton of "office suite" tasks to achieve, with not enough time, and I hate the idea of wasted time and effort. Thanks again.

[UmrbekBoymetov]

Hello there. I am from Uzbekistan. Thank you very much. Very helpful video. You saved me a lot of time. Good luck

[HabibKhan-kjum]

This video is awesome. Simple, straight forward and No BS'ing. Thanks a lot and keep up the good work :)

[cinberg]

Hey, thanks for the great video it helped me alot! I have a question regarding strfime(). I want to have alterneting time formats for the same placeholder and want ask if thats possible. So lets say for the first row its (%y %m %d) then for the second row (%d %m %y) and then third row the same as first… would this be possible? Thanks for any help!

[bc]

Awesome! Love your channel and work - thank you!

[balkanoid]

Beautiful. Just beautiful. Python rules for this kind of stuff!

[sergejd]

Awesome tutorial!
How to make a little tweak to final output, by changing date format from YYYY-MM-DD to DD.MM.YYYY.?

[KhalilYasser]

Great tutorial. Thank you very much.
As for the dates, I noticed the output in the word document is 11-02-2022 and this is different from the dates in the excel file. How can I fix that?

[sapphirewolf]

Thanks and awesome 🙂What are you doing with base_dir = Path(__file__) command? I get NameError: name '__file__' is not defined...

[BriNgHouZ]

Great video, thanks! Can I make the same procedure for excel files? I need to populate excel template not a word one

[ugurcan]

Very useful video. Thank you. How can we transfer data from multiple Excel sheets to a Word file? Do you have a video? I would be very happy if you could help.

[ThePianist]

What interests me most at the moment is 
1) creating the rubric of a contract for different parties who work together (party, address, executing department, PI, address of the department. The number of parties should be selectable. That means for example: 10 parties in the rubric. I need a GUI where I type in how many parties and give each party various attributes, like the one listed above.
2) creating 1 single page for the signature of 1 party - which consist of the PI and the head of the legal office / chief of (...). That means for example: 10 parties listed above as a head line, 10 signature pages for 20 people.
This process is really exhausting and should not be done manually. Maybe this is easier said than done.
Thanks in advance!

[tim]

Woow! this is amasing
Thanks you for sharing.💯

[iliangeorgiev]

This is amazing. Thank you so much. YOU are the

[kapibara]

Very interesting material, thank you ❤

[Finchman]

Very interesting. I think I should start learning Python.