1. Home
  2. Documents
  3. HWPX Mail Merge

HWPX Mail Merge

Generate one HWPX document per row of an Excel list from a template.

Runs in your browser · No upload For Korea

1. Template document

2. List

List
Load the second table (file or paste).

How to use

  1. Upload the template document (.hwpx or .hwp). It must contain named click-here fields. A password-protected template opens once you enter the open password.
  2. Add the list: upload an xlsx or CSV, or paste from Excel (sheet and header row can be chosen).
  3. For each field choose a list column. If the field name and a column name match (ignoring spaces and letter case) they are paired automatically. Instead of a column you can enter a fixed value for every document, or leave it blank.
  4. Set the file name pattern, save format and which rows to make, and check page 1 with Preview first row.
  5. Press Create documents. A progress bar shows, and when it finishes you download one ZIP. If you cancel part-way you can still download what was made.

File name pattern

Type something like {Name}_certificate and {Name} is replaced by that row’s value. Column names ignore spaces and letter case, and {#} is the row number. The extension (.hwpx or .hwp) is added for you.

Situation Result
{Name}_certificate, Name = Kim Kim_certificate.hwpx
Empty value, or a column that does not exist The row number takes its place (e.g. 7_certificate)
Value contains \ / : * ? " < > | Replaced with _
Two or more identical names (2), (3) is added, ignoring letter case
Longer than 100 characters Cut to 100

Leading and trailing spaces and dots are removed, and a name that starts with a Windows reserved word (CON, NUL, …) gets a _ in front.

How values go in

  • Each document is made by reopening the original template for every row, so nothing from the previous row can stay in the next document. An empty cell leaves an empty field.
  • Numbers go in as the stored numeric value, not as formatted in Excel. Turn on Add thousands separators to get 1,234,567.5; it is off by default.
  • Excel date cells can be written as 2026-03-05 (default), 2026년 3월 5일 or 2026. 3. 5.. Dates stored as text are copied as they are.
  • A line break inside a cell becomes a line break in the document. Control characters that the file formats cannot store are removed.
  • Up to 1,000 documents at a time. For more, split the list with a row range (1-500) or a column filter.
  • Rows that could not be made are listed with the row number and the reason. The documents that succeeded can still be downloaded.

Making click-here fields

In Hangul open the template, put the cursor where the value goes, choose Input → Field → Click-here field, then set the guide text and a name (for example Name, Course). If the name matches a column heading in your list, pairing is automatic. Using the same name in several places fills them all from one column. It suits names and dates on certificates, or recipients and amounts in notices.

How this differs from Hangul’s own mail merge

  • It works in the browser with nothing to install.
  • The result is one file per person in a ZIP, not pages stacked in a single file.

FAQ

Can I get everything in one file? Not at the moment. The engine cannot copy content between documents, so results are always one file per row. If you need a single file, combine the results in Hangul.

What about password-protected templates? They open with the open password; the generated documents are not password-protected.

I only need to fill in one document. Use Fill HWPX Fields. To change only the format use the HWP ↔ HWPX Converter, and to tidy up the list the Excel Viewer is handy.

Your files are only processed in your browser and are never sent to a server.

Can't find the tool you need?

Tell us what you want to do. We build the most requested tools first.