How to Print Labels from Excel and Google Sheets

Last updated: April 12, 2026

You have a spreadsheet full of addresses, product names, or inventory data : and you need them on labels. Whether you're using Microsoft Excel, Google Sheets, or any other spreadsheet app, the process follows the same basic workflow: organize your data, export it, import it into a label maker, and print. This guide walks you through each step.

Step 1: Organize Your Spreadsheet

A well-structured spreadsheet makes label printing painless. Follow these rules:

• Use one row per label. Each row in your spreadsheet becomes one label.
• Use clear column headers. The first row should contain headers like "Name," "Address," "City," "State," "ZIP." These headers help the label maker map your data to the right fields.
• Keep data consistent. Don't mix formats : if one cell says "California" and another says "CA," your labels will look inconsistent. Pick one format and use it throughout.
• Remove blank rows. Empty rows in the middle of your data will create blank labels. Delete them before exporting.

Example Spreadsheet Layout

Here's what a clean address list looks like:

• Column A: Name > "Jane Smith"
• Column B: Address > "123 Oak Street, Apt 4B"
• Column C: City > "Portland"
• Column D: State > "OR"
• Column E: ZIP > "97201"

Important: If your ZIP codes start with a zero (like 01234 for Massachusetts), make sure the ZIP column is formatted as text, not a number. Otherwise, Excel will strip the leading zero.

Step 2: Export as CSV

CSV (Comma-Separated Values) is the universal format that every label maker can read.

From Microsoft Excel:

1. Click File > Save As
2. Choose the save location
3. In the "Save as type" dropdown, select CSV (Comma delimited) (*.csv)
4. Click Save
5. Excel will warn you about losing features : click Yes (CSV doesn't support formatting, but you don't need it for labels)

From Google Sheets:

1. Click File > Download
2. Select Comma Separated Values (.csv)
3. The file downloads to your computer automatically

From Apple Numbers:

1. Click File > Export To > CSV
2. Click Next, choose a location, and click Export

Step 3: Import into the Label Maker

Once you have your CSV file, importing it into our free label maker takes about 30 seconds:

1. Open the label editor and select your label size (e.g., Avery 5160 for address labels).
2. Click the CSV Import button.
3. Select your CSV file from your computer.
4. The tool reads your column headers and shows a preview of your data.
5. Map each column to the appropriate label field (or use the auto-detected mapping).
6. Click Generate Labels : each row from your spreadsheet becomes a separate label.

Step 4: Preview and Print

Before committing your label sheets, always preview:

• Check the first and last labels : make sure no data was cut off or misaligned.
• Look for formatting issues : long addresses may overflow. If they do, reduce the font size or switch to a larger label template.
• Print a test page on plain paper : hold it up against a sheet of labels to verify alignment before using your label stock.
• Check print settings : set to "Actual Size" or 100% scale. Never use "Fit to Page" as it will shrink your labels and throw off the grid alignment.

Common Issues and Fixes

• ZIP codes losing leading zeros: Format the ZIP column as text in Excel before saving. In Google Sheets, format as "Plain text."
• Special characters garbled: Make sure your CSV is saved with UTF-8 encoding. This preserves accented characters, international addresses, and special symbols.
• Blank labels appearing: Your spreadsheet has empty rows. Open the CSV in a text editor and delete any blank lines at the bottom.
• Labels printing off-center: Check that your page margins in the print dialog match the label template. Most Avery templates assume specific margins.
• Commas in addresses breaking the CSV: If an address contains a comma (like "Suite 100, Building A"), it needs to be enclosed in quotes. Most spreadsheet apps handle this automatically when exporting.

Tips for Large Mailings

• De-duplicate your list before printing. Sort by name or address and remove duplicates to avoid wasting labels.
• Sort by ZIP code if you're doing a bulk mailing : this can qualify you for USPS postal discounts.
• Print a few extra sheets. Label sheets occasionally jam or misalign. Having spares avoids re-printing the entire batch.
• Save your label template. If you do regular mailings, save the layout so you only need to swap in a new CSV each time.

printshi vs Word Mail Merge: Which Is Easier?

Tips for Formatting Your Spreadsheet Data

Keep columns clean. Use consistent formats. Put each address component in its own column (Name, Street, City, State, ZIP). Don't merge cells. Remove formatting. Leading zeros in ZIP codes: format the column as text before entering data.

Frequently Asked Questions

Can I print labels from Excel without Word?

Yes. Export your Excel file as CSV and import it directly into printshi. No Microsoft Word or mail merge needed.

How do I print labels from Google Sheets?

In Google Sheets, click File > Download > CSV. Then import the downloaded CSV file into printshi's editor.

Why are my ZIP codes missing leading zeros?

Excel treats ZIP codes as numbers by default, stripping leading zeros. Format the ZIP column as text before entering data, or add an apostrophe before the ZIP (e.g., '01234).

Can I print different labels from each row?

Yes. Each row in your CSV becomes a separate label. You can print hundreds of unique labels from one spreadsheet.

What format does the CSV need to be in?

Standard CSV with column headers in the first row. UTF-8 encoding is recommended for international characters. Most spreadsheet apps export this format by default.

Can I save my label template for reuse?

Yes. printshi saves your designs in your browser's local storage. Next time, import a new CSV into the same template layout.

Print Labels from Your Spreadsheet Now

Our free label maker accepts CSV files from Excel, Google Sheets, Numbers, or any spreadsheet app. Import your list, choose your label size, and print : all in your browser with no software to install and no data uploaded to any server.