How can I paste a table of data into Excel from a MSIE / web browser?

S

ship

Hi

Is there any way to paste out of a table on a web page,
*straight* into msExcel2002, but without taking microsoft all the
friggin Micro$oft formatting with it.

I just want the data, but I also want the table
structure!

Copying out of Firefox into Excel and table structure
is lost - it just splurges out in a single line; and copying out of
MSIE (latest) and either all sorts of formatting comes with it, or the
table structure is lost.

So at present I paste out of MSIE into Excel, save as tab-delimited
text. Close. Re-open. Have to scroll down to find the correct format
out of drop-down list, next, next and then finish.... All do-able but
I'm getting very bored of having to KEEP do so many steps!



Ship
Shiperton Henethe

P.S.
-Does Excel2003 have a better solution?
-Or maybe there's a pluggin I can download from somewhere?

[END]
 
D

Don Guillett

Try right click in the area of the table and see if
"import to excel" is an option
 
G

GeorgeB

Is there any way to paste out of a table on a web page,
*straight* into msExcel2002, but without taking microsoft all the
friggin Micro$oft formatting with it.

I just want the data, but I also want the table
structure!
Click to expand...

I've had pretty good luck with paste special and not selecting html.
Comment ... Excel 2000, not 2003.
Copying out of Firefox into Excel and table structure
is lost - it just splurges out in a single line; and copying out of
MSIE (latest) and either all sorts of formatting comes with it, or the
table structure is lost.
Click to expand...

I've not tried Firefox, but with Mozilla, paste special works with
most table data

I asked a related question and got an interesting reply I haven't
tried yet; mine was some data coming in as dates ... suggestion was to
paste into notepad, save as text, import with control ... yes, I did
read your "straight" and understand this isn't the answer you want,
but it may help as a workaround.

George
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I paste WITHOUT cell references changing (and without usingabsolute cell addresses) [EXCEL20 8
How can I cut data out of HTML table, into msExcel and just take the data & columns? (but NOT the fo 22
Moving a bunch of data 1
Is there a way to paste test into a PPT table from Excel and not copyExcel formatting? 1
Cannot copy and paste data from web pages directly into Excel 1
How do I change the default "file origin" when opening a tab delimited text file? 0
How do I import raw CSV data into an HTML Table ? (i.e. without the f***ing Microsoft Excel formatt 4
How do I trash HTML links en-masse from a spreadsheet? (msExcel 2002) 4

Top