Microsoft Office integration
Build templates in Word, Excel and PowerPoint. ActiveMerge fills them from your data and returns finished files.
What you can connect
| Word | Contracts, letters and offers as .docx templates |
|---|---|
| Excel | Spreadsheet templates, and the data that fills any template |
| PowerPoint | Decks and certificates as .pptx templates |
| OneDrive | Save generated documents to your folders automatically |
| SharePoint | Save 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.
| Format | As a template | As a data source | Output |
|---|---|---|---|
| Word (.docx) | Yes. Text, tables and repeating rows with {placeholders}. | No | DOCX 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. | No | PPTX 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.
- Open a Word, Excel or PowerPoint file you already use.
- Replace the changing text with placeholders such as {client_name}.
- Upload it, match fields to your data, and generate.
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.
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.