By default, the columns are ordered based on the code execution of the related Sheet Editor module. We have the serialized columns module, ACF module, etc.
That’s why the columns don’t follow the same order as the WP Editor.
For example. You can create 3 fields with Advanced Custom Field. One text field, one group of checkboxes, and one image. They won’t appear in the same order on the spreadsheet, the text and image columns will appear together and the group of checkboxes will appear after all the text columns.
You can sort the columns by going to settings > hide/display columns.