Convert plain text HTML to real HTML MySQL > Excel

Question

I have exported my table contents into a .csv file that contains a column for description. This column contains some HTML in plain text format that I cannot use.

Example:

"&lt;p&gt;&lt;strong&gt;Baby Rocking Horse Figurine&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;This cuddly bear is rocking back and forth into dreamland. 18 note movement.&lt;/p&gt;

&lt;p&gt;Tune: &lt;em&gt;&quot;Rock-A-Bye Baby&quot;&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;&lt;em&gt;5&quot; H&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;&amp;nbsp;&lt;/p&gt;

&lt;div id=&quot;image&quot;&gt;&lt;img id=&quot;zoomImage&quot; name=&quot;zoomImage&quot; src=&quot;http://www.sanfranciscomusicbox.com/core/media/media.nl?id=751799&amp;amp;c=969236&amp;amp;h=bc01a62cfec9b69d444c&quot; /&gt;&lt;/div&gt;
"

Desired Output:

"<p><strong>Baby Rocking Horse Figurine</strong></p> <p>This cuddly bear is rocking back and forth into dreamland. 18 note movement.</p> <p>Tune: <em>"Rock-A-Bye Baby"</em></p> <p><em>5" H</em></p> <p>&nbsp;</p> <div id="image"><img id="zoomImage" name="zoomImage" src="http://www.sanfranciscomusicbox.com/core/media/media.nl?id=751799&amp;c=969236&amp;h=bc01a62cfec9b69d444c" /></div> "

Is there a way to convert this into real HTML in bulk through excel or some other means? I have this data in MySQL as data type Text

Check this answer,you will get some idea. stackoverflow.com/questions/1842071/… — Sanjay
– Sanjay, Commented Jul 27, 2017 at 18:03
@alfrescolearner Thanks I was reviewing that answer also, as an alternative any way to export directly from MySQL in the proper format? The data is stored in my table as given in the example. — UserSN
– UserSN, Commented Jul 27, 2017 at 18:05
Also I don't need excel to actually render the HTML on the cell itself, rather just display proper HTML so I can re-import this somewhere else. — UserSN
– UserSN, Commented Jul 27, 2017 at 18:11

UserSN · Accepted Answer · 2017-07-27 18:53:55Z

0

Found SEOTools for Excel contains an HTMLDecode function you can use to acheive the desired result.

http://seotoolsforexcel.com/htmldecode/

answered Jul 27, 2017 at 18:53

UserSN

1,0232 gold badges14 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert plain text HTML to real HTML MySQL > Excel

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related