---
title: "Print Recipient Addresses on Envelopes"
url: "https://www.whcc.com/help/ordering/print-recipient-addresses-on-envelopes/"
description: "Set up our address spreadsheet, save it as a CSV, and upload it to print recipient addresses on 5×7\" card envelopes ordered online."
updated: "2026-11-16T11:00:22-06:00"
---

# Print Recipient Addresses on Envelopes

Set up our address spreadsheet, save it as a CSV, and upload it to print recipient addresses on 5×7" card envelopes ordered online.

2 min read

[Watch the video](https://www.youtube.com/watch?v=Q54pe9NCnIM)

![WHCC Software Tutorials cover reading Recipient Addresses: Set Up a Spreadsheet for Envelope Printing, with an address table flowing into an envelope](https://whcc-com-prod-images0.imgix.net/images/recipient-addresses-envelope-printing-video-cover.jpg?auto=format,compress&cs=srgb&fit=max&w=1000&q=75)

Recipient address printing is available for 5×7" envelopes on [Flat Cards](https://www.whcc.com/products/flat-cards/) and [Folded Cards](https://www.whcc.com/products/folded-cards/) ordered online. It is not available in ROES.

**Important:** We print addresses exactly as they appear in your file. We don't check names, spelling, or address formatting.

## Download the address spreadsheet

1. On whcc.com, hover over **Cards** in the top menu and click **Flat Cards**.
2. Scroll down and open **File Prep & Templates**.
3. Click **Recipient Addressing Toolkit**. A ZIP file downloads with two spreadsheet templates and a PDF guide.

You can also download the [Recipient Addressing Toolkit](https://cdn.dragdrop.design/downloads/Address_Templates.zip) directly.

## Choose a spreadsheet layout

The two templates use different layouts. Choose the one that fits how your addresses are stored.

| Spreadsheet Name | Layout | Columns | How it prints | Best for |
|---|---|---|---|---|
| Components | Auto Formatted | Recipient Name, Street 1, Street 2, City, State, Zip, Country | City, State, and Zip combine into one line. Street 2 and Country are optional. | Addresses already stored in separate columns |
| Lines | Line by Line | Line 1 through Line 5 | Each column prints as one line, exactly as typed. Up to 5 lines. | International addresses, or full control over each line |

To print only a name with the Auto Formatted layout, fill in Recipient Name and leave every other column in that row blank.

## Fill in and save your addresses

1. Open the template for the layout you chose.
2. Enter one address per row. Keep the column headings in row 1 as they are. Don't rename or delete them.
3. Keep your addresses on the first tab of the spreadsheet. Only the first tab uploads.
4. Save the file as a CSV (.csv) or Excel file (.xls or .xlsx):
    - Numbers: File > Export To > CSV
    - Google Sheets: File > Download > Comma-separated Values (.csv)
    - Excel for Microsoft 365: File > Save As > Download a Copy

Follow these rules so your addresses print correctly:

- Don't use special characters, such as ü, é, ñ, ¿, or •. They cause an error when you upload.
- Keep each line to 50 characters or less.
- Use normal capitalization. All caps is hard to read, especially in script fonts.
- Don't add spaces between letters, such as J O H N.
- Leave out emojis. They're removed when you upload.

## Upload your addresses

1. Design your card in the online editor. [Order Flat Cards Online](https://www.whcc.com/help/ordering/order-flat-cards-online/) covers the design steps.
2. Click **Envelopes** in the upper right and choose an envelope style.
3. Under envelope printing, click **Add**, then choose **Printed with Full Addressing**.
4. Click the upload button and choose your file, or drag the file onto it. Your addresses fill in on the envelope.
5. Use the back and forward arrows below the envelope to check each address. The preview shows exactly how each one will print. The editor also tells you if any envelopes in your order will be blank or if you need to increase the quantity of cards to match the spreadsheet.
6. Click **Review**. The review page shows how many addresses you've added.

To change an address after you upload, edit your spreadsheet, save it again, and upload the new file.

## Related

- [Order Flat Cards Online](https://www.whcc.com/help/ordering/order-flat-cards-online/)
- [Order Folded Cards Online](https://www.whcc.com/help/ordering/order-folded-cards-online/)
- [Press Printed Card Guidelines](https://www.whcc.com/help/file-prep/press-printed-card-guidelines/)
