homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

convert word table to excel table
Cut and paste just doesn't work

5+ Year Member

Msg#: 112 posted 11:57 pm on Oct 26, 2005 (gmt 0)

does anyone know how I can convert a word table in to excel spreadsheet?

Would much rather not have to re-enter all those details ....

cut and paste just distorts the excel table ..

I would be grateful for some ideas or indeed a solution ...

I need to maintain the columns ...



10+ Year Member

Msg#: 112 posted 8:46 am on Oct 27, 2005 (gmt 0)


There may be different (and better ways) and depending on what version of MS Office you are using, but one way is to:

* Save the Word document, that contains the table, as a web page

* In Excel, use the Data >> Import External Data >> New Web Query option.

This would allow you to select the table, from the web page, that you would like to import.




WebmasterWorld Senior Member suzyuk us a WebmasterWorld Top Contributor of All Time 10+ Year Member

Msg#: 112 posted 8:52 am on Oct 27, 2005 (gmt 0)

Copy/Paste should work,

When pasting try right click and select Paste Special, select Text as the paste option

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved