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 screenshots

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

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

  • 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

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 screenshots

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

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

  • 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.

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

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

  • 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)

400 South Street
Titusville, FL 32780

2725 Judge Fran
Jamieson Way
Viera, FL 32940

1515 Sarno Road
Melbourne, FL 32935

Palm Bay
450 Cogan Drive SE
Palm Bay, FL 32909