1

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.

2 Answers 2

1

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.

1
  • Thanks Kevin - the tool does exist in 9.3 and the model is working fine; thanks all for your help.
    – the_bonze
    Commented May 10, 2012 at 14:11
0

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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