I need to import data from a webpage into excel spreadsheet. Currently I cut and paste but this very tedious and formating the data to fit into spreadsheet is a hell lot of trouble. I 've heard about XML, but I'm not sure if I can use it to extract data into my spreadsheet(since this can only be done on a web server running the webpage). I need a solution that would enable me accomplish this task, be it XML or any other program. Thank you in advance.

I don't think XML is what you need here...What is the website? We'll have to see it to give you any meaningful advice. -SN

XML would be ideal (i.e. best way to go). Involving a half-baked XML solution probably will not do anything for you. You really need the webpage to conform to your schema for XML to be of any real benefit. Even then, you need an intermediate process (unless MSOffice has a native import for XML - then maybe use an MS template for the webpage). It will all boil down to some script somewhere, packaged or otherwise. Someone else would recommend Visual Basic at this point. The second best way, is to format the webpage in xls (or at least prepare it). Even better is to do this straight from the database with a query. Like so. Conveniently, this recent tutorial is right here for you to follow. It goes into the process. A setup of PHP/MySQL/Apache is very standard and the simplest kind of overhead. The hardest part is filling the database (make a script to insert data - find this somewhere online) and playing with the output. The data of course does not have to come from a database. It could be straight HTML from another file (example). The ASP way. A commerical conversion tool.

anonproxy does a great job helping out our poor souls. :-D Albatros, you could also give sockets a shot. but seems anonproxy has very nice how-to links handy to do it the ways he mentioned. (: