https://community.esri.com/t5/arcgis-pro-questions/producing-an-export-with-layers-in-the-order-i-set/m-p/1023271#M36881 <P>James - you're correct that the reordered fields do not "stick" when you export them to an Excel file.&nbsp; One way to do this is to run the <A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/conversion/feature-class-to-feature-class.htm#GUID-A6A0DE52-FE1E-4DE6-9D10-004831253839" target="_self">Feature Class to Feature Class GP tool</A> and reorder the fields in the Field Map parameter.&nbsp; It's tricky though as I learned while testing.&nbsp; The top of the Field Map will be the last column in the table so reorder the fields bottom-up before running the tool.&nbsp; Meaning the last record in the Field Map parameter is the first column, followed by the 2nd, 3rd, 4th and so on.&nbsp; Took me two tries to figure this out.<BR /><BR />It creates a new feature class in your geodatabase so now you have a duplicate.&nbsp; You may or may not want to keep the original feature class.&nbsp; Then export the Table to Excel again.&nbsp; The Excel file should show the reordered fields as you set them.</P> Thu, 04 Feb 2021 02:33:01 GMT Robert_LeClair 2021-02-04T02:33:01Z https://community.esri.com/t5/arcgis-pro-questions/producing-an-export-with-layers-in-the-order-i-set/m-p/1023066#M36847 <P>Hello Everyone,</P><P>&nbsp;</P><P>I have been doing some exports to excel and before i export an attribute table to excel. I move the fields into the order I want them to be in. But once I open the table in excel all the fields are not where I set them.</P><P>Is there a way to tell ArcPro what fields and what order I want to export an attribute table in or will I just have to fix the column order in excel manually?</P><P>Any help would be greatly appreciated!</P> Wed, 03 Feb 2021 17:31:52 GMT https://community.esri.com/t5/arcgis-pro-questions/producing-an-export-with-layers-in-the-order-i-set/m-p/1023066#M36847 JamesWenyon 2021-02-03T17:31:52Z https://community.esri.com/t5/arcgis-pro-questions/producing-an-export-with-layers-in-the-order-i-set/m-p/1023271#M36881 <P>James - you're correct that the reordered fields do not "stick" when you export them to an Excel file.&nbsp; One way to do this is to run the <A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/conversion/feature-class-to-feature-class.htm#GUID-A6A0DE52-FE1E-4DE6-9D10-004831253839" target="_self">Feature Class to Feature Class GP tool</A> and reorder the fields in the Field Map parameter.&nbsp; It's tricky though as I learned while testing.&nbsp; The top of the Field Map will be the last column in the table so reorder the fields bottom-up before running the tool.&nbsp; Meaning the last record in the Field Map parameter is the first column, followed by the 2nd, 3rd, 4th and so on.&nbsp; Took me two tries to figure this out.<BR /><BR />It creates a new feature class in your geodatabase so now you have a duplicate.&nbsp; You may or may not want to keep the original feature class.&nbsp; Then export the Table to Excel again.&nbsp; The Excel file should show the reordered fields as you set them.</P> Thu, 04 Feb 2021 02:33:01 GMT https://community.esri.com/t5/arcgis-pro-questions/producing-an-export-with-layers-in-the-order-i-set/m-p/1023271#M36881 Robert_LeClair 2021-02-04T02:33:01Z