1. Home
  2. Barcode & Generate
  3. Excel Address Label Printer

Excel Address Label Printer

Turn an Excel mailing list into an exact-size address label PDF.

Runs in your browser · No upload
1. List

The first row of your file or pasted table must be headers. An example list is loaded below.

List
Loaded: Example list | 3 rows · 5 columns Drop another file to replace it.
2. Columns
Used when there is no honorific column or the cell is empty.
3. Label layout
4. Label sheet
/ 21
For a partly used sheet, set where the first page starts. Numbered left to right, top to bottom.
Already used on the first page. Example: 2, 5-7
Pick a printer profile saved in the Label Sheet Printer, if you have one.
Labels
3
Sheets needed
1
Overflowing
-
Preview
Page 1 / 1

Red cells are labels whose text does not fit.

How to use

  1. Drop an Excel (.xlsx) or CSV file, or paste a table. The first row must be headers.
  2. 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.
  3. Pick a label layout (postal code + two address lines + name, one-line address, or with company and department), or build your own.
  4. Choose the label sheet and start cell, then flip through the pages in the preview.
  5. 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.

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.

Can't find the tool you need?

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