Others

How to Create Invoices from Microsoft Forms Responses

Maira Mehtab Sep 21, 2026 869 views

Question details

The user needs a way to automatically generate and export customer invoices based on data collected from a Microsoft Forms preorder form, without needing advanced tools like Access or Power BI.

Product: Microsoft Forms, Excel, Word
Device & OS: not provided
Scenario: Processing customer preorders and details collected through a Microsoft Form for billing and delivery.
Observed behavior: Microsoft Forms collects the preorder data successfully but lacks a built-in feature to automatically format and generate individual document invoices for the customer submissions.

Before you start

Ensure you have prepared a standard invoice document template in Word with clear placeholders for customer details, and that your Microsoft Forms responses have been collected properly.

Solution 1Recommended

Export Responses to Excel and Generate Invoices via Word Mail Merge

Since Microsoft Forms cannot natively generate invoices, exporting the response data to Excel and using Word's Mail Merge feature with an invoice template is the most efficient and straightforward workaround.

This method links your exported Excel spreadsheet data directly to a Word invoice template. It allows you to quickly generate multiple customized invoices at once, saving time without requiring complex databases like Access or Power BI dashboards.

Export Forms Data to Excel

Open your Microsoft Form, navigate to the 'Responses' tab, and click on 'Open in Excel' to download your collected submission data as a spreadsheet file.

Prepare the Word Invoice Template

Open Microsoft Word and open an existing invoice template or create a new one. Leave blank spaces or placeholder text where the customer's specific details and order information will be inserted.

Start the Mail Merge

In the Word document, go to the 'Mailings' tab, click 'Start Mail Merge', and select 'Letters' or 'Normal Word Document' depending on your preference.

Select the Excel Data Source

Click on 'Select Recipients', choose 'Use an Existing List', and browse your computer to select the Excel file you downloaded from Microsoft Forms.

Insert Merge Fields

Highlight your placeholder text in the invoice template, click 'Insert Merge Field' on the Mailings tab, and select the corresponding column headers from your form (e.g., Customer Name, Phone, Order Details).

Finish and Merge

Click 'Finish & Merge' and select 'Edit Individual Documents' to create a new file containing individual invoices for each form submission. You can then print them or save them as PDFs to send to customers.

Template Preparation: Ensure your Excel file has clear column headers before running the merge. This makes it much easier to match your data with the right fields on the invoice template.

Powerful Document Creation

Create Bulk Invoices Easily with WPS Office

Use WPS Writer and WPS Spreadsheet to seamlessly execute mail merges. You can import your Microsoft Forms data directly into WPS Spreadsheet, then use WPS Writer's Mail Merge tool to quickly produce and export custom invoices.

1. Open Data in WPS Spreadsheet: Download your Microsoft Forms responses as an Excel file and open it using WPS Spreadsheet to verify the columns.
2. Prepare an Invoice in WPS Writer: Open WPS Writer, select an invoice template from the built-in library, or load your custom invoice document layout.
3. Connect the Data Source: Navigate to the References (or Mailings) tab, click 'Open Data Source', and select your downloaded forms spreadsheet.
4. Insert Fields and Merge: Insert the relevant merge fields into your invoice document, then click 'Merge to Document' to generate and save the final invoices.

Fully compatible with Microsoft Excel (.xlsx) and Word (.docx) file formats.Built-in Mail Merge feature to generate hundreds of invoices in seconds.Lightweight alternative to heavy desktop office suites with high performance.Extensive library of free, professional invoice templates built right into the software.

microsoft office alternative - wps office

Frequently Asked Questions

Can Microsoft Forms send an automated email with a PDF invoice attached?

Microsoft Forms alone cannot automatically generate and email PDFs. However, you can use Microsoft Power Automate to trigger an email workflow when a form is submitted. Generating a PDF invoice directly through Power Automate typically requires premium connectors or integrating third-party document generation tools.

Does the Mail Merge automatically update when new form responses arrive?

No, a standard Mail Merge uses a static version of the Excel file. When new responses arrive in Microsoft Forms, you must export the updated Excel file and run the merge process again to generate the new invoices.

How do I handle multiple order items in a single form submission?

If all ordered items are captured in separate columns on a single row in your Excel export, you can map each column to a specific line in your invoice template. If the form allows dynamic numbers of items, formatting the invoice properly may require an advanced Excel macro to organize the rows before performing the merge.

Office Quick Solutions