FlowSync
Open App
中文
FreeData4 nodes
Score 68

CSV/Excel Merge & Dedup

Drop multiple CSV/Excel files — Pandas merges across common keys, fuzzy-matches near-duplicates, LLM resolves entity conflicts, exports one clean deduplicated workbook.

Run this template Fork & customise

What does this workflow do?

Drop your csv — the pipeline runs 4 automated steps: Pandas (csv→csv) → LLM Reasoning (csv→json) → Pandas (json→csv) → OpenPyXL (csv→xlsx) — and delivers xlsx. Every node is visible, auditable, and replaceable.

System flow

1. Pandas — Tabular compute — join, aggregate, validate and reshape the extracted records 2. LLM Reasoning — Large-language-model step that extracts, classifies, validates or writes structured output 3. Pandas — Tabular compute — join, aggregate, validate and reshape the extracted records 4. OpenPyXL — Writes a formatted, formula-ready Excel workbook as the deliverable

Pipeline breakdown

Pandas csv LLM Reasoning csv Pandas json OpenPyXL csv
  1. Pandas pandas — Tabular compute — join, aggregate, validate and reshape the extracted records csv → csv
  2. LLM Reasoning llm — Large-language-model step that extracts, classifies, validates or writes structured output csv → json
  3. Pandas pandas — Tabular compute — join, aggregate, validate and reshape the extracted records json → csv
  4. OpenPyXL openpyxl — Writes a formatted, formula-ready Excel workbook as the deliverable csv → xlsx

Workflow Reputation Score

Based on executions, success rate, update frequency, component quality, and user rating.

68Overall
★★★★★ 4.1
▶Executions
25
✓Success rate
95
↻Update frequency
65
⚙Component quality
85
★User rating
82

Based on executions, success rate, update frequency, component quality, and user rating.

Components used

Pandaspandas

Tabular compute — join, aggregate, validate and reshape the extracted records

pandas-dev/pandas ↗
LLM Reasoningllm

Large-language-model step that extracts, classifies, validates or writes structured output

FlowSync proprietary
OpenPyXLopenpyxl

Writes a formatted, formula-ready Excel workbook as the deliverable

theorchard/openpyxl ↗

How is this different from n8n or Zapier?

Unlike generic workflow builders, FlowSync workflows ship pre-configured with AI skills baked into every node — OCR, LLM reasoning, transcription, super-resolution — not just webhook triggers. Each node is white-box auditable: you see input, output, and config. Deployment is instant — no self-hosting, no API-key per node.

Use cases

  • Monthly report consolidation
  • Multi-source data merge
  • CRM data cleanup
  • Inventory reconciliation

Author & Source

This workflow is maintained by the FlowSync team. All components are open-source or commercially licensed. Source code for each component is linked in the Components section above.

Pricing: Free tier available · FREE tier · Official

Data handling

Data is processed in-memory during pipeline execution only. No files are stored permanently unless you choose to save outputs to your account.

FlowSync Workflow Marketplace · 68 reputation score · 25% execution · 95% success · 4-node white-box pipeline · maintained by FlowSync Official

Ready to run?

Drop multiple CSV/Excel files — Pandas merges across common keys, fuzzy-matches near-duplicates, LLM resolves entity conflicts, exports one clean deduplicated workbook.

Run CSV/Excel Merge & Dedup → Browse all workflows →