Article ID: 2848343 - View products that this article applies to.
Expand all | Collapse all

On This Page

Summary

This article describes how to use the Import and Export Wizard to import text data to Microsoft Outlook 2013, and to export Outlook data to a text file.

Using a text file is helpful when the converters provided with Outlook do not directly match the format of the data that you want to import. Most programs can export and import text files, so you can often use a text file as a common file format to export and import data.

More information

The Outlook Import and Export Wizard in Outlook 2013 can import and export text data using the Comma Separated Values format.

How to Generate a Sample of Outlook Fields

Before you edit your data source, it may be helpful to generate a sample of the fields that are used in Outlook. To do this:

  1. Right-click the Outlook folder that you want to use, and then click New Folder on the shortcut menu.
  2. Click the File tab, and then select Open & Export.
  3. Click Import/Export.
  4. In the Choose an action to perform list, select Export to a File, and then click Next.
  5. In Create a file of type, select Comma Separated Values, and then click Next.
  6. In the Select folder to export from list, select the folder that you created in step 2, and then click Next.
  7. In the Save exported file as box, type a name for the file, click Browse to select a folder to save the file in, and then click Next.  
  8. Confirm the action, and then click Finish.
The resulting comma-separated values file contains the fields that Outlook uses for the folder that you selected. Repeat this step as necessary for each type of data that you want to import. While you familiarize yourself with the Outlook field labels, note that precise spelling is necessary. For example, when defining electronic mail addresses, Outlook uses the spelling, "e-mail" (without quotation marks).

How to Import Text Data

To import data from a Comma Separated Values file, follow these steps: 

  1. Click the File tab, and then select Open & Export.
  2. lick Import/Export.
  3. In the Choose an action to perform list, select Import from another program or file, and then click Next.
  4. In the Select file type to import from list, select Comma Separated Values, and then click Next.
  5. In the File To Import box, type the path and the file name of the file that you want to import, or click Browse to locate the file.
  6. In the Options section, select how you want handle duplicate items and click Next.
  7. In the Select Destination Folder list, click the folder that you want to import to, and then click Next.
  8. Confirm that the destination folder is correct, and then click Finish.

How to Export Text Data

To export text data to a Comma Separated Values file, follow these steps: 

  1. Click the File tab, and then select Open & Export.
  2. Click Import/Export.
  3. In the Choose an action to perform list, select Export to a file, and then click Next.
  4. In the Create a file of type list, select Comma Separated Values, and then click Next.
  5. In the Select folder to export from list, click the folder that you want to export, and then click Next.
  6. In the Save exported file as box, type a name for the file, click Browse to select a folder to save the file in, and then click Next.
  7. Confirm the action, and then click Finish.

Properties

Article ID: 2848343 - Last Review: May 8, 2013 - Revision: 1.0
Applies to
  • Microsoft Outlook 2013
Keywords: 
KB2848343

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com