Google Answers Logo
View Question
 
Q: How to drag text from a webpage into a spreadsheet? ( No Answer,   2 Comments )
Question  
Subject: How to drag text from a webpage into a spreadsheet?
Category: Computers > Software
Asked by: stoney1545-ga
List Price: $10.00
Posted: 16 May 2006 18:59 PDT
Expires: 15 Jun 2006 18:59 PDT
Question ID: 729589
I currently spend alot of time generating statistics on a website and
copying and pasting the stats into a spreadsheet on my desktop.  It is
really time consuming to highlight the text on the webpage, then hit
ALT/C or right click and select paste, go to the spreadsheet and paste
the text into my spreadsheet.

Do you know of anyway or any type of software that will allow me to
highlight text from a webpage and drag it into a spreadsheet or any
other way or software to simplify this task?

Request for Question Clarification by sublime1-ga on 16 May 2006 21:01 PDT
There are a couple of options out of late that allow you to 
copy text from webpages and paste them into a website for 
later use. None of the results will be in the format of
a spreadsheet, though, so I won't post this as an answer
'til I hear back from you.

Google Notebook works in Firefox. You can download a browser
app that lets you select text in a website, r-click and send
it to your Google Notebook, where you can have multiple
'notebooks'. Only text is copied. Of course, the notebooks
are searchable.
://www.google.com/notebook/

eSnips offers similar functionality in IE, but I haven't 
gotten the r-click function to work yet. They're still in
beta. I understand it works for some people, so maybe it 
will for you.
http://www.esnips.com

Writely, which was recently acquired by Google, lets you copy
text, photos, and links from a website into a simulated online
word processor document. It's in beta, so you need to be invited
to collaborate on a document by a currently registered user in
order to get an account, at the moment. You get 1GB of storage
space, and can make pages public by publishing them to the web,
or send the contents to a blog.
http://www.writely.com

Let me know if this satisfies your interests...

sublime1-ga

Request for Question Clarification by sublime1-ga on 18 May 2006 01:50 PDT
Perhaps you could post a clarification regarding the value
of my response to your question.

A user's guide on this topic is on skermit-ga's site, here: 
http://www.christopherwu.net/google_answers/answer_guide.html#how_clarify 
 
sublime1-ga

Clarification of Question by stoney1545-ga on 18 May 2006 15:29 PDT
Hi there,

Yeah the 3 options you specified wouldnt work for me.  I do appreciate it though.  

Also it seems like i received responses from 2 other people.  I
actually went ahead and tried dragging the text into the spredsheet
and it worked.  It works but it seems like it takes up 2 rows in the
spreadsheet for some reason.

Im going to try the web query also.

Thanks
stoney154
Answer  
There is no answer at this time.

Comments  
Subject: Re: How to drag text from a webpage into a spreadsheet?
From: hammer-ga on 17 May 2006 13:09 PDT
 
For what it's worth, I can drag highlighted text from a webpage and
drop it into Excel without doing anything special.

- Hammer
Subject: Re: How to drag text from a webpage into a spreadsheet?
From: mostexcellent-ga on 18 May 2006 05:55 PDT
 
Me too. If this information is coming from the same source constantly
you might search for information on Excel Web Query. In Excel it is
under Data>Import then New Web Query.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy