How to Print Labels from Google Sheets (No Add-On)

Your data already lives in a Google Sheet: names, addresses, SKUs, barcode values in tidy columns. You don't need a clunky add-on or a Word mail merge to turn those rows into labels. Export the sheet as .csv or .xlsx, map the columns once, and PaperReady prints every row as its own label at true size, on a thermal roll or an Avery sheet.

1. In Google Sheets, tidy the data: one row per label, a plain header row (name, address, sku, barcode), and no blank rows.
2. Download it as .csv or .xlsx (File, then Download).
3. Import the file into PaperReady's Batch mode and map each column to a field on the label; point a SKU or UPC column at the barcode field for scannable codes.
4. Install the free Print Bridge and print at true size: each row becomes one label on a roll, or tiled across an Avery sheet.

Google Sheets or Excel, the same flow

PaperReady reads .csv and .xlsx the same way, so a Google Sheet and an Excel file take the identical path. If you work in Excel, the print-from-Excel guide covers the mapping step in more detail.

Addresses, barcodes, product labels

Map an address block for mailing labels, a SKU column to a barcode for product or inventory labels, or any columns you like. Every row prints at true size with no scaling, onto a roll or an Avery sheet.

Frequently asked

Related recipes