To export your Shopify products along with their metafields you'll need to perform two quick steps. First, have a worksheet that shows your Shopify products. Second, map one or more columns to show the data of the metafield(s) you want to export. Once this is done, just export the workbook and you'll be able to download all your products with their metafields data as an Excel file. Below are more details on each step.
Just like in Excel click the + button on the worksheets bar. You'll now be presented with a list of what Shopify data you'd like to sync to the new worksheet - products, orders, customers, etc. Select the Products option. The new worksheet will be added and you'll see your Shopify Products data starting to populate in it.
Now that we have our Products worksheet we need to get our metafields data to show up in it. All that's involve dis to configure columns to display the metafields you want to export. Here's how:
Now that we have our Products metafields data in our worksheet, let's export everything to an Excel file. Open the Workbook menu, using the button on the very top-right of the screen. Select the Export to .xlsx option. You'll be immediately prompted with the location where to save the Excel file on your computer. And that's it!