Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I am trying to create a tool using ArcGIS ModelBuilder (v9.3) that will allow me to import an Excel file, and output it as a shapefile in a coordinate system of my choice - or, if choosing the CRS is not an option, in WGS84.

I have set the input dataset (as part of the model), but can't seem to find a tool to facilitate the import. I have an ArcView licence.

share|improve this question

2 Answers 2

up vote 1 down vote accepted

In ArcGIS 10 there is a toolbox called Make XY Event Layer. It's found in Data Management Tools > Layers and Table Views in the main Arc Toolbox. This creates a temporary layer that you should be able to export to a feature class.

I don't have 9.3 to test, but I think the same tool is available in that version.

share|improve this answer
    
Thanks Kevin - the tool does exist in 9.3 and the model is working fine; thanks all for your help. –  the_bonze May 10 '12 at 14:11

You can import your xls file into Model Builder using the Make XY Evemt Layer tool. You can then use the Feature Class to Feature Class tool to convert the event layer to a shapefile.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.