When your folder is in a List view in Outlook, you can simply select the items which you want to export and then copy them (CTRL+C) in Outlook and paste them (CTRL+V) directly in Excel. You actually don’t need the Import and Export Wizard at all when you want to Export something to Excel. When you want to save it as an actual Excel file, choose File-> Save As and set the “Save as type” dropdown to “Excel Workbook (*.xlsx)” or Excel 97-2003 Workbook (*.xls).
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.