Kage LabGuides
Plain-English how-tos for getting data off web pages and into your spreadsheets: free methods first, shortcuts second.
- How to copy a table from a website into ExcelCopy and paste, Excel's built-in From Web import, or a one-click browser extension – and how to fix the usual problems.
- How to import a table from a website into Google SheetsThe IMPORTHTML formula, a clean paste with Ctrl+Shift+V, and what to do when the formula can't see your table.
- How to export a table that's split across several pagesShow more rows per page, use the site's export, or let an extension click 'Next' and merge every page for you.
- How to convert a web table to CSV (without breaking accents, zeros or dates)Save a table as CSV, then avoid the classic problems: one-column files, garbled accents and lost leading zeros.