Usage Examples

中文

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, QR codes, table, and so on.

Note

This page is quite long, we recommend that you browse this page with the Table of Contents:

• Left hand side: Table of Contents for whole documentation.

• Right hand side: Table of Contents for this page.

To facilitate everyone’s use, we provide some usage examples. We will provide different examples based on different usage scenarios.

When you encounter questions while preparing your own document templates, you can refer to the examples on this page to understand how to use Sheet-to-Doc.

Simple Document Generation (involving Data Placeholders and Loop Placeholder 1)

• Invitation 1 (generated via Generation Mode 1) (Generate several independent invitations, each invitation is a separate Word document)

  • Data source: sample-invitation-12.xlsx

  • Document template: sample-invitation-1.docx

Video Guide for Invitation 1 Example:

• Invitation 2 (generated via Generation Mode 2) (Generate a single Word document containing all invitations, one invitation per page)

  • Data source: sample-invitation-12.xlsx

  • Document template: sample-invitation-2.docx

Video Guide for Invitation 2 Example:

Document Generation with Images (involving Data Placeholders, Image Placeholders and Loop Placeholder 1)

• Award Notice 1 (generated via Generation Mode 1) (Generate several independent award notices, each award notice is a separate Word document)

  • Data source: sample-award-12.xlsx

  • Document template: sample-award-1.docx

  • Images: watch.png

  • Images: batterybank.png

• Award Notice 2 (generated via Generation Mode 2) (Generate a single Word document containing all award notices, one award notice per page)

  • Data source: sample-award-12.xlsx

  • Document template: sample-award-2.docx

  • Images: watch.png

  • Images: batterybank.png

Document Generation with Filters (involving Data Placeholders and Filters)

• Invoice 1 (generated via Generation Mode 1) (Generate several independent invoices, each invoice is a separate Word document)

  • Data source: sample-invoice-1.xlsx

  • Document template: sample-invoice-1.docx

Document Generation with QR Codes (involving Data Placeholders and QRCode Placeholders)

• Device QR Code (generated via Generation Mode 2) (Generate several independent device QR codes)

  • Data source: sample-qrcode-1.xlsx

  • Document template: sample-qrcode-1.docx

Simple Table Generation (involving Loop Placeholders and Table Placeholder 1)

• Simple Table 1 (generated via Generation Mode 2)

  • Data source: sample-table-1.xlsx

  • Document template: sample-table-1.docx

Complex Table Generation (involving Loop Placeholders and Table Placeholder 3)

• Complex Table 3 (generated via Generation Mode 2)

  • Data source: sample-table-3.json

  • Document template: sample-table-3.docx

Password Protection for Documents

• Works only in Offline Desktop Version

• Password Protection (generated via Generation Mode 1)

  • Data source: sample-password-1.xlsx

  • Document template: sample-password-1.docx

Note: We will gradually add other examples in the future, so stay tuned.