First, navigate to Tools › Export and choose the type of data that you want to export.
Data is divided into various article types by WordPress, including posts, pages,
WooCommerce products, and real estate properties.
By choosing it here, you can export any custom post category or taxonomy.
Go to Microsoft Excel > Blank Workbook
Select Data tab > Choose Data from another source > Choose our XML file created.