Print guides · Updated
Keep ZIP Code Zeros When Printing Address Labels from Excel or Google Sheets
Treat ZIP codes as text in the spreadsheet before you enter or export them. If a five-digit US ZIP has already lost its first zero, repair it in a new column with a five-digit TEXT formula, then check the exported CSV as plain text. Stampwick also restores a missing zero for 3- or 4-digit values under a column named ZIP or ZIP Code, but it cannot infer every postal format.
Before you start
- A copy of the address list in Excel or Google Sheets, with a separate ZIP column.
- Excel .xlsx and .xlsm, CSV, TSV, pasted spreadsheet rows and a view-shared Google Sheets link are supported.
- A sheet of labels matching the layout you plan to print; 5160-compatible stock is one supported option.
1Fix the column in the spreadsheet
Use a fictional example: Sample Recipient, 1 Example Street, Boston, MA, 02134. ZIP codes identify places; they are not quantities to calculate, so store them as text.
In Google Sheets, select the ZIP column and choose Format → Number → Plain text before entering or pasting codes. In Excel, use Text format before entry, or import a CSV through Data → From Text/CSV and set the ZIP column type to Text in Power Query.
If the zero is already gone, add a helper column. For a US ZIP that should be 02134 but is stored as 2134 in E2, enter =TEXT(E2,"00000"), fill down, then copy the results and paste values. Replace the old ZIP column only after checking the repaired values. This formula assumes five-digit ZIPs; do not use it to invent international postal formats.
=TEXT(E2,"00000")2Check the exported data, not just its display
When using CSV, inspect the file in a plain-text editor and confirm the row contains 02134 before printing. Reopening a CSV in a spreadsheet can apply number conversion again, so the cell display alone is not proof of what the file contains.
A custom number format can show a leading zero while the stored value remains numeric. If another program needs the value, convert it to text or use the TEXT formula and paste the result as values.
3Load the list and review the label preview
Open Stampwick’s address-label tool and paste the rows, choose a supported file, or load a Google Sheet shared for viewing. Keep the header exactly ZIP or ZIP Code if you want the tool’s limited automatic repair for a 3- or 4-digit numeric value.
Check the preview before downloading. Confirm the sample ZIP reads 02134 and that names, street, city and state remain in their intended columns.
4Print a plain-paper test at actual size
Download the PDF and choose Actual size or 100% in the print dialog. Turn off Fit to page or other scaling. Print one page on plain paper, then hold it over the label sheet to check the first and last rows before using label stock.
If the page is consistently shifted, use the printer calibration page and print another plain-paper test.
Check the result
- The spreadsheet or raw CSV contains 02134, not 2134.
- The preview shows the ZIP beside the correct recipient and address.
- The plain-paper page matches the label sheet at 100% before loading label stock.
Troubleshooting
- The first zero is still missing.
Check the source value and header. Stampwick only pads 3- or 4-digit values when the header is exactly ZIP or ZIP Code. Use the spreadsheet repair steps for other headers or formats.
- A code such as 02134-1234 or a non-US postal code changed unexpectedly.
Keep the complete postal code as text in the source. Stampwick’s automatic repair only targets 3- or 4-digit numeric values in ZIP and ZIP Code columns; it is not a general postal-code normalizer.
- The preview is correct but labels drift down the page.
Print at Actual size, verify Letter or A4 matches the label sheet, then test printer calibration and feed alignment on plain paper.
What the tool can and cannot repair
- Automatic ZIP repair is limited to 3- or 4-digit values under exact ZIP or ZIP Code headers. It does not restore arbitrary lost digits or handle ZIP+4 and international postal-code rules.
- Stampwick reads .xlsx and .xlsm workbooks locally, using the first worksheet; old .xls, Numbers and ODS files need exporting first. The Google Sheets link must be shared as “Anyone with the link can view.”
- The tool accepts up to 5,000 rows. Spreadsheet cell formatting is not a promise that the underlying value will be preserved by every export or other application.
- The list is processed in the browser and is not uploaded. Printer margins and feed behavior vary, so use a plain-paper test.
Useful Stampwick tools
- Open the address-label tool
Paste, upload or load a spreadsheet and review the label preview.
- Check the 5160-compatible sheet measurements
Compare the printed layout dimensions with the stock in hand.
- Calibrate a consistently shifted print
Measure the offset on paper and apply it to later PDFs.
Sources
- Keeping leading zeros and large numbers — Microsoft Support. Applies to Excel 2016–2024 and Microsoft 365; checked 26 Oct 2026.
- TEXT function — Google Docs Editors Help. Official formula reference; checked 26 Oct 2026.
- Format numbers in a spreadsheet — Google Docs Editors Help. Official spreadsheet formatting steps; checked 26 Oct 2026.
- Expanding the power of Google Sheets with localized formatting and improved CSV imports — Google Workspace Updates. 7 Feb 2023.