-2

I haven't taken a GIS course in over a year, so I think I've forgotten everything.

I recently made a long (300+) list of data entries on an Excel file. Rather than sort through it by hand, is there a program to help me?

My computer has access to arcgis, qgis, Tableu, cartodb, and a couple more.

PolyGeo
  • 65,136
  • 29
  • 109
  • 338
Mareykan
  • 181
  • 1
  • 2
  • 9
  • 1
    You can even use Excel for sorting purposes. Have you tried "Sort&Filter" - "Custom Sort"? – Ayda Aktas Jun 12 '17 at 16:33
  • 1
    or load into qgis/arcgis to sort/filter spatially. – Mapperz Jun 12 '17 at 17:45
  • 1
    I have voted to close this as Off-Topic as there doesn't appear to be a GIS component to your question. If there is a GIS component please [edit] your question to expand with more information. – Midavalo Jun 12 '17 at 17:45

1 Answers1

1

For basic edits, it sounds like you are looking for the "Sort & Filter" tool in Excel, in the top right corner of the screen.

enter image description here

If your data is spatial data (lat-long or easting-westing values), you can display it in ArcMap. Add the Excel file by clicking on the "Add Data" button in the middle of the Arc toolbar. Navigate to and add the data. Then right click on the table and click 'Display XY data.' Your x field should be Easting/Longitude, y should be Northing/Latitude."

Now that your data is displayed you can do all kinds of automatic edits based on where the data is etc.

enter image description here

If you give us more specific information about exactly what your data is and how you want to edit it, we can give more specific advice.

J.W. Powell
  • 338
  • 2
  • 5
  • 16