"What are you up to?"
LIS Links
First and Largest Academic Social Network of LIS Professionals in India
LIS Links Becoming More Social
Birthdays
Birthdays Today
Latest Activity
National Conference on “Intelligent and Smart Digital Library (ISDL-2026)” at IIT Kharagpur at IIT Kharagpur
December 21, 2026 at 9am to December 22, 2026 at 6pm
7th National Conference on Management of Modern Libraries (NACML– 2027) on “Contemporary Approaches to Libraries: Emerging Technologies, Services, and Skills at Manipal Academy of Higher Education (MAHE), Manipal, Karnataka
January 29, 2027 at 10am to January 30, 2027 at 5pm
One-Day National Seminar on Artificial Intelligence and Academic Libraries: Issues and Opportunities in the 21st Century at kongu arts and science college
October 28, 2026 from 9:30am to 4:30pm
IASLIC 31st National Seminar 2026 on Adaptive Libraries: Resilience and Innovation at Bansuri Guru Auditorium, Institute of Technical Education & Research, Bhubaneswar, Odisha, India
December 28, 2026 to December 30, 2026
Two-Day Online National Workshop on Library Automation Using Koha at Cooch Behar, West Bengal
October 2, 2026 at 11am to October 3, 2026 at 5pm
Two-Day Online National Workshop on "Library Automation Using Koha" at Online
October 2, 2026 at 11am to October 3, 2026 at 5pm
"Dear All Librarian,
PFA
Call for Book Chapters/Research Papers for Edited Book To be Published with ISBN under IIP International Publi"
"What are you upCall for Chapters
Transforming Libraries in the Age of AI: Towards a Smarter
Knowledge Ecosystem to?"
how convert web page to ms exel
Replies to This Forum
-
Permalink Reply by Raksha on
-
One interesting feature of Excel is the ability to import Web pages. This means that if you have data on a Web site, it's very easy to convert it to an Excel spreadsheet, if your Web page is properly set up. This gives you the analysis tools in Excel available to your Web pages. It also allows you to import data from other Web pages into your spreadsheets.
-
-
How to Set Up Your Site
As Excel is a spreadsheet, it is made up of boxes or tables. Thus, if you're going to import data from a Web page into Excel, the best format is as a table. You can tell your spreadsheet to import every table on a Web page, just specific tables, or even all the text on the page.
-
-
How to Import the Data
Once you have the Web page set up with your tables identified, you need to import the data into Excel.
- Open Excel.
- Click in the cell where you'd like your data to start.
- Click on the Data menu and choose "Get External Data".
- Choose "New Web Query".
- In the address box, type the URL of the Web page where your data is found.
- Click in the "One or more specific tables on the page".
- Type in the id of the table you want to import. If you're importing from a page where the tables aren't labled, you'll need to count the number on the page.
Be careful of formatting. If a page uses tables for layout, this can impact the numbering of the tables - and Excel might import more than you expect. - Choose the amount of formatting you would like:
- None - the data will be imported with no formatting
- Rich Text Formatting - the data will be imported with formatting like bold, italics, and background colors
- Full HTML Formatting - the data will be imported as close to the existing Web page as Excel can render
- Click OK.
© 2026 Created by Dr. Badan Barman.
Powered by
