how to export contacts from outlook public folder to excel

In the Convert Text to Columns Wizard which opens, select: Delimited.Click on the “A” column to select the entire column.This can be fixed easily from within Excel in the following way: That happens when your default list separator in the Regional Settings of Windows isn’t set to a comma. In some cases, everything will show up in a single column and with a lot of commas visible. In most cases, this will open the file as if it was an xls-file and you can directly start working with it.

Once you have saved the csv-file, you can open it in Excel via a simple double click on the csv-file or via the “File-> Open” command in Excel 2013 or the “File-> Open-> Browse” command in Outlook 2016 and setting the file type filter to “All files (*.*)” or to “Text Files (*.prn *.txt *.csv”). To export to Excel choose: Comma Separated Values.

File-> Open & Export-> Import/Export-> Export to a file.

The steps to export your data to a csv-file instead of an xls-file are the same with the exception that you now choose for “Comma Separated Values” Instead of updating the wizard to support the xlsx-format, they took it out completely as you can basically achieve the same with the csv-format which Excel supports as well. This included the Excel option as well.Įven though the xlsx-format has been the standard since Office 2003, the Import and Export Wizard still only supported the old xls-format. The Import and Export Wizard of Outlook 2013 and Outlook 2016 has indeed been “cleaned up” by removing some old or redundant file formats. Why has it been taken away and what is the alternative now?

However, now that I’ve upgraded to Outlook 2016, the option to import from or export to an Excel file is no longer available. You also have some Import/Export tips which involve Excel. In previous versions of Outlook, I regularly exported some of my Outlook Calendar, Contacts and Mail data to Excel files to work with it from there or imported data into Outlook from Excel.

How to export contacts from outlook public folder to excel