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

Do you have a Gmail account? This:
http://consumingexperience.blogspot....d-convert.html
works really well. After you paste the HTML into your page in Code view,
switch back to Design View, Select All and Remove Formatting - the end
result is pretty clean.

If you don't have a Gmail account let me know - I'll send you an invite.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


"Mike Jacoubowsky" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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

http://groups-beta.google.com/group/...eadsheet&hl=en


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


"Mike Jacoubowsky" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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

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