Tag: Microsoft Excel
How to Import Contact Info Into Outlook from CSV Files
While the CSV import process in Outlook is very simple and extremely reliable, there are a lot of common mistakes that people make causing a lot of unnecessary aggravation along with not realizing what can and can’t be done. Most Common Mistakes Not manually mapping fields in the CSV file to the specific Outlook fields […]
Outlook 2013 Import/Export changes
With the introduction of Outlook 2013, there are now only 2 file types supported for both import and export: 1) CSV file 2) PST File While <CSV> is actually an Excel file type, the one thing that has not changed is how Excel 2013 generates a CSV file from a worksheet. Like it’s predecessors, Excel […]
Creating an Excel Named Range & avoiding Outlook import problems
The most common problems people encounter when importing data using an Excel file involve a missing <Named Range> or an incorrectly defined <Named Range> resulting in either too few or too many rows being imported into Excel. This video shows how to create an Excel <Named Range> and how to avoid common pitfalls related to […]
Understanding Excel rows – “Clear Contents” vs “Delete”
This article no longer applies to those using Outlook ‘2013 since the Excel file format is no longer supported. However, the information related to “deleted” versus “cleared” rows applies to many other scenarios outside of Outlook which may result in people getting unexpected results. How many times of you seen someone ask (or have even asked yourself) […]
How to import Excel data into Outlook
UPDATE: Starting with Outlook ‘2013, Excel (.xls) files are no longer supported in either the import or export process. The only options with ‘2013 are CSV text and Outlook PST files. If you are reading this then its likely you are or have encountered a problem importing from an Excel worksheet. One Excel feature that probably generates the most […]
