The reason is because with some Regional settings, Excel uses the semi-colon ( ) as a delimiter for a csv-file instead of a comma, which Outlook expects. If the csv-file isn’t automatically selected when importing, something is wrong. In that case, do not select it but press Cancel as forcing the import will create broken items. In some cases however, this option is not selected. In most cases, when you get at the “The following actions will be performed” step, the option to import your csv-file is selected and you can press Finish to complete the Import process. You can now import that csv-file into Outlook just as you would have done with an Excel file but now of course choose to import a “Comma Separated Values” file. Simply choose “Yes” as you’ll still keep the original Excel file as well. Some features in your workbook might be lost if you save it as CSV (Comma delimited). You may get the following warning when saving your file:
#IMPORT CALENDAR TO OUTLOOK FROM EXCEL HOW TO#
In addition, you can apply a filter to your View in Outlook already so you won’t have to filter them afterwards in Excel.įor a step-by-step example on how to do this for Contacts see the guide:Įxport Contacts to Excel. You can refine this by customizing you View in Outlook by adding or removing columns so just the data which you need will get copied so you won’t have a lot of empty columns or unwanted data in Excel either.
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). 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:
#IMPORT CALENDAR TO OUTLOOK FROM EXCEL WINDOWS#
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.
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.
0 kommentar(er)
