Clean extra excel-export nonsense?

  • Thread starter Thread starter Mike Jacoubowsky
  • Start date Start date
M

Mike Jacoubowsky

When you export from Excel to HTML, you get a ton of extra garbage you don't
need, including cell formatting instructions that mess things up badly
(particularly font formatting). You can manually strip them out, but is
there a way to export just the data and columns without formatting? Or an
easy way to strip out all the stuff afterward?

Thanks-

--Mike Jacoubowsky
Chain Reaction Bicycles
www.ChainReaction.com
Redwood City & Los Altos, CA USA
 
Here's another way, posted here by Cheryl Wise, that doesn't rely on
having a gmail account; I just tried it and it works:

In Excel save as comma separated file.
Open in notepad, copy
Then paste into FrontPage.
Nest highlight the text in FrontPage and use Tables, Convert Text to Table
Click to expand...

Thanks, I'll give that a try!

But sure would be nice if Excel could do it cleanly by itself. I understand
the concept; they're trying to, as faithfully as possible, reproduce
everything they can. But sometimes you're just trying to build a table and
add data in Excel because it's convenient, or because some other application
exports to it, and not directly to a web editor. And when manually cleaning
out the garbage, I'm not good enough with ram HTML code to make sure I'm not
messing something up.

--Mike-- Chain Reaction Bicycles
www.ChainReactionBicycles.com
 
Back
Top