How to Copy Table Data from Difficult Web Pages
Short video on how to copy table data from a difficult web page where normal table data selection in the web browser (Firefox in our example) fails. Shows how to export a PDF copy of the page using Microsoft Print to PDF in Firefox, how to extract the tables quickly from the PDF file into CSV or other disk files, how to quickly copy the CSV file data in the Windows clipboard using the Windows/DOS CLIP command, and finally how to paste the clipboard CSV data into the LibreOffice Calc spreadsheet. LibreOffice is a free open-source program largely compatible (a "clone") with MS Office. Calc is similar to MS Excel although there are some differences.
Quick summary of Windows/DOS commands used:
DOS> camelot -p all - f csv -o polling.csv stream "Polling Report March 27 2022 Table.pdf"
DOS> clip < polling-page-1-table-1.csv
DOS> clip < polling-page-2-table-1.csv
DOS> clip < polling-page-3-table-1.csv
Camelot PDF Table Extraction: https://camelot-py.readthedocs.io/en/master/index.html
The difficult web page shown: https://www.pollingreport.com/biden_job.htm
CORRECTION: I mispoke at about 15:00 minutes into the video, saying LEFT CLICK on the mouse when I meant RIGHT CLICK. Most popup menus in LibreOffice Calc are brought up by right clicking with the mouse or trackball as in other programs. There is a correction subtitle in the video as well.
About Us:
Main Web Site: https://mathematical-software.com/
Censored Search: https://censored-search.com/
A search engine for censored Internet content. Find the answers to your problems censored by advertisers and other powerful interests!
Subscribe to our free Weekly Newsletter for articles and videos on practical mathematics, Internet Censorship, ways to fight back against censorship, and other topics by sending an email to: subscribe [at] mathematical-software.com
Avoid Internet Censorship by Subscribing to Our RSS News Feed: http://wordpress.jmcgowan.com/wp/feed/
Legal Disclaimers: http://wordpress.jmcgowan.com/wp/legal/
Support Us:
PATREON: https://www.patreon.com/mathsoft
SubscribeStar: https://www.subscribestar.com/mathsoft
BitChute (Video): https://www.bitchute.com/channel/HGgoa2H3WDac/
Brighteon (Video): https://www.brighteon.com/channels/mathsoft
Odysee (Video): https://odysee.com/@MathematicalSoftware:5
NewTube (Video): https://newtube.app/user/mathsoft
Minds (Video): https://www.minds.com/math_methods/
Locals (Video): https://mathematicalsoftware.locals.com/
Archive (Video): https://archive.org/details/@mathsoft
###
-
10:31
Free Skills
3 years agoComplete Web Developer Chapter 4 - Lesson 4 Create Table
84 -
43:40
Excel For Freelancers
3 years agoHow to Extract Data From Unlimited PDF Forms To An Excel Table IN ONE CLICK
26 -
13:31
Pharos Technology
1 year agoGetting UPC Data from the Web and Parsing it Into a Table
11 -
2:42
Code Boxx
5 months ago4 Ways To Freeze Rows & Columns Of HTML Tables
5 -
3:04
I'm Trace
1 year agoHow to Move Big Heavy Table
1 -
2:32
The Excel Zone
1 year agoEXCEL TUTORIAL: AUTO-COPY FUNCTION TO SAVE TIME
27 -
2:09
AlgoDocs - Real Time Document Data Extraction
2 years agoExtract tables that span over multiple pages in pdf
1 -
4:22
Aaron Linsdau
3 years agoHow to Paste Formatted Text From a Web page to Adobe Indesign (4k UHD) Retain Italics Bold
25 -
1:00:01
Comeministry
4 months agoPreparing A Table!
38 -
2:45:35
Excel For Freelancers
1 year agoHow To Create A Dynamic Report In Excel From Any Table In ONE CLICK + FREE DOWNLOAD
56