topic Re: Shapefile from an Excel spreadsheet in ArcGIS Pro Questions

Shapefile from an Excel spreadsheet

StwarthPiedra_Bonilla — Mon, 04 May 2020 21:38:25 GMT

So I have a project for a class, I used an spider-type program to gather data from a real estate-selling webpage. So each row is a house. It contains data on the price, size number of bedrooms, and the coordinates (which the spider collected from the adds that were linked to google maps. I want to import that into Arcgis Pro. I need a shapefile that consists of points (each house will be a point).
Thanks in advance!

Re: Shapefile from an Excel spreadsheet

DanPatterson_Retired — Mon, 04 May 2020 21:52:19 GMT

Excel To Table—Conversion toolbox | Documentation

Make XY Event Layer—Data Management toolbox | Documentation

is one way

Then wrap it up

You can export this event layer to a feature class on disk using the Copy Features, Feature to Point, or Feature Class to Feature Class tool.

Re: Shapefile from an Excel spreadsheet

StwarthPiedra_Bonilla — Mon, 04 May 2020 22:04:30 GMT

Ok, if I get it right, I need to run those steps in a Python IDE, right?

What I don't finish getting is that Excel to Table return a table in .gdb right?
But the Make XY Event Layer requires a table in a .dbf, so.... I don´t know if it works that way.

Also, is a layer the same as a shapefile? Can I work them the same?

Thank you very much for answering!

Re: Shapefile from an Excel spreadsheet

DanPatterson_Retired — Mon, 04 May 2020 23:35:38 GMT

make XY event layer can use the table you created in the first step.

To create a shapefile, use one of the 3 options listed in the quote.

Make sure that the shapefile's destination is a folder not a gdb, and specify the *.shp file extension