Not sure where to post this it might be a WORD or EXCEL subject? anyway...
I can log on to a local library on line account and see all the books loaned over a period of time. They come on several pages (screenshot). I can select copy and paste these titles into notepad and save as txt files.
I'm guessing there must be an easy way to transfer these txt files into a spreadsheet or something. What I want to do is to have a searchable record so that I can search for a particular author or book title to see if has been read in the past. Any hints as to how to go about this please?
making a searchable list (help please)
-
- 3StarLounger
- Posts: 246
- Joined: 09 Feb 2010, 09:01
- Location: Southeast England
making a searchable list (help please)
You do not have the required permissions to view the files attached to this post.
Jeff
-
- Administrator
- Posts: 78379
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: making a searchable list (help please)
Try copying the list from the website and pasting it directly into an Excel worksheet. Does that produce a reasonable result?
Best wishes,
Hans
Hans
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: making a searchable list (help please)
I agree with Hans. If data is in a table structure, it typically will parse correctly when transferred to Excel.
Copy/paste will be the easiest, but alternatively, you could use the Data ribbon in Excel to import the web page. In the resulting import dialog, navigate to the online page, mark it using the built in options and then import. Another option, though possibly unfamiliar to you is using Power Query (a powerful data extraction tool built into Excel 2016>) to collect the data.
Copy/paste will be the easiest, but alternatively, you could use the Data ribbon in Excel to import the web page. In the resulting import dialog, navigate to the online page, mark it using the built in options and then import. Another option, though possibly unfamiliar to you is using Power Query (a powerful data extraction tool built into Excel 2016>) to collect the data.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 3StarLounger
- Posts: 246
- Joined: 09 Feb 2010, 09:01
- Location: Southeast England
Re: making a searchable list (help please)
So easy. that's all I had to do. Don't know why I didn't try the obvious just getting lazy I supposeHansV wrote:Try copying the list from the website and pasting it directly into an Excel worksheet. Does that produce a reasonable result?
Jeff
-
- 3StarLounger
- Posts: 246
- Joined: 09 Feb 2010, 09:01
- Location: Southeast England
Re: making a searchable list (help please)
Copy/paste works adequately for what I want and indeed Power Query is completely unfamiliar to me. All I want is a record and maybe list in alphabetical or date order. Thanks for the input.Rudi wrote:I agree with Hans. If data is in a table structure, it typically will parse correctly when transferred to Excel.
Copy/paste will be the easiest, but alternatively, you could use the Data ribbon in Excel to import the web page. In the resulting import dialog, navigate to the online page, mark it using the built in options and then import. Another option, though possibly unfamiliar to you is using Power Query (a powerful data extraction tool built into Excel 2016>) to collect the data.
Jeff