网页采集助手

从网页表格、列表和卡片中提取数据，一键导出 CSV、Excel 或 JSON。


无需写代码，智能提取网页表格、列表、卡片和懒加载内容，支持字段编辑、模板复用、CSV/Excel/JSON 导出。

Extract tables, lists, cards, and lazy-loaded web data. Clean fields and export to CSV, Excel, or JSON.

## 详细描述

网页采集助手是一款面向普通办公用户、运营、采购、销售和数据整理人员的浏览器扩展。它可以从当前网页中提取表格、列表、卡片和链接数据，并导出为 CSV、Excel 或 JSON。

你不需要写代码，也不需要手动复制粘贴。打开网页后点击扩展，即可智能识别页面结构，提取可用数据，选择需要导出的字段，并保存当前网站的采集模板。

### 适合场景

- 从网页表格中整理库存、订单、价格、名单等数据
- 从搜索结果、文章列表、商品列表中提取标题、链接、价格、日期等字段
- 从后台管理系统中导出没有下载按钮的数据
- 对加载更多、下一页、懒加载页面进行半自动追加采集
- 将采集结果导出为 Excel 继续分析和归档

### 核心功能

- 智能提取表格、列表、卡片和链接
- 鼠标点选页面区域后提取指定内容
- 自动识别表头并作为导出字段
- 自动跳过“操作、编辑、删除、查看、详情”等操作列
- 自动清洗空行、重复行和全空字段
- 支持字段勾选和字段改名
- 支持当前网站模板保存、复用、重命名和删除
- 支持追加下一页和滚动采集懒加载内容
- 支持复制 CSV、导出 CSV、导出 Excel `.xlsx`、导出 JSON



- Empty rows
- Duplicate rows
- Fully empty columns

Duplicate detection prefers link fields first, then title fields, then the full row content.

Long cell text is truncated to keep exports practical and avoid oversized CSV files. Cleanup is applied to smart extraction, area picking, template reuse, append-next, and scroll collection results.

## Export Formats

- **CSV** is useful for opening in Excel, WPS, Google Sheets, or other spreadsheet tools.
- **Excel `.xlsx`** is useful for direct archiving and manual cleanup.
- **JSON** is useful for importing into systems, scripts, or automation workflows.

Exports use the currently selected fields and edited column names.

If duplicate JSON field names exist, the extension appends `_2`, `_3`, and so on to avoid overwriting data.

Export filenames automatically include the page title, host name, and current date.

## Batch Collection

### Append Next

**Append Next** looks for controls such as:

- Next
- More
- Load more
- Show more
- Chinese equivalents such as 下一页, 加载更多, 查看更多

It clicks the control, waits for page changes, extracts again, merges the result, and removes duplicates.

### Scroll Collect

**Scroll Collect** scrolls down the page several times, waits for lazy-loaded content, extracts again, merges the result, and removes duplicates.

These features are useful for search result pages, product feeds, article lists, admin tables, and pages with incremental loading.

If a site performs a full page navigation when clicking Next, you may need to wait for the new page to load and open the extension again. The current version works best with load-more buttons, front-end pagination, and lazy-loaded pages.

## Smart Field Naming

When the extension has to generate fallback fields such as `Field1` and `Field2`, it examines sample values and may rename them to:

- Title
- Link
- Price
- Date
- Number
- Text

Real table headers, user-edited field names, and saved template field names are not overwritten automatically.

## Area Picking

1. Open the extension popup.
2. Click **Pick Area**.
3. Move your mouse on the page. The current target area will be highlighted.
4. Click the table, card, list item, or section you want to extract.
5. Reopen the extension popup to preview the extracted data.
6. If the result looks good, click **Save Template**.

## Templates

- Templates are saved per site origin, such as `https://example.com`.
- After saving a template, reopening the extension on the same site shows that templates are available.
- You can select a template from **Templates** and click **Use Template** to extract with the saved rule.
- Templates can be renamed and deleted.
- Templates store extraction rules and field settings. They do not store extracted page data.