How to make mailing labels from google sheets

You can create mailing labels from Google Sheets using a few different methods. Here are a few options:

Method 1: Using the "Mail Merge" add-on

  1. Install the "Mail Merge" add-on from the Google Workspace Marketplace.
  2. Create a new sheet in your Google Sheet with the following columns:
    • Name
    • Address
    • City
    • State
    • ZIP
    • Label text (optional)
  3. Enter your data in the sheet, making sure to format the columns correctly.
  4. Go to the "Mail Merge" add-on and select the sheet you created.
  5. Choose the label template you want to use (e.g. Avery 5160).
  6. Click "Merge" to generate the mailing labels.

Method 2: Using the "Label Maker" add-on

  1. Install the "Label Maker" add-on from the Google Workspace Marketplace.
  2. Create a new sheet in your Google Sheet with the following columns:
    • Name
    • Address
    • City
    • State
    • ZIP
  3. Enter your data in the sheet, making sure to format the columns correctly.
  4. Go to the "Label Maker" add-on and select the sheet you created.
  5. Choose the label template you want to use (e.g. Avery 5160).
  6. Click "Generate Labels" to create the mailing labels.

Method 3: Using Google Sheets formulas

  1. Create a new sheet in your Google Sheet with the following columns:
    • Name
    • Address
    • City
    • State
    • ZIP
    • Label text (optional)
  2. Enter your data in the sheet, making sure to format the columns correctly.
  3. Use the following formulas to create the mailing labels:
    • =CONCATENATE(A2," ",B2," ",C2," ",D2," ",E2) (assuming your data is in columns A-E)
    • =TEXTJOIN(" ",TRUE,A2:E2) (if you want to concatenate the columns with spaces)
  4. Copy the formula down to the rest of the cells in the column.
  5. Print the sheet as a PDF or use a label printer to print the mailing labels.

Tips and Variations