Media
5 items
Description
Capture web tables & dropdowns, edit in a side panel, generate SQL, and export to Excel/CSV/HTML/JSON. Web Table to Excel & SQL helps developers and data analysts turn HTML tables, data grids, and dropdown lists on any webpage into editable spreadsheets and ready-to-run SQL — without leaving the browser. HOW TO USE 1. Right-click on or near a table, grid, or dropdown on any webpage 2. Choose "Convert to Excel" 3. Edit data in the Chrome side panel spreadsheet 4. Configure table name and primary key in SQL Settings 5. Generate or export SQL scripts for your selected rows SQL FEATURES • Generate INSERT, UPDATE, DELETE, and MERGE scripts • Build WHERE conditions from selected cells • Copy as IN (...), NOT IN (...), or VALUES (...) snippets • Support T-SQL, MySQL, and PostgreSQL dialects • Export SQL scripts to a .sql file SPREADSHEET & EXPORT • Capture HTML tables and common grid layouts (AG Grid, jqGrid, ngx-datatable, and more) • Capture dropdown / select options (native select, Bootstrap, Vue/Element/Ant-style widgets, custom div menus) • Edit data in a full spreadsheet UI inside Chrome's side panel • Save to Excel with selectable style templates • Copy as Markdown, JSON, CSV, or Excel-friendly formats • Export selected ranges to Excel, HTML, or image PRIVACY All processing happens locally in your browser. Your table data is never sent to external servers. RELATED TOOLS • ComTools — free online toolbox (https://comtools.cn/) • Smart SQL for SSMS — export and edit SQL results in SQL Server Management Studio