Import Outlook contacts into Excel Start Outlook. On the File menu, click Import and Export . Click Export to a file , and then click Next . In the Create a file of type box, click Microsoft Excel , and then click Next . In the Select folder to export from box, click Contacts , and then click Next . Note To import only the contacts you want, you can copy them to a new folder in Outlook, and then click that folder. For more information, see Outlook Help. In the Save exported file as box, specify a path and a name for the file, and then click Next . If necessary, map fields from the file you are exporting to Excel. How? Click Map Custom Fields . In the From box, drag the field you want to convert onto the Microsoft Excel field listed in the To box. If you want to see additional records in the From box, click Previous or Next . If you want to remove all mapping, click Clear Map . If you want to reset the original mapping, click Default Map .