Order/Coupon/Subscription import export for WooCommerce export orders in an efficient manner. The plugin may export products in an order as different line items. As a result, each line item contains all the details about that product in a single column.

Export line items into separate columns
Alternatively, to export the order line items into separate columns:
- Firstly, follow the steps mentioned in Export Orders.
- On reaching step 5, select ‘Yes’, for the feature: Export line items into separate columns.
- Click on Export to finish.
On downloading the exported file, we will get the line items in separate columns as shown:

Export line items into separate rows
To export the order line items into separate rows:
- Firstly, follow the steps mentioned in Export Orders.
- On reaching step 5, select ‘Yes’, for the feature: Export line items into separate rows.
- Click on Export to finish.
On downloading the exported file, we will get the line items in separate rows as shown:

For more details, refer: How to Import and Export WooCommerce Orders.
- Was this article helpful?
- Yes, thanks!Not really
Comments (4)
Helena Boitsova
January 12, 2023
Can we export more info about each product? Like it’s attributes?
Alan
January 27, 2023
Hi,
By default, there is no option to export the product attributes however we can check the possibility of providing a custom code snippet for the pro version of the plugin to export the attribute data in the order export file.
Kiara Walbrook
January 5, 2022
I don’t have the option to export the orders in separate columns. It only gives me the default or single row line items. How do I get to export the order line items in separate columns?
Kiara
January 5, 2022
Nevermind, I found it.