Select to view content in your preferred language

Shapefile from an Excel spreadsheet

598
3
05-04-2020 02:38 PM
StwarthPiedra_Bonilla
New Contributor

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!

0 Kudos
3 Replies
DanPatterson_Retired
MVP Emeritus

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.

0 Kudos
StwarthPiedra_Bonilla
New Contributor

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!

0 Kudos
DanPatterson_Retired
MVP Emeritus

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

0 Kudos