How do I import contacts from an Excel file to Outlook?
Office Outlook 2007 supports the previous Excel file format, which uses the file extension .xls. You can save your Office Excel 2007 worksheet in the file format used by previous releases of Excel and then import data from that file into Outlook. Save an Excel workbook in the Excel 97-2003 Workbook (*.xls) format Important: If you save a workbook in a file format other than a Microsoft Office Excel 2007 file format, formatting and features unique to Excel 2007 will not be retained. • Open the workbook that you want to import into Office Outlook 2007. • Click the Microsoft Office Button, and then point to the arrow next to Save As. • In the File name box, type a new name for the workbook. TipYou can also accept the suggested name. • In the Save as type list, click Excel 97-2003 Workbook (*.xls). • Click Save.
The Import and Export Wizard in Outlook makes it easy to import contact information from an Excel worksheet into your Outlook Contacts folder. • In Outlook, on the File menu, click Import and Export. • Click Import from another program or file, and then click Next. • Click Microsoft Excel, and then click Next. • In the File to import box, browse to find the Excel file (.xls) that contains the content you want to import. • Click one of the following: • Replace duplicates with items imported • Allow duplicates to be created • Do not import duplicate items • Click Next. • In the folder list, click the Contacts folder where you want the imported contact information to go, and then click Next. • To add or remove fields to determine the way the contact information is saved in the new imported file, click Map Custom Fields. • If the Map Custom Fields button in the Import a File dialog box is not available, check the box next to the file on the left & the Map Custom Fields box should become a
