Microsoft Office integration

Build templates in Word, Excel and PowerPoint. ActiveMerge fills them from your data and returns finished files.

What you can connect

WordContracts, letters and offers as .docx templates
ExcelSpreadsheet templates, and the data that fills any template
PowerPointDecks and certificates as .pptx templates
OneDriveSave generated documents to your folders automatically
SharePointSave generated documents to your SharePoint sites automatically

How each Office format works

Keep the tools your team already knows. ActiveMerge reads the file you built and fills in the placeholders.
FormatAs a templateAs a data sourceOutput
Word (.docx)Yes. Text, tables and repeating rows with {placeholders}.NoDOCX or PDF
Excel (.xlsx)Yes. Formulas in the template are left unchanged.Yes. One document per row, from Excel or CSV.XLSX or PDF
PowerPoint (.pptx)Yes. Slides with {placeholders} in text and shapes.NoPPTX or PDF

Write the template the way you already do

Type a placeholder in curly braces wherever data should appear. Column headings in your spreadsheet become the field names.
Service agreement for {client_name}
Effective date: {start_date}

Fee: {monthly_fee} per month
Billing contact: {billing_email}

Signed for {company_name} by {signer_name}

Use OneDrive and SharePoint as your file store

Connect OneDrive and SharePoint to ActiveMerge and every generated document is saved to your folders and sites automatically.

Your data

An Excel or CSV file, a form, Airtable, Notion or the API.

ActiveMerge

Fills your Word, Excel or PowerPoint template.

Saved to Microsoft 365

The finished file lands in your OneDrive folder or SharePoint site automatically.

OneDrive

Save each generated contract, report or deck to a OneDrive folder automatically, without downloading and uploading it yourself.

SharePoint

Save generated documents to a SharePoint site automatically, so finished files land where your team already works and shares them.

Connecting and automating

Connect OneDrive and SharePoint from your ActiveMerge integrations, then choose where generated files are saved. To start generation automatically from other tools, add Make, Zapier or the REST API.

What teams generate from Office templates

Contracts and letters

Fill a Word template from a spreadsheet or form, then send the result for e-signature. See also how to autofill Word documents.

Invoices and reports

Generate an Excel or PDF file for every customer or period from one template, with line items as repeating rows.

Decks and certificates

Create a PowerPoint file for each client, trainee or event from one master slide design.

Microsoft Office integration: common questions

ActiveMerge generates documents from Word (.docx), Excel (.xlsx) and PowerPoint (.pptx) templates. Output can be DOCX, XLSX, PPTX or PDF, depending on the template.
No. Templates are ordinary Office files with {placeholders}. You edit them in desktop or web versions of Office and upload them to ActiveMerge.
Yes. ActiveMerge has integrations for both OneDrive and SharePoint. Generated documents can be saved automatically to your OneDrive folders and SharePoint sites, so you do not need to download and re-upload them. To start generation automatically from other tools, you can add Make, Zapier or the REST API.
Yes. Upload an Excel or CSV file and ActiveMerge generates one document per row, matching column headings to the placeholders in your template.
ActiveMerge fills your own file, so fonts, headers, tables and page layout stay as you designed them. Excel formulas in the template are left unchanged.
Yes. You can send a generated document for e-signature from ActiveMerge, including in bulk.

Try it with your own Office template

Book a demo and we will set it up with your files, or start free and generate 25 documents yourself.
Scroll to Top