What is the best way to export data with the order?

We have many addon fields on our product, so we need a way to export the orders and be able to parse and collect the data from these fields.
Normal built-in exporting from WordPress and Woo doesn’t work at all, the exports don’t include the meta data.

I installed an exporting plugin that gives me the variation meta data, but all the data is in one column of the export, with values separated by pipe character.

If I’m working in Excel, I know I can do things like “Text to Columns”, but if I do this for all the orders at once, there’s no guarantee the same data will line up on the same columns across all orders.

Not only that, but the data is formatted oddly, with HTML in the data. For example, one of our values, that has a price, might look like this:

<span id="118">Arrive Date</div>: 3-Nights (<span class="woocommerce-Price-amount amount"><span class="woocommerce-Price-currencySymbol">$</span>100.00</span>)

This doesn’t make sense as a value, why does it include all this HTML in the value itself? What I would prefer in my exports is for a column to be labeled “Arrive Date” and then the value field say “3-Nights”, which is what they bought. And likewise, for all my other addon fields to have a column with their name, and then the value in the cell.
Is this even possible?

I’m only curious why the values are stored with HTML, here is another shorter example:
<span id="41">T-shirt</div>: Small
Why does the value have a span and a closing div stored in the database? How come it’s just not the title “T-shirt” followed by data “Small”?

Regardless, the most important thing for me for exports is seeing all my addon questions as spreadsheet columns, with the answers in the cell with each order row. Is this possible? What tool do you suggest so we can export our orders and see all the addon selections in a clean way for parsing?