How to use Excel and CSV to Address Labels
- 1Open an XLSX, CSV or TSV file of up to 5 MB, or try the sample spreadsheet. If the workbook has several visible worksheets, choose one.
- 2Leave First row contains headings ticked if row 1 holds column names. Then choose a column for Line 1 to Line 4, or Skip line. The First label box shows the result.
- 3Choose the label sheet: Formtec 3107 (A4, 16 labels), Avery 5160 (Letter, 30 labels) or Custom dimensions.
- 4Set Skip used labels if the first sheet is partly used, adjust the font size, and tick Include outlines for a plain-paper test.
- 5Click Preview printable PDF, page through the sheets, then download the PDF and print at Actual size.
Keep postal codes and align the stock
The test kept postal codes such as 00123 in CSV and 01234 in formatted Excel. Store postal codes as text or use the appropriate Excel number format. Formtec 3107 has 16 labels on A4. Avery 5160 has 30 on US Letter. Use the horizontal and vertical adjustments after a plain-paper test. For a full table instead, use Excel to PDF.
What we saw when we tested it
We used a guest list workbook with 47 addresses: 45 US-style rows and two Korean addresses, with Name, Street, City, Postal and Country columns. With lines mapped to Name, Street, City and Postal, the page counted 47 labels.
- Formtec 3107: 3 sheets (16, 16 and 15 labels), built in about 1.0 second.
- Avery 5160: 2 sheets, about 0.65 seconds.
- Avery 5160 with 7 used labels skipped: still 2 sheets; the preview showed the first seven positions empty and Taylor Nguyen starting in row 3, column 2.
Because the list contained Hangul, the full Korean-capable font was embedded and each PDF was about 1.04 MB. The same list without the two Korean rows, saved as CSV, produced a 5.5 KB PDF, because plain English text uses a font built into every PDF reader. Neither run reported overflowing or missing characters.
Label sheet sizes, and how to enter your own
Avery 5160 labels are 2 5/8 by 1 inch, three across and ten down on US Letter. Formtec 3107 labels are 99.1 by 33.9 mm, two across and eight down on A4. If your sheets are a different product, choose Custom dimensions and copy the numbers from the label packaging or the manufacturer's template, in millimetres: paper width and height, columns, rows, label width and height, left and top margins, and the horizontal and vertical gaps between labels.
The page checks that the grid fits on the paper and refuses layouts that do not. Labels must be at least 15 by 10 mm, the paper between 100 and 400 mm on each side, and a sheet can hold up to 100 labels.
Print a test sheet first
Printers rarely feed paper perfectly straight, and Fit to page scaling quietly shrinks everything by a few percent. Tick Include outlines for a plain-paper test, print one page at Actual size or 100%, and hold it against a label sheet in front of a light. If every address sits slightly low, enter a negative value in Shift down; if it sits to the left, enter a positive Shift right. Both shifts take values from -10 to 10 mm in 0.1 mm steps. Untick the outlines before printing on real labels.
Long addresses and missing characters
Text starts at the font size you choose (6 to 18 points, 10 by default) and wraps to fit the label width. If an address is still too tall, the size steps down by half a point until it fits, down to 6 points. If it still does not fit, that label is left blank and the page tells you how many labels overflowed; download stays off until you shorten the text, reduce the number of lines or choose a larger label. Characters that the print font cannot draw, such as some emoji or rare scripts, are reported in the same way, so you never print a sheet with silent gaps.
Limits and common problems
Each worksheet can have up to 600 addresses and 60 columns. Hidden worksheets are ignored, and password-protected workbooks cannot be opened. Each label holds up to four lines; if a street address is split across two columns, map them to separate lines or join them in the spreadsheet first. Values are read as Excel displays them, so dates and numbers keep their formatting. If postal codes have lost their leading zeros in the file itself, fix the column format in Excel before loading it. To clean the list first, try Remove Spreadsheet Duplicates or combine several lists with Merge Spreadsheets.
Frequently asked questions
Can I start on a partially used sheet?
Yes. Count used positions from the top left, moving across each row. The first address starts at the next position.
Does it work with Google Sheets?
Yes. Download the sheet as XLSX or CSV from Google Sheets, then open that file here.
Is my address list uploaded?
No. The spreadsheet is read and the PDF is built in your browser, which matters for lists of names and home addresses.
Why is the PDF about 1 MB?
When the list contains Korean or other non-Latin text, the complete print font is embedded so every character prints correctly. English-only lists use a built-in font and stay a few kilobytes.
Can I print return labels with the same address on every label?
Make a sheet with the address repeated in as many rows as you need labels, then map it as usual.