Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm running a query on SQL. Typically I can easily copy and paste the results from the query into Excel and it preserves the columns, rows etc.

However, in this case I'm selecting a bunch of emails and the bodies of those emails are html formatted. Every time I try and paste into Excel 2010, it completely messes it up since it's trying to be 'helpful' by parsing the html and converting img tags to images and table cells to Excel cells etc.

Is there some way I can have Excel be dumb and just paste my text without trying to figure out something clever to do with it?

I've tried using Paste Special. I've tried prepending a single quote to the start of the html body (someone said that tells Excel to treat the field as text and not parse it). I tried putting pipes | between each column, saving it to a text file and then importing the text file. No matter what I do, Excel keeps messing with the html.

Does anyone know how to paste html into Excel as just plain 'ol dumb text?

share|improve this question
    
Try unchecking all the delimiter options in the Data / Text-to-Columns dialogue box. –  chuff May 17 '13 at 1:00
    
If you mean in the wizard, already tried that. Besides, it's clearly not a delimiter issue. It's very obviously parsing the html. And As i said, it'll display <img> tags as the actual image. splitting up table cells into excel cells. So it's definitely trying to do something clever with the html. I just want it to paste everything as text and not try and do anything 'helpful' for me. –  merk May 18 '13 at 1:37
    
Did you also check the 'Text' option in Step 3 of the Text Import Wizard? –  Jerry May 22 '13 at 15:36
    
Yes i did, had no effect –  merk May 23 '13 at 19:03
    
Did you ever find a solution for this? I am trying to do this exact thing now! –  franglais Jun 3 at 11:54

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.