LIS Links

First and Largest Academic Social Network of LIS Professionals in India

Latest Activity

Vikram Jain replied to Vikram Jain's discussion Call for Chapter Contribution in Editorial Book "Artificial Intelligence Connect: Empowering Education & Enabling Libraries"
10 hours ago
Abdullah al-Modabber updated their profile
yesterday
Fazal posted a status
"🎓 Decode DDC with AI: Smart Classification 🗓️ Date: 31st August 2025 ⏰ Time: 06:30 – 08:PM Register: https://forms.gle/uuNBECwesduV2fjd6"
yesterday
YOGESHKUMAR HARILAL LAD is attending komal patel's event
Thumbnail

National Conference on Re-Imagining Libraries of Viksit Bharat 29-30 AUGUST 2025 at Bhopal

August 29, 2025 at 10am to August 30, 2025 at 5pm
yesterday
LAITHANGBAM NEPOLEAN SINGH shared Ravithimmegowda's discussion on Facebook
Monday
LAITHANGBAM NEPOLEAN SINGH updated their profile
Monday
Dr. O Seshaiaih and Sumit Sundar Ray are now friends
Monday
Sumit Sundar Ray updated their profile
Sunday
Bristy Handique updated their profile
Saturday
meghabat singh updated their profile
Saturday
Elukoti Bhosle updated their profile
Jul 18
DEVI SHANKAR DINGARA updated their profile
Jul 17
ASHUTOSH KAG updated their profile
Jul 17
Dr. U. PRAMANATHAN posted discussions
Jul 16
Dr. U. PRAMANATHAN posted blog posts
Jul 16
Dr. U. PRAMANATHAN is now friends with Ramesh Kumar and Suraj Morya
Jul 16
Archanagita Saikia posted a discussion
Jul 16
Manju Meerwal joined Dr. Badan Barman's group
Jul 16
Dr. O Seshaiaih posted a discussion
Jul 16
Dr. A. Madhava Rao posted an event

Online-Lecture on "AI Tools for Academic Research Writing and Publishing" at Microsoft Teams (Online)

August 4, 2025 from 2pm to 4pm
Jul 16

i want to know how convert or edit  web page to ms excel in windows xp 

 

Views: 219

Reply to This

Replies to This Forum

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.

  1. Open Excel.
  2. Click in the cell where you'd like your data to start.
  3. Click on the Data menu and choose "Get External Data".
  4. Choose "New Web Query".
  5. In the address box, type the URL of the Web page where your data is found.
  6. Click in the "One or more specific tables on the page".
  7. 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.
  8. 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
  9. Click OK.

RSS

© 2025   Created by Dr. Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

Koha Workshop