1 : Arrange the Excel data in the traditional database format; i.e., give each column a title to match your Outlook Contacts list, and make each row a record. 2 To display the Name dialog box, press Ctrl-F3. 3 Open Outlook. Arrange the Excel data in the traditional database format.
To import Excel data into Outlook 1  : Arrange the Excel data in the traditional database format; i.e., give each column a title to match your Outlook Contacts list, and make each row a record. 2  To display the Name dialog box, press Ctrl-F3. 3  Open Outlook. 1 Arrange the Excel data in the traditional database format; i.e., give each column a title to match your Outlook Contacts list, and make each row a record. 2  To display the Name dialog box, press Ctrl-F3. 3  Use this dialog box to assign the name Contacts to the entire range of contacts data. Import Contacts from Excel or a CSV File into Outlook. To import contacts from a CSV file or from Excel into Outlook: 1  Select File | Import and Export... 2  from the menu in Outlook. 3  Make sure Import from another program or file is highlighted. 4  Click. 5  Now make sure Comma Separated Values (Windows) is selected. 6  Click. 7  Use the Browse 8  ... button the select the desired file.  Step 1: Select the .csv, Excel, or Access file you want to import. Click the File tab. Click the Business Contact Manager tab, and then click the Import and Export button. Click Import from a File. The Import Business Data wizard opens. Type the location and name of the .bcm file, or click Browse to locate the file. Click Import Outlook Contacts. The Import Business Data wizard opens. The wizard lists your default Contacts folder as the folder to import. To import a different Contacts folder, click Browse. Click the Contacts folder that you want to import, and then click OK. Step 3: Map your CSV file columns to Outlook contact fields. Click the Map Custom Fields button. The Map Custom Fields box appears. Under From, a box shows the column names from your CSV import file. Under To, you see the standard fields that Outlook uses for contacts. Here’s how to save your workbook as a .csv file: In your workbook, click the worksheet with the contact information you want to import. Click File Save As. Choose where to save your file. In the Save as type box, choose CSV (MS-DOS) (*.csv) , give it a file name, and click Save. Note: Select  Comma Separated Values (Windows)  if you save your Excel file as CSV. Browse to the file and press  . Select  Contacts  and press  . You see your named range or csv file name in this dialog. Outlook can only import data from an Excel file(xls) from a named range so we select A1:C5 in this example (with the header row) and use the shortcut Ctrl F3 to open the Name dialog to give the range a name. I use the name  ContactsData . Then we save this file and close it If you have data in cells that you are not going to import, create a named range: 1  Select your used data range and type a name in the field to the left of the address bar. ( 2 Include the field names in your selection.). 3  Press Enter. 4  Save the workbook as an Excel 97-2003 workbook. If you have data in cells that you are not going to import, create a named range: 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. In the example below I show you how to import contacts that are in a Excel file, this option is only working in Outlook 2003-2010 and not in Outlook 2013. If you use data in a Excel file the file must be in the Excel 97-2003 format (xls and not xlsx or xlsm) and your data range must have a name. Outlook can only import data from an Excel file(xls) from a named range so we select A1:C5 in this example (with the header row) and use the shortcut Ctrl F3 to open the Name dialog to give the range a name. I use the name  ContactsData . Then we save this file and close it 1 Alternate method: save the workbook as a CSV file and import the CSV. 2  Outlook 2007 uses the Excel 97-2003 *.xls format, not the Excel 2007 *.xlsx file format. 3  You can import calendar data into any calendar folder in any *.pst or your mailbox. 4  You cannot import into a public folder calendar or secondary Exchange mailbox. If you have data in cells that you are not going to import, create a named range: 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.
https://kb.iu.edu/d/aemb http://email.about.com/od/outlooktips/qt/Import_Contacts_from_Excel_CSV.htm https://support.office.com/en-us/article/Import-your-data-into-Business-Contact-Manager-AA93E491-60CA-441D-8ADC-539F4F572A05 https://support.office.com/en-us/article/Create-a-contact-group-from-a-list-of-contacts-in-Excel-4D7AB35C-0BDF-4DC2-8279-477C1A79AB72 http://www.rondebruin.nl/win/s1/outlook/importcontacts.htm http://www.slipstick.com/tutorial/importing-lists-from-excel-to-outlook/ http://www.rondebruin.nl/win/s1/outlook/importcontacts.htm http://www.slipstick.com/tutorial/importing-lists-from-excel-to-outlook/
how to map excel data to outlook contacts