格 千格 KiloCell

Text template filler

Defines the template by {{variantname} to quickly fill and generate structured text. Supports CSV data batch generation.

This will show the corresponding input box after entering {{Variationname} in the template.

First behavior variable, comma separated

What is the text template fill?

The text template fill is a technique for quickly generating uniform but variable text in multiple formats by injecting dynamic data (variables) into predefined static structures (templates). It passes the placeholder (as used in this item) `{Varial name}}' to mark the part that needs replacement.

This technology is widely applied in automated office, software development and customer relationship management. It can re-engineer the already cumbersome work -- like changing email names or building KiloCell of lines manually. SQL Insert statement - Shorter to a few seconds.

Core strengths of this tool

  • Intuitively easy to use: Use double-bracket `{{}} 'Standard syntax, as you see, to enter an instant preview of the variable.
  • Batch processing: Depth integration of CSV data import function. Just paste CSV format the table data that generate hundreds of records in an instant.
  • Pre-set rich: Internalizes common office and development templates, including business mail, SQL operations, code Docstring Wait, make it easy to call quickly.
  • Fully localized: All data processing is done in your browser memory and the data will not be sent to any server. This is essential for processing texts containing sensitive information such as the name of the customer, the order number, etc.

Typical application scenario

  • Human resources and administration: The bulk generates entry notices, wage statements, holiday notices.
  • Developer: Generates `INSERT ' statements by database field batch, or duplicates a snivelling by configuration.
  • Marketing: Creates a personalized EDM email template that converts the CSV export list of potential clients to the sending content.
  • Financial management: (c) Batch fill-in of billing details or statement of cost reimbursement.

How to generate a CSV batch?

First, prepare templates containing variables in the Definition Template box, such as: `Hello' {name}, your balance is {{balance}}。 `

2. Enter CSV in batch filling area Data. ** The first line must be a variable name** and must be fully consistent with the variable name in the template (case-sensitive).

3. The variable is separated by a comma in English and each row below represents a set of data.

Click on the Batch Generation button, where the system will automatically rotate and the results will be displayed sequentially below.

Common issues (FAQ)

Q: What are the limits to the variable name?

A: Variable names suggest the use of letters, numbers and underlined characters, and do not suggest the inclusion of special symbols. Variable name is case-sensitive, i.e. `{Name} `and `{name} `will be considered two different variables.

Q: How many data do batch processing support?

A: Depending on your browser performance and memory. Usually handle KiloCell of lines of CSV The data is free of pressure. If the amount of data is 10,000 or more, the page may have a short character.

Q: Can the processing result be exported to Excel?

A: Only the export of a text-only (.txt) file is currently supported. Import if you need to Excel, if you want to copy the generated contents, paste them to Excel's cell.

All tools