sheet-to-doc

Sheet to Doc Image Placeholder Guide Make Your Document Generation More Efficient

What is Sheet to Doc?

Sheet to Doc is a powerful document automation tool that can convert Excel spreadsheets, CSV, JSON and other data formats into professional Word documents. It is based on mail merge technology but provides more rich features, such as loop placeholders, conditional placeholders, image placeholders, etc., allowing you to easily generate batch personalized documents.

Application Scenarios

Sheet to Doc is suitable for various scenarios that require batch document generation:

  • Corporate Office: Batch generation of contracts, quotations, employee certificates, invitation letters, etc.
  • Education Industry: Batch generation of report cards, admission notices, certificates of merit, etc.
  • E-commerce Field: Batch generation of product manuals, order confirmation letters, etc.
  • Event Planning: Batch generation of event tickets, participant badges, thank-you letters, etc.
  • Any scenario that requires repeated generation of similar documents

How to Get Sheet to Doc?

You can access and use Sheet to Doc in the following ways:

  1. Online Use: Access https://s.wtsolutions.cn/sheet-to-doc.html using a modern browser, supporting Chinese and English switching
  2. Desktop Application: Download the desktop application for offline use

Using Image Placeholders

Sheet to Doc has supported image placeholder functionality since version 2.2.0, allowing you to automatically insert images when generating documents, greatly enhancing the richness and professionalism of the documents.

Basic Syntax of Image Placeholders

The format of the image placeholder is: {@image_field_name | image_type:width:height}

  • The @ symbol is the identifier of the image placeholder
  • image_field_name is the column header in the Excel table that contains the image file name
  • image_type can be _inline_image (inline image) or _block_image (block image)
  • width and height are optional parameters, in centimeters, the default size is 5cm x 5cm

Usage Example

1. Prepare Data

Suppose you have an Excel table of product lists, containing product names and corresponding image file names:

Product Name Image Name
Smart Watch watch.png
Power Bank batterybank.png
Wireless Earphones earphones.png

2. Upload Images

Prepare the corresponding image files (watch.png, batterybank.png, earphones.png) and upload these images when using Sheet to Doc.

3. Design Word Template

In the Word template, use image placeholders to insert images:

1
2
3
4
5
6
7
8
9
# Product Catalog

{#data}

## {Product Name}

{@Image Name | _block_image:8:6}

{/data}

4. Generate Documents

Use the Sheet to Doc tool to generate documents. The system will automatically insert the corresponding data and images into the template, generating complete documents containing images.

Notes on Image Placeholders

  1. Image placeholders must start with @, such as {@Image Name}
  2. Must include image type (| _inline_image or | _block_image), where | and _ must use English characters
  3. Image placeholders must occupy a separate line and cannot be on the same line as other text
  4. The image file name must be consistent with the uploaded image file name (case-sensitive, including suffix)
  5. If an image is listed in Excel but the corresponding image file is not uploaded, “No image uploaded, please upload an image” will be displayed in the generated document

Other Powerful Features

In addition to image placeholders, Sheet to Doc also provides a variety of practical features:

1. Data Placeholders

Basic text placeholders, such as {Name}, {Date}, etc., used to insert simple data.

2. Loop Placeholders

Using {#data}...{/data} syntax, you can loop through multiple rows of data in the table to generate repeated content.

3. Conditional Placeholders

Support conditional judgment, such as:

  • {#Won Prize}...{/Won Prize}: Display content when the “Won Prize” field is true
  • {#Prize == "Watch"}...{/}: Display content when the “Prize” field equals “Watch”

4. Data Filters

Provide multiple data formatting filters, such as:

  • {Price | currency:"$":2}: Format numbers as currency format
  • {Date | date:"yyyy-MM-dd"}: Format date
  • {Name | toUpperCase}: Convert text to uppercase

Why Choose Sheet to Doc?

  1. Simple Operation: No complex programming knowledge required, just prepare data and templates to generate documents
  2. Powerful Features: Support multiple data formats and placeholder types to meet complex document requirements
  3. Efficient and Fast: Batch generate documents, greatly improving work efficiency
  4. Professional and Beautiful: Generated documents maintain the format and style of the template, professional and beautiful
  5. Multi-platform Support: Provide online version, desktop application and plug-in version to adapt to different usage scenarios
  6. Continuous Updates: The team continuously develops new features to improve user experience

Quick Start

  1. Visit Sheet to Doc Official Website
  2. Prepare your data file (Excel, CSV, JSON, etc.)
  3. Design your Word template and add the required placeholders
  4. Upload data and templates, click the “Generate” button
  5. Download the generated documents

Video Tutorials

If you prefer to learn through videos, you can watch the official video tutorials:

Summary

Sheet to Doc is a powerful document automation tool, especially with the support of image placeholder functionality, it can generate more rich and professional documents. Whether for corporate office or personal use, Sheet to Doc can help you greatly improve document generation efficiency and free you from tedious repetitive work.

Visit Sheet to Doc now and start your efficient document generation journey!

微信二维码
Share