Upload and share Excel sheet on ArcGIS Portal

Question

Hi,

I have an assignment which requires me to upload and publish an excel sheet on my organisation's ArcGIS Portal directly but I have yet to find a way to upload my excel sheet onto the portal even though this link showed that Excel sheets could be shared onto the portal directly What can you add to your portal?—Portal for ArcGIS | ArcGIS Enterprise . I have tried to upload my excel sheet to the portal using My Content>Add item>From My computer>Excel file but could not add it into my basemap.I am currently using Excel 2016 and I have added a few screenshots for your reference thank you!

-Cheryl

JayantaPoddar · Answer

Hi Cheryl,

How do you expect to create the point layer from the CSV without the Lat/Lon fields? They are the most essential fields for creating the points.

There is another way where the points will be generated from the address field (Full Address preferred). But you will need to Configure the portal to geocode addresses—Portal for ArcGIS (10.5.x) | ArcGIS Enterprise .

Note: The service credits consumed by Geocoding Capability is huge (40 credits per 1000 geocodes). Use lat/lon fields in Decimal Degree values, if you don't want to spend so much credits.

ArcGIS Online | Service Credits

CherylLim · Answer

Hi,

Thank you very much for the tip. I have reflected the problem to my supervisor and I have been told to ignore the lat/long fields instead due to some issues with the lon/lat values. I have converted my excel sheet into a csv file so as to use the Add layers function in the map viewer, however, I got another error this time round.

I have 870 features in the CSV file and the lon/lat values have been removed.

This is the new error I received when I tried to add my CSV file as a layer.

Thank you so much for your kind assistance and apologies for the long questions as I am really new to ArcGIS portal and I am quite lost right now.

-Cheryl

JayantaPoddar · Answer

You need to define the lat/lon values that correspond to GCS_WGS_1984 (Decimal Degrees). The values in your excel sheet looks to be in Projected Coordinate System (Meters).