ERROR

Duplicate field names are not allowed

Last Published: January 5, 2024

Error Message

Attempting to upload a CSV file and selecting the 'Add <file name> and create a hosted feature layer or table' option in ArcGIS Online fails and returns the following error message:

Error:
Duplicate field names
Duplicate field names are not allowed.
The error message "Duplicate field names are not allowed" in the New item window.

Cause

Two or more fields in the CSV file share the same name or are duplicates. Field names of hosted feature layers must be unique and not identical to one another.

Solution or Workaround

  1. Open the CSV file in Microsoft Excel.
  2. Navigate to the relative field and apply either of the following options based on the circumstances.
    • For fields with the same name, double-click one of the fields and rename the field. In the example below, the duplicate field 'DATE' is renamed to 'NEW_DATE'.
The newly named field.
    • For duplicate fields with duplicated values, right-click one of the field headers and select Delete.
The Delete option in Microsoft Excel after right-clicking the field column header.
Note: 
For complex tabulated data, refer to Microsoft: Find and remove duplicates to locate and delete duplicates.
  1. Save the CSV file.
  2. Upload the CSV file to ArcGIS Online. Refer to ArcGIS Online: Publish a CSV file for instructions.

Article ID:000031736

Software:
  • ArcGIS Online

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic