AnsweredAssumed Answered

Editing Shapefile databases in MS Excel 97-2003

Question asked by DanBear on Dec 5, 2018
Latest reply on Dec 5, 2018 by Dan_Patterson

I do an extensive amount of editing of shapefile databases (.dbf) format for Quality Control with numerous attributes  in MS Excel for compatibility with shapefiles in ArcGIS 10.6.x.    While I clearly see the need for maintaining a high quality end product (shapefile to be used with other applications) this is also frustrating and is leads to a larger amount of time for achieving my end result.


I have a number of questions for this subject, but one of them is this:


How do I maintain the same order of fields in MS Excel 97-2003 that I have in the .dbf in ArcGIS?


As in:

ArcGIS:  a b c d


MS Excel:  d b a c


Thank you,


Mr. Excel