ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to convert HTML data into Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/76220-how-convert-html-data-into-excel.html)

The Accidental Tourist

How to convert HTML data into Excel?
 
I am trying to devise a way to convert HTML data from several webpages into
Excel. For example, I have surveys that have the same fields that are
submitted by different users. A user goes to this page and answers a a set of
questions. I was told that the survey page needs to be created as a table but
I don't have ownership of these pages. I am trying to create a report that
shows the users and how they answered so I can scan through and be able to
filter who answered a particular question. I can access the survey responses
for each user separately. Is there a way to grab or extract it into a
template that can be converted to a .xls format or can be created within
Excel.


All times are GMT +1. The time now is 02:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com