This question already has an answer here:

I am using the "Split by Attributes" tool in ArcGIS 10.6 to go through a shapefile, and split it up into new files by an attribute value. The tool runs perfectly, however I notice it only exports to DBF files. Shapefiles or CSVs would be preferable, but I don't see any option to specify the file type.

Can this be changed and, if not, is there a way to split up a shapefile by attribute value, and export it to .shp or .csv files?

marked as duplicate by PolyGeo arcgis-desktop Jun 4 at 0:47

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • According to the docs desktop.arcgis.com/en/arcmap/10.6/tools/analysis-toolbox/… Split by Attributes is a table tool and outputs tables, hence the dbf files with no shp. Are you executing this from the toolbox or from a python script? – Michael Stimson Jun 3 at 23:15
  • From the toolbox... I've been able to split by attributes to shapefiles in the past but have been unable to replicate it. Maybe I was using a different tool that I can't recall – Wincow Jun 4 at 0:07

Without testing, I am unsure whether this tool can take an input of a shapefile, and create shapefiles as output on its own.

If it cannot, then you could use ModelBuilder or ArcPy to convert your shapefile to a file geodatabase feature class, and then when Split By Attributes splits it into feature classes in your target workspace (I would use a file geodatabase here), iterate through those feature classes, and convert them to shapefiles.

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