

Added some new contacts (rows) to my Excel spreadsheet but these won’t import.Some columns are not appearing when mapping fields.It’s only importing “x” number of contacts from my Excel file no matter what I do.Ended up with all kinds of blank contacts in the Outlook folder.When I try to import it keeps asking me for a “named range”.

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 questions (and problems) is “Named Ranges” which include the following: The only options with ‘2013 are CSV text and Outlook PST files. UPDATE: Starting with Outlook ‘2013, Excel (.xls) files are no longer supported in either the import or export process.
