Thread: Getting data from non-table website

I need a way, anything quicker or perhaps more comfortable, than entering the data in a spreadsheet one by one, for entering data from a website, but on the site it is not in a table. Can this be done? The site is a php site, and there is a consistency in the page titles (could recreate them with formulas). The data could be extracted from the source code that a browser sees (not the php, of course, as I don't have access to that), as it is always preceded by it's type, that being unique (Cost: 3000 for example). Is there any way of doing this?
If it's not possible from the net, would it be possible from a saved version of the site (and if yes, how)?

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

I really don't see how attaching any kind of document would help in my case. I just need a method of importing data from the web. They're all numbers, always preceded by some kind of descriptor, something like 'ThisCost 3000' and 'ThatCost 4000' and of the like. In the website's code it would look like

<span class="level">
<span class="textlabel">
"ThisCost"
</span>
"3000"
</span>

I don't have any "real workbook", aside from a blank one, in which the data can go in any order. I can work with it if it's in Excel in any form, I just need it to get in Excel.

Bump for still waiting for some help.

Sorry, but I don't think there is enough information to answer your question. You need to be more specific. Maybe provide a suitable web site link to a sample page and then give an Excel file as an example of what you would like to see as the output.