TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

PageToSheet: Download Tables from Any Webpage to Excel

52 pointsby yolo123almost 3 years ago

11 comments

donatjalmost 3 years ago
Firefox has a really nice built in table selection mode I use to copy into spreadsheets all the time. Just hold down CMD (Mac) or Control (Others) and you can select table rows and columns.
评论 #31719441 未加载
sixhobbitsalmost 3 years ago
`=IMPORTHTML` in Google Sheets works great and surprisingly many people who could benefit from it a lot don't know it exists.
评论 #31713662 未加载
评论 #31713369 未加载
nojitoalmost 3 years ago
Excel does this natively.<p><a href="https:&#x2F;&#x2F;docs.microsoft.com&#x2F;en-us&#x2F;power-query&#x2F;connectors&#x2F;web&#x2F;web" rel="nofollow">https:&#x2F;&#x2F;docs.microsoft.com&#x2F;en-us&#x2F;power-query&#x2F;connectors&#x2F;web&#x2F;...</a><p>Or you can just use smart copy in edge.<p><a href="https:&#x2F;&#x2F;techcrunch.com&#x2F;2020&#x2F;03&#x2F;30&#x2F;microsoft-edge-is-getting-smart-copy-and-paste-a-password-monitor-and-vertical-tabs&#x2F;" rel="nofollow">https:&#x2F;&#x2F;techcrunch.com&#x2F;2020&#x2F;03&#x2F;30&#x2F;microsoft-edge-is-getting-...</a>
ygraalmost 3 years ago
Doesn&#x27;t Excel already do this on its own? It&#x27;s based on an IE control in my ancient version (2010), but perhaps it has been updated by now.
评论 #31713953 未加载
avinashsoneealmost 3 years ago
I use copytables <a href="https:&#x2F;&#x2F;merribithouse.net&#x2F;copytables&#x2F;" rel="nofollow">https:&#x2F;&#x2F;merribithouse.net&#x2F;copytables&#x2F;</a>. It has number of options for selection and also keyboard shortcuts.
TAForObvReasonsalmost 3 years ago
There&#x27;s a neat Chrome extension to do this <a href="https:&#x2F;&#x2F;www.georgemike.com&#x2F;tablecapture&#x2F;" rel="nofollow">https:&#x2F;&#x2F;www.georgemike.com&#x2F;tablecapture&#x2F;</a>
LeoPantheraalmost 3 years ago
If you are a Mac user using Numbers and Safari, you can do this by literally selecting the table, and copy pasting it right into Numbers. I do this quite often.
kallebooalmost 3 years ago
The page is 502ing so maybe I&#x27;m missing something but I just copy and paste from my browser into Numbers. Is this for automation?
adammarplesalmost 3 years ago
I use pd.from_html
评论 #31713291 未加载
emerilalmost 3 years ago
I guess still better off pdf&#x27;ing it and running it through tabula (free) or maybe abbyy (paid)
7e22v837278gb1palmost 3 years ago
looks like they need to beef up their web hosting solution.
评论 #31713230 未加载