Import Contacts from Excel to Outlook Error No Named Ranges – Fix the Issue

SysToolsData Expert - Recovery,Backup,Migration
SysTools Simplifying Technology Leading  in Data Recovery, Data Migration & Data Backup With 200+ Solutions.
Want to troubleshoot the issue of importing contacts from Excel to Outlook error No Named Ranges?? Resolve this problem and get the error-free solution to resolve the “No Named Ranges” error in a hassle-free way.

Are you facing “No Named Ranges” error when importing contacts from Excel to Outlook? Then, this guide will definitely help you to resolve the No Named Ranges error when importing to Outlook in a proper way.

Microsoft Excel spreadsheets are used by professionals as well as home-users to maintain data in tabular form. Contacts are one of the common things that usually maintained in Excel. But, sometimes users wish to move contacts from Excel environment to other email application for the further use. However, when users import contacts from Excel to Outlook, the error "No Named Ranges" occurs; this error will truncate the process. Moreover, the error message looks like this:

The Microsoft Excel file has no named ranges. Use Microsoft Excel to name the range of data you want to import.

Instant Solution: If you want a quick and hassle-free solution to export contact list from Excel to Outlook, then it is suggested to go for SysTools Excel to Outlook Converter application.

Resolve - Import Contacts from Excel to Outlook Error No Named Ranges


Most users do not know about “Named Ranges” in Excel sheets and that makes the whole situation worse. Basically, Named Ranges is an appropriate name provided to the Excel sheet which is grouped together. It enhances readability and makes the work more facile in a spreadsheet. After Considering this error, in this blog, we will cover the suitable approaches that provide a satisfactory result to end-users. Before that, let us have a look at a real-life scenario to clear the situation in detail.

User Query

"My boss share me Excel file with contact information. And, when I open the file in MS Excel all schemas are at a right place on the apex of each column. But, when I try to import the excel file in my Outlook email profile, it displays “The MS Excel file has no named ranges. Use Excel to name the range of data you want to import”. I searched about “named ranges” in the Excel program, but I did not find any such thing. Can someone has any methods that rid of this error, please suggest me"

How to Create Named Range in Spreadsheet

As mentioned above, that Named Range is a dynamic feature in MS Excel. It can make formulas a lot facile to create and maintain. Now, to create a named range in MS Excel, follow these mentioned steps:

  1. Launch the Microsoft Excel application in your system
  2. Open the contacts spreadsheet on the Excel
  3. Now, select the cell range including column headers that you want to import in Outlook profile. (Note: Do not select the entire column at one. By this, you will automatically select the empty cells beneath it. It will create lots of devoid contacts while importing into Outlook.)
  4. In MS Excel 2003 and older versions, select Insert >> Name >> Define
  5. In MS Excel 2007/2010/2013/2016, select Tab formulas >> section: Defined names >> Define name
  6. Now, provide a name for the range that you specified for the workbook. Here, you can write contacts in the names. Then, click on Add
  7. After that, save and close the workbook

After creating a Named Range in Excel one can easily troubleshoot the above issue to import contacts from Excel to Outlook error No Named Ranges occurs. Read the next section to know the solution.

How to Resolve “No Named Ranges” Error in Outlook 2013/2016

It is evident from the above that No Named Range error generates while user exporting data from excel to Outlook environment. So, to avoid this error, users can perform following instructions:

  • Save the Excel sheet as a Comma Separated Values (or CSV) format in place of creating a named range for contacts file. And import the CSV file into the Outlook environment. Hence, “no named range error” will not arise. It is a suitable way to use excel contacts in Outlook 2013 or 2016. This Outlook versions are no longer able to support .xls file but can allow the CSV files in it.
  • Users can also provide a proper name range to the spreadsheet. For this, follow the above section in which creation of named range is mentioned. After that, export into Outlook domain, no “named ranges” error will generate.

If a user is a novice or non-technical, then this manual guide makes the task to import contacts from Excel to Outlook more complex. In that case, they can use third-party software to transfer Excel contacts into an Outlook email profile without error.

Fix "Named Range" Error Within Few Clicks

This blog suggests SysTools Excel to Outlook converter utility for those users who want to transfer XLS spreadsheet to Outlook contacts in an error-free way. It is one of the best applications to export Excel contacts to an Outlook address book without losing any data. The interesting part of this tool is that it eliminates empty mail addresses in contacts at the time of the conversion process. It also provides an option to create a distribution list in Outlook for all the Excel contacts. Also, the ergonomic design of software makes the complete process so fluent. Moreover, the tool supports Windows 10 and all its below versions smoothly.

Time to Conclude

In this blog, we have suggested the most appropriate and affable solutions that can fix the “No Named Ranges Error” while importing excel contacts to Outlook email account. Here, every method has its own assets to provide satisfactory results to end-users. Depending on the conditions, when a user tries to import contacts from Excel to Outlook and a No Named Ranges error occurs, users can adopt any of the solutions to rectify the error proficiently.

SysToolsData Expert - Recovery,Backup,Migration
SysTools Simplifying Technology Leading  in Data Recovery, Data Migration & Data Backup With 200+ Solutions.

Comments (0)

Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.