HOW TO extract table on a public web page as a CSV file

Tables within web pages on the internet don't provide interactivity most of the times and data is presented through plain HTML tables unless developers of the website implement it through client-side functionality through something like a jQuery plug-in such as DataTables to make data more accessible. In such cases, you cannot filter or sort unless you manually copy the table to a spreadsheet and then use the functions of a software tool like Excel. 

To minimize the steps, it is better to use bookmarklets that can create a CSV file from an HTML Table. Below are such bookmarklets graciously shared by some good folks on the internet -

The screenshot shows how ShareProgress' TableThis bookmarklet can inject code to make a table within a Wikipedia page to be downloaded as a CSV file

Bookmarklet code needs to be relatively short because of browser limitations on the length of valid URLs — only 2000 characters are accepted in a URL. It’s possible to build  complex and interesting functionality if you can reference larger external scripts.

Also see - HOW TO filter columns in a HTML table within any web page

Comments

Popular posts from this blog

Maven Crash Course - Learn Power Query, Power Pivot & DAX in 15 Minutes

"Data Prep & Exploratory Data Analysis" course by Maven Analytics

Oracle Cloud Infrastructure 2024 Generative AI Professional Course & Certification Exam (1Z0-1127-24)