Unable to upload an Excel file in ArcGIS Online

Last Published: September 1, 2020


When attempting to upload a Microsoft Excel (.xlsx) file in ArcGIS Online, the action fails and returns the following error message:

An item with the same key has already been added.
Image of the error message


The following are known causes for the issue:

  • Two or more fields in the Excel file have the same name.
  • The field name in the Excel file contains special characters or spaces.

Solution or Workaround

Depending on the cause, use one of the options below to resolve the issue.

Rename or remove the duplicate field

  • In Microsoft Excel, browse to the fields with the same name, and rename one of them. In the example below, the duplicate field (SITE_ID) is renamed to SITE_ID_01.
Image of an Excel sheet in Microsoft Excel
  • Remove the column if the field of the same name is a duplicate.

Ensure the field names do not include special characters or spaces

  • Delete special characters such as slash (/) from the field names.
  • Replace spaces in the field names with underscores.

Convert the Excel file to a CSV file

  1. Open the Excel file.
  2. Click File > Save As.
  3. In the drop-down menu, select the .csv file format, and click Save.
Image of selecting CSV file type in Microsoft Excel

Article ID:000023836

  • ArcGIS Online

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options