I am working on importing data from shopify. One of the columns contain HTML and I want to remove this HTML before exporting the data to csv/ xls file. I am unable to find any way.

Here is the sample input containing html and I want HTML to be removed -

<div align="justify">
<p><meta charset="utf-8">lorem ipsum<strong>lorem ipsum</strong>lorem ipsum</p>
<p>lorem ipsum</p>
<p class="p1"><b>lorem ipsum</b>lorem ipsum</p>
<p class="p1"><b>lorem ipsum</b></p>
<p class="p1">lorem ipsum</p>
<p><a href="https://www.google.com"><span style="text-decoration: underline;"><em>lorem ipsum</em></span></a></p>

Can you please suggest some solution? Any pointers will be highly appreciated.