哪些场景需要合并When You Need to Merge

  • 每月/每天导出的同结构报表,想汇总成一张年度总表。
  • 不同门店、不同系统各自导出的 CSV,需要统一分析。
  • 从数据库分批导出的分片文件,需要拼回完整数据。
  • Same-structured reports exported monthly/daily that you want to roll into one annual sheet.
  • CSV exports from different stores or systems that need unified analysis.
  • Chunked database exports you need to reassemble into the full dataset.

用 365Lab 合并(步骤)Merge with 365Lab (Steps)

  1. 打开 合并拆分 模块。
  2. 一次性添加多个 CSV 文件(可拖拽多选)。
  3. 选择合并方式:按表头对齐(列顺序不同也能正确归位)或直接纵向拼接。
  4. 在预览表格中确认行数与列名无误。
  5. 点击导出,可下载单个合并后的 CSV,或打包成 ZIP 批量获取。
  1. Open the Merge & Split module.
  2. Add multiple CSV files at once (drag to multi-select).
  3. Choose a mode: align by header (columns snap to the right place even if ordered differently) or simple vertical stacking.
  4. Confirm row counts and column names in the preview.
  5. Export — download the merged CSV, or bundle everything into a ZIP.

合并前的小贴士Tips Before Merging

问题Issue建议Advice
列名不一致Mismatched headers用"按表头对齐",缺失列自动补空Use "align by header"; missing columns are filled with blanks
含表头重复Duplicate headers除第一个文件外,其余可跳过首行表头Skip the header row for all but the first file
编码不同Different encodings先逐个用编码转换统一为 UTF-8First unify to UTF-8 with the encoding tool
为什么不用 Excel 手动复制?几十个文件手动复制既慢又容易漏行、错位。在线合并一次性完成,且文件只在你浏览器里处理,私密数据更安全。
Why not copy-paste in Excel? Doing dozens of files by hand is slow and error-prone — you'll miss rows or misalign columns. Online merging does it in one pass, and your files stay in your browser.

合并之后还能做什么What to Do After Merging

合并完往往还要去重、按某列排序、做统计。365Lab 的 数据清洗、多列排序、统计图表 都能在同一工作区接着处理,省去反复导入导出。

After merging you often need to dedupe, sort by a column or run stats. 365Lab's Clean, Multi-column Sort and Stats & Charts all work in the same workspace — no repeated import/export.

开始合并你的 CSV →

Start merging your CSVs →

打开合并工具Open the Merge Tool