how to export contacts from outlook to excel 2013

Note, you will encounter the same kind of problem going in reverse, an Excel worksheet in this case saved as a CSV file will not import correctly into Outlook since the Excel file will create the CSV file using the defined list separator character. When all contacts have been selected, you need to click on the 'Settings' again, and click 'Export vCard'. In short, if Excel is asking you to define the file prior to actually displaying it in a worksheet - that would be your problemĪnd if that's the case, the quickest solution would be to change your regional settings to US (or any region where the comma is defined as the character) - open it in Excel and change your regional settings back to normal. Select 'Contacts' icon in the main screen, and click on 'Settings', then you can select the contacts you need to export. Excel/Access on the other hand will use the 'list seprator' character as the field separator in a CSV file. Exporting contacts from Outlook can help you a lot. Whether you intend to use a mail program, backup Outlook contacts or update Outlook contacts in Excel file. There are various reasons why we want to export Outlook contacts. Select the Browse button to find the CSV file you want to import. Highlight the Comma Separated Values option and then click the Next button. Advertisement Select Import from Another Program or File and then click the Next button. From there, select Open & Export > Import/Export.

If it's 4800 rows each with one cell of informationWhat is the default region on your system? More specifically, what is the 'list separator' character for your system? Outlook creates a pure CSV file which means each field is separated by a comma (CSV =Ĭomma Separated Values). How to Export from Outlook 2013/2010/2007 to Excel/Gmail 'Export Outlook contacts' is a heated topic on the Internet. Open Outlook and then click on File to open the menu. When you say that you're getting 4800 records - do you mean 4800 rows with a single value in the first cell that encompasses multiple fields or 4800 rows where the individual fields are actually separated into their own cells?Īssuming that you actually mean 'opening the csv file' in Excel since you don't 'import' a CSV file in Excel.

How to export contacts from outlook to excel 2013