Getting Started
Sheet-to-Doc is a powerful tool that automatically writes Excel, CSV, JSON, JSONL data into docx format Word templates, converting them into Word documents in batches.
Building on the basis of mail merge, this tool has developed more features, such as custom file names, custom file paths, embedding images, and so on.
Attention
This getting started guide (this page) will walk you through the basic usage steps to help you quickly get started with Sheet-to-Doc. Once you’re familiar with it, you are advised to read the detailed Usage Instructions for more features.
Use Cases
Example 1: Generate Sales Reports
Prepare Excel Spreadsheet: Create a spreadsheet with the following columns: Product Name, Quantity, Price, Total.
Select Template: Choose the “Sales Report” template.
Generate: Click the “Generate” button to create sales reports.
Result: A professional sales report containing a table with products, quantities, prices, and totals.
Example 2: Generate Invoices
Prepare Excel Spreadsheet: Create a spreadsheet with the following columns: Invoice Number, Customer Name, Date, Item, Quantity, Price, Total.
Select Template: Choose the “Invoice” template.
Generate: Click the “Generate” button to create invoices for each row.
Result: Multiple invoices, each with its own invoice number, customer name, date, and item details.
Example 3: Generate Letters
Prepare Excel Spreadsheet: Create a spreadsheet with the following columns: Recipient Name, Address, Date, Subject, Body.
Select Template: Choose the “Business Letter” template.
Generate: Click the “Generate” button to create personalized letters.
Result: Personalized business letters with recipient names, addresses, and customized content.
Basic Usage Steps
Prepare Your Excel Data
First, you need to prepare an Excel spreadsheet containing the data to be converted into documents. The spreadsheet should have a clear structure:
The first row is the header row,
Subsequent rows are data rows.
Example:
Download sample Excel file: sample1-sheet.xlsx
Name |
Date_of_Birth |
Gender |
|---|---|---|
Zhang San |
1990-05-12 |
M |
Prepare Your Word (.docx) Template
Next, you need to prepare a Word document template for generating the final documents. The template should contain placeholders from the Excel spreadsheet data.
Example:
Create a new Word document.
Insert placeholders using the
{placeholder}syntax. For example,{Name}will be replaced with data from the “Name” column, and{Date_of_Birth}will be replaced with data from the “Date of Birth” column.Add any other text or formatting as needed.
Save the template as a DOCX file.
Example 2:
Download sample Word template file: sample1-doc.docx
Subject: Visit Notification: A Colleague Will Visit Tomorrow
Dear Davidson:
We hereby inform you that one of our colleagues will visit your office tomorrow. The details as shown on their employee ID are as follows:
Name: {Name}
Date of Birth: {Date_of_Birth}
Gender: {Gender}
Please assist with entry procedures and coordination upon their arrival. If you need any further information, please feel free to contact me.
Thank you for your support.
Sincerely,
Best regards,
WTSolutions
Open Sheet-to-Doc
You can access Sheet-to-Doc in the following ways:
Use a modern browser (such as Chrome, Firefox, Edge, Safari) to visit https://s.wtsolutions.cn/sheet-to-doc.html.
Download the software as a desktop application for offline use. Download
Use the addin version in Excel or WPS. Download
Fill in Data
Copy data directly from your Excel spreadsheet.
Paste it into the “Data” field in the Sheet-to-Doc web application.
You can view a data preview in the web application.
Upload Template
Upload the Word template file you prepared.
Generate Documents
When selecting the generation mode, choose mode 1: Generate separate Word documents for each row of data.
Click the “Generate” button. The tool will populate the template with data from the Excel spreadsheet and generate professional documents based on the template you selected.
Example:
Download sample generated document: sample1-report.docx
Subject: Visit Notification: A Colleague Will Visit Tomorrow
Dear Davidson:
We hereby inform you that one of our colleagues will visit your office tomorrow. The details as shown on their employee ID are as follows:
Name: Zhang San
Date of Birth: 1990/5/12
Gender: M
Please assist with entry procedures and coordination upon their arrival. If you need any further information, please feel free to contact me.
Thank you for your support.
Sincerely,
Best regards,
WTSolutions
Note
The above is a simple quick start tutorial, and now you can start using Sheet-to-Doc to automatically generate professional documents. If you want to learn more features, please refer to Usage Tutorial.