Importing lists from Excel to Outlook

Many users have contact data stored in Excel workbooks or created calendar events in Excel to take advantage of formulas and fill features when creating a large number of events. It's very easy to move the data to Outlook.

As with any database, you will need to name the columns your data is in. You can either use whatever name you want and map it to Outlook fields or export to Excel format and delete the data from the workbook and enter your data. You'll also need to name the used range of cells in Excel.

The steps you'll need to follow in Excel are:

1. Select your used data range and type a name in the field to the left of the address bar.
2. Press Enter.
3. Save the workbook as an Excel 97-2003 workbook.
4. Close Excel.

Now go to Outlook:

1. Go to File, Import and Export
2. Select Import from a file
3. Choose Microsoft Excel as the source
4. Browse to the workbook file.
5. Select the Calendar folder.
6. Select the named range. If you export to Excel to get the field names, you'll see two named ranges when you import. Just make sure you select the correct named range.
7. If you aren't using the field names that Outlook uses, you'll need to map your fields to Outlook's fields.
8. Press Next when ready and finish the import.

More Information