Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

It might be the very basic question..

I have lots of column in shape file and I need few columns.

Therefore, I am trying to select using control and trying to export but it exports all the columns (I did not get “selected records “option while exporting)

Image 1 :Selected columns

-Tried using Arc tool-box (Data management tools and few more) but not getting suitable option

Researching on Google and going through following posts

Post 1 ,Post 2 (I do not think its proper way)

So any help will be great !! Thanks in advance : )

share|improve this question
up vote 5 down vote accepted

Use can use the ArcToolbox > Data Management Tools > Fields > Delete Field geoprocessing tool. Your shapefile can be specified in the Input Table parameter. Then just choose what fields will be deleted. Remember to create a copy of the shapefile first, so you have original data!

share|improve this answer
Let me check that..looks like its smarter way : ) – Sunil Mar 13 '13 at 9:28
Just in case you don't need to create a new shapefile on disk and reuse it, consider the Layer Properties window > Fields tab to choose what fields will be visible. If you need to perform such a procedure before running some analysis, you might use the Make Feature Layer too (Data Management Tools > Layers and Table Views). – Alex Tereshenkov Mar 13 '13 at 9:28
thanks for smart solution. My problem is resolved : ) – Sunil Mar 13 '13 at 9:51

You can turn Fields off by right-clicking on them in the table view and selecting "Turn Field off".

Or you can do it in the dataset properties -> "Fields" tab by unchecking the checkboxes next to the field name.

Fields that are turned off won´t be exported.

share|improve this answer
thanks for the reply.. – Sunil Mar 13 '13 at 9:53

Please try in ModellBuilder: Use tool Make Table View (Data Management) to create a subset of fields. Then use Copy Rows (Data Management) to export these fields to new table.

share|improve this answer
thanks for the reply – Sunil Mar 13 '13 at 9:52

Your Answer


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.