Save time effort with this easy way to copy web data to excel. Instead of copying and pasting chunks of data at a time e.g., from a table on web page, simply copy the URL of the page you’d like to get the data from. Here’s how:
– Open Excel.
– Click on ‘Data’ (top menu) and click on ‘From Web.’
– Paste the URL of the web page containing the table of data into the field that loads and click on ‘OK.’
– Select the table you’d like to copy the data from and click on ‘Load.’
– The table of data will now load into Excel.
About us and this blog
We are a IT solutions and support company. In our BLOG you can find more information about services and solutions we provide and learn how they can benefit you and your business.
We offer professional IT support for small and medium size businesses, as well as support home based businesses.
To check how we can help improve your security and productivity, request your FREE IT health check today!
Categories
Archives
- September 2023
- August 2023
- July 2023
- June 2023
- May 2023
- April 2023
- March 2023
- February 2023
- January 2023
- December 2022
- November 2022
- October 2022
- September 2022
- August 2022
- July 2022
- June 2022
- May 2022
- April 2022
- March 2022
- February 2022
- January 2022
- December 2021
- July 2020
- June 2020
- May 2020
- April 2020
- March 2020
- February 2020
- January 2020
More from our blog
See all posts
Tags
Categories
- Brand development (4)
- Business advice (19)
- education (14)
- News (559)
- Uncategorized (14)