Search
Language

How to Import Your Data Into Microsoft Excel or Word

The creation of letters or mailing labels is one that requires some experience using the products, and using text file import. If you are using Microsoft Word, you should be experienced using Mail Merge.

Select the product you are using:

Microsoft Excel Microsoft Word

 

Using Microsoft Excel

 

The following screen shots are taken from Microsoft Excel 2013. The procedures for other versions of Excel are very similar.

  • Start Microsoft Excel
  • Using the Open Dialog Box, navigate to where you have the data file saved, and select "Text Files" from the drop-down list.

Excel open dialog file type selection

  • Once you have done that you will see your data file in the list. Select it and press Open.

Excel open dialog

  • The Text Import Wizard dialog box opens. Make sure the Delimited radio button is selected, and press "Next."

Text import wizard

  • On the next dialog, check the "Comma" check box, and uncheck the other check boxes in the "Delimiters" frame. Leave the Text Qualifier with the default (") entry in it. Press Finish

Text import wizard, delimiter section

Using Microsoft Word to Create Mailing Labels

The following screen shots are taken from Microsoft Word 2013. The principles involved are very similar in other versions of Word.

  • Start Word and open a blank document.
  • From the Mailings ribbon, select "Start Mail Merge" and then select "Labels...".

Word Mail Merge button location

  • Select the type of labels you are going to use, and press OK.

Word label options

  • From the Mailings ribbon, choose "Select Recipients" and then choose "Use an Existing List...".

Word recipient selection

  • Navigate to where your data file is saved, and select it. Press Open.
  • From the Mailings ribbon, select "Insert Merge Field" and choose the field(s) you want to include in your label.

Word insert merge field

  • When you are done, your label will look something like this:

Word example screenshot

  • From the Mailings ribbon, select "Update Labels." The rest of the fields on the page should fill in. 

Word update labels button

  • Press "Preview Results" to verify the data is correct, then select "Finish & Merge" to complete the labels.

321-290-VOTE (8683)
1-833-803-0613 (Spanish - Toll Free)

Titusville
400 South Street
Titusville, FL 32780

Viera
2725 Judge Fran
Jamieson Way
Viera, FL 32940

Melbourne
1515 Sarno Road
Melbourne, FL 32935

Palm Bay
450 Cogan Drive SE
Palm Bay, FL 32909