WP Sheet Editor shows all columns based on the fields it finds on the database. There are rare cases where you open the spreadsheet, and you can’t see any data on the columns, e.g you know the orders have the field “billing address” filled in, and you don’t see any value on the column “Billing Address”.
Solution to columns not showing data
The most common way to solve this issue, is to go to the Spreadsheet > Settings > Advanced Settings > Solution to weird errors > Deactivate the Data Prefetch
Note: This issue doesn’t occur on all sites, it just happens on some specific server settings. Deactivating the data prefetch is not going to affect the plugin performance and it won’t affect any functionality.