IMPORTHTML Not Working? Move a Web Table into Google Sheets
Check why IMPORTHTML cannot find your table, then try extracting the open page to CSV and importing a verified sample into Google Sheets.
Read guideBlog
Practical guides for
working with web pages.
Step-by-step examples of extracting data, understanding reports, and using Sidelight AI Assistant in your browser.
How to Export a Paginated Web Table to Excel Without Copying Every Page
Collect rows across a bounded number of web pages, check the page boundaries and duplicates, then import the resulting CSV into Excel.
Read guideHow to Extract a Table from an Iframe and Open It in Excel
Find the embedded report behind a visible table, test a limited extraction, and check the available rows before importing a CSV into Excel.
Read guideHow to Extract Infinite-Scroll Website Data and Save It as CSV
Collect selected fields from an infinite-scroll list, set a clear extraction limit, and check the CSV before using it in Excel or Google Sheets.
Read guideHow to Export a Table Behind a Login to Excel Without an Export Button
Extract selected columns from a page you are already signed in to, check the captured records, and import the CSV into Excel for analysis.
Read guideExcel Not Detecting a Web Table? Check the Import and Export Visible Data as CSV
Check Power Query's web import, understand why a visible table may be missing, and try a bounded browser-to-CSV workflow when you need a snapshot.
Read guideHow to export product cards to CSV with names, prices, and URLs
Turn a product listing into a spreadsheet: choose fields, collect a bounded set of pages, check prices and variants, and export the records as CSV.
Read guideExport website tables to a CSV file
Collect rows from tables and listings, include multiple pages, and download a file you can use in a spreadsheet.
Read guideGet specific answers from a web page
Ask about a report, article, or product page without copying its contents into a separate chat.
Read guideTrack dashboard data with a live panel
Pin a metric to the page and refresh it from an accessible source while you continue working.
Read guideUse the assistant to fill fields and navigate a page
Give precise instructions for clicking, entering information, and moving through a website using your existing session.
Read guide