How to use
- Drop an Excel (.xlsx) or CSV file, or paste a table. The first row must be headers.
- Recipient, address 1, address 2, postal code, phone and honorific columns are matched from the header names. Fix any wrong guess in the drop-downs.
- Pick a label layout (postal code + two address lines + name, one-line address, or with company and department), or build your own.
- Choose the label sheet and start cell, then flip through the pages in the preview.
- Create the PDF and print it at “Actual size (100%)”. “Fit to page” or “Shrink to fit” shifts the cells.
Preparing the list
| Purpose | Header names recognized |
|---|---|
| Recipient | 이름, 성명, 수신자, 받는분, name, recipient |
| Address 1 | 주소, 도로명주소, address, address1 |
| Address 2 | 상세주소, 주소2, address2 |
| Postal code | 우편번호, 우편, zip, postal code |
| Phone | 전화, 연락처, phone, tel |
| Honorific | 호칭, title |
- When there is no honorific column, or the cell is empty, the “Fixed honorific” value is used. It is “님” for Korean lists and empty by default in English.
- In a custom layout you can use
{name}{address1}{address2}{zip}{phone}{title}(or the Korean forms such as{이름}) and any header from your list, for example{회사}. The company layout expects “회사” and “부서” columns; when they are missing the line is dropped. - A line whose values are all empty, such as address 2 for someone without one, is dropped automatically.
Korean postal codes
Korea has used 5-digit postal codes since 2015. Excel often stores “04524” as the number 4524 and loses the leading zero, so a 4-digit number is padded back to “04524”. Six digits (123456 or 123-456) print as an old-style 123-456 code, and anything else is printed unchanged.
Auto-fit text
A line wider than the cell’s inner width (the cell minus 2 mm padding) shrinks in 0.5 pt steps down to 7 pt. If it still does not fit, it wraps at spaces at that size, and a long word with no spaces is cut by character. When the whole text block is taller than the cell, the row in the list and the cell in the preview turn red. On an A4 21-label sheet (63.5 × 38.1 mm) the text area is 59.5 × 34.1 mm, and one 7 pt line is about 2.96 mm high. A line you set at 7 pt or smaller is never enlarged.
Choosing a sheet and print alignment
Address labels are usually 21 per sheet (63.5 × 38.1 mm), 24 (63.5 × 33.9 mm) or 16 (99.1 × 33.9 mm); these are listed first. For a partly used sheet, set the start cell and the cells to skip (for example 2, 5-7).
Every printer drifts a little. Offsets you saved by printer name in the A4 Label Sheet Printer are shared with this tool in the same browser, so you can pick one from the list to fill in horizontal, vertical and scale. You can also type values, and “Print cell borders” lets you check the position on plain paper first.
Return address labels
In “Return address” mode, enter your name, postal code and address once and choose how many copies. It uses the same layout as the recipient labels, so they match.
Privacy and related tools
The list is read in your browser, and text is drawn with the browser’s canvas and placed in the PDF (any language, 300 dpi). If your addresses sit in one column, split them first with Address Cleaner & Splitter. To inspect or tidy the list use the Excel & CSV workbench, and for custom line wording see the Template Filler.
The list you enter is processed only in your browser and is never sent to a server.