Problem: Unable to publish a hosted feature layer using an Excel file to ArcGIS Online
Attempts to upload a Microsoft Excel (.xlsx) file and publish it as a hosted feature layer in ArcGIS Online return the following error message on the layer's item details page:
On the My Content page, the Excel file is uploaded successfully.
However, when clicking the hosted feature layer of the uploaded file, the item details page shows the options to open the layer in Map Viewer, Scene Viewer, and ArcGIS Desktop are unavailable.
The data in the .xlsx file cannot be read accurately by ArcGIS Online in the current format.
Solution or Workaround
To resolve the issue, convert the Excel file format to a comma-separated values (CSV) text file (.csv) format before uploading it to ArcGIS Online.
- In the Excel file, click File > Save As.
- On the Save As page, click the desired folder.
- In the Save As window, click the Save as type drop-down menu, and select CSV (Comma delimited). Click Save.
- Upload the CSV file to ArcGIS Online to publish it as a layer. Refer to ArcGIS Online: Add files from your device for instructions.
Last Published: 9/29/2021
Article ID: 000026503
Software: ArcGIS Online 9.3, 9.2, 9.1