How to Generate Word Documents Using Python: Step-by-Step Guide

from docxtpl import DocxTemplate
from openpyxl import load_workbook

# Load the workbook and sheet
wb = load_workbook("discounts.xlsx")
ws = wb.active

# Extract header names from the first row
headers = [cell.value for cell in ws[1]]

# Loop through each row of data (skip header)
for row in ws.iter_rows(min_row=2, values_only=True):
    # Build context dictionary: {"Name": ..., "Discount": ..., "Email": ...}
    context = dict(zip(headers, row))

    # Load the template
    doc = DocxTemplate("template.docx")

    # Render the template with context
    doc.render(context)

    # Save output using name
    output_filename = f"{context['Name']}_Discount.docx"
    doc.save(output_filename)

This will create individual Word documents for each row in your output location.

Here is an output of the first row on the Excel sheet:

New to Python? want to learn how styling, font, and tables work? See our beginner’s guide: How to Create Word Documents Using Python.

Best Practices for Document Generation With Python

Clean Template: Users should avoid making manual edits within the code. Instead, they should use a clean template and keep the formatting and styling contained within it.

Standardized Data: Your spreadsheet’s column headers and overall data formatting should be correct to ensure consistent formatting.

Error Handling: Always add basic checks for missing data or placeholders to prevent runtime issues.

Automate File Naming: Opting for unique identifiers like name or ID for naming output is better.