![Excel and Word on screen](https://img.techwallacdn.com/375/ppds/9195eb2d-d10b-4899-8b08-52ee019b1e41.jpg)
If you keep names and addresses in a Microsoft Excel spreadsheet, it's easy to export that information into another program like Microsoft Word for easy address label printing.
Before you begin, make sure that you have your database of addresses stored in an Excel file. It should be organized with your headers in Row 1 so they look like this (one entry per cell):
Video of the Day
Video of the Day
Name, Address, City, State, Zip Code
Then all of your addresses should follow underneath, in rows 2 and onward. Make sure there are no empty rows or columns.
![Excel with a small set of addresses](https://img.techwallacdn.com/375/ppds/d37b97c6-86cf-4eaa-9680-dc1b7ee91428.jpg)
To actually create the labels, you'll need to use another program, like Microsoft Word. There are many ways to do this, but we'll show you the simplest approach.
Step 1: Start the Mail merge Wizard
![Starting the mail merge wizard in Word](https://img.techwallacdn.com/375/ppds/0841782b-c09e-4c8b-af24-413e5b52e409.jpg)
Start Word and, in a new, blank document, click the Mailings tab and then choose Start Mail Merge, Step By Step Merge Wizard. From this point forward, you'll create the labels by following the wizard's instructions.
Step 2: Choose to print labels
![The mail merge wizard](https://img.techwallacdn.com/375/ppds/0f80f705-d9b9-47cc-b01c-854b1cc83494.jpg)
In Select document type, choose Labels and then click Next (at the bottom of the screen)
Step 3: Select the brand of labels you're printing on
In Change document layout, choose Label options... and choose the kind of address label you plan to print on. For example, if you have a box of Avery address labels, choose Avery from the Label vendors menu, and then find the right product from the (rather long) list. When you've made your selection, click OK and then click Next.
Step 4: Select the Excel spreadsheet
![Importing addresses from Excel](https://img.techwallacdn.com/375/ppds/d4de57b6-36af-4f2d-a2fd-7d99cb8e52cb.jpg)
In Select recipients, choose Use an existing list and then click Browse. Find your Excel spreadsheet and select it. Click OK to accept the first sheet in the spreadsheet, and then click OK to choose all the addresses. Click Next.
Step 5: Insert the address
![Address label template in Word](https://img.techwallacdn.com/375/ppds/74a8e364-3c27-4630-88d8-422986ff8344.jpg)
In Arrange your labels, click Address block... and click OK. This inserts the address block in the first address label on the page. Then click Update all labels to replicate it throughout the page. Then click Next.
Step 6: Preview the address labels
![The addresses in Word](https://img.techwallacdn.com/375/ppds/88950296-3dc0-487b-a74c-aed1a9106292.jpg)
On this page you should see a preview of all the addresses on the page. Click Next.
Step 7: Print
Finally, click Print and follow the print steps to print your address labels.