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?
ArcGIS: a b c d
MS Excel: d b a c