Automate Filling Templates With Python

Do important work instead of repetitive tasks

Photo by Chris Ried on Unsplash

Introduction

In this article you will learn:

• How to fill in a predefined Word template based on Excel input.
• How to automate this in order to create multiple templates at the same time.
• How you can adapt the template to your specific use case.

Python process

This is the first part of the three-part Python series “Build Your Own Application in Python”:

1. Automate Filling in Word Templates Using Python
2. Create a Graphical User Interface (GUI) using the Tkinter package
3. Transform in an .EXE application using the Pyinstaller package

Part One of The Article Series

Load The Packages

• Openpyxl: Python package for working with excel files
• Docx: Python package for working with Word documents

Get the Data

Save these files to your local folder:

1. Excel template: download
2. Word template: download

Create The Word Template

The word template defines the input parameters in the following format:

{{PARAMETER}}

It is crucial there are no spaces in your parameters:

• {{Company_Name}} is OK while {{Company Name}} will give errors