Easiest Way to Make Labels From Spreadsheets
Making labels from a spreadsheet can be done using the tools on your computer or online software. This process can be done at home or in your office. There are several free templates available to download. Once you download the templates, you can load your data and then complete the labels.
Other People Are Reading
Instructions
-
Make Labels by Using Microsoft Excel Templates
-
1
Open Microsoft Excel and locate the template gallery.
To find templates in Excel 2007, select the “Office” button and select “New.” Using your left task pane, select the “Labels” category from the Microsoft office online. Select “Mailing and Shipping” and “Business.” Download the label spreadsheet once you locate it.
-
2
Use find and replace to update the spreadsheet for your labels. On the “Home” Tab, locate your “Find and Select” button. Click on the drop down arrow and select “Replace.” In the “Find What” section, type “Name.” In the “Replace What,” type in the name you want on your labels. Click “Replace All.”
-
-
3
Repeat Step 2 for the address sections of the label. You will replace the section with the generic text of "Address" and "City, State, Zip."
Make Labels by Using Google Document Templates
-
4
Open Google Documents and locate the template gallery.
Find label templates in the Google template gallery by locating “All Categories” and selecting “Labels and Business Cards.” Locate the Avery label and click “Use this Template.” The label template will open for use.
-
5
Use find and replace to update the spreadsheet for your labels. Select “Edit” and “Find and Replace.” In the “Find What” section, type “Name.” In the “Replace What” section, type the name you will use on your labels. Click “Replace All.” Repeat this step for the address sections of the labels.
-
6
Repeat Step 2 for the address sections of the label. You will replace the section with the generic text of "Address" and "City, State, Zip."
Making Labels Using Microsoft Word, Microsoft Excel and the Mail Merge Feature
-
7
Save your label data in Microsoft Excel 2007. Make sure you have column headers identifying the data in each column. Save your spreadsheet by selecting the “Save” button on the Quick Access Toolbar.
-
8
Open Microsoft Word 2007 and select the “Mailings” tab. Click on the “Start Mail Merge” button and select “Labels.” Select your label vendor and product number. Click “OK.”
Click the “Select Recipients” button on the “Mailings” tab. Select “Use existing list.” Change your file type to “Excel Files.” Browse your computer and find your saved Excel spreadsheet containing your data. Click “Open.”
-
9
Select “Insert Merge Field” drop down list and add the different fields to label. After adding your fields, select “Update Labels.” Click “Preview results.” Click the “Finish & Merge” drop-down list and select “Edit Individual Documents.” Under “Merge Records,” select “All.”
-
1
References
- Photo Credit Black Grey and White Envelope Set image by Sophia Winters from Fotolia.com
