topic Error Importing Excel table in ArcGIS Pro Questions

Error Importing Excel table

SamirMohallem — Thu, 04 Feb 2021 11:08:50 GMT

I'm having problems with ARCGIS PRO (2.7.1) executing a simple table X,Y point data process. I've tried with different formats (xlsx, csv, xls) but the error continue, like image below. Could you help me find out what the error is?

Part of the database (48 rows in total)

Thanks

Samir

Re: Error Importing Excel table

DanPatterson — Thu, 04 Feb 2021 11:22:08 GMT

does this include the records that are marked as an issue?

Re: Error Importing Excel table

JayantaPoddar — Thu, 04 Feb 2021 12:53:33 GMT

Looks like you are defining a Geographic Coordinate System (GCS_WGS_1984) as the spatial reference. This coordinate system assumes that your XY units are in Decimal Degrees. But in reality, the units of the Easting/Northing are in Meters or Feet.

Please select an appropriate Projected Coordinate System as the spatial reference while running the tool. In case you are unsure about the appropriate PCS, you may attach a sample CSV of the above data and let us know your study area.

Re: Error Importing Excel table

BranislavBlagojevic — Mon, 08 Feb 2021 17:27:14 GMT

Only change Drillhole Name in DrillholeName (eliminate blank space).