Clean and merge ops spreadsheets
xianglouw/ecom-data-prep
Normalises headers (Chinese and English aliases), dates and amounts across platform, ERP, ad and 3PL bill exports, dedupes, checks required fields and quarantines bad rows instead of dropping them.
Review notes
MReviewed by moveset · 2026-10-28 · version 34e3917 · added by editors
- Good for
- Inconsistent exports from several sources that need cleaning before analysis or reconciliation.
- Not for
- Charts or analysis; it only cleans.
- Also
- Part of the author's cross-border skill set; it mentions sibling skills (fees, purchase orders), but this folder works on its own.
Install
From the GitHub repository xianglouw/ecom-agent-skills at commit 34e3917, take only the skills/ecom-data-prep folder and put it in this project's .agents/skills/ecom-data-prep/ (for Claude Code, also copy it to .claude/skills/ecom-data-prep/). Don't run its scripts yet; tell me where you installed it and what it needs.
Pinned to 34e3917 (2026-09-15), the version we reviewed and scanned
Installs come from the author's repository, not through moveset. Once the author claims it and hosts it on moveset, moveset install will work and deliver updates.
What it touches
- Files
- 8 files, 90 KB2 Python scripts, 2 sample sheets, 2 docs
- Runtime
- Python 3.8+, standard library only
- Network
- No network calls in the code
- Scan
- Review items, checked by hand · same scan rules as moveset's own skills1 review item checked by hand: examples/demo.sh only runs this folder's Python scripts on the sample sheets.Addresses found in the files (including doc links; not all are contacted): schemas.openxmlformats.org
Author's description
跨境电商运营表格数据整理与清洗技能.ecom-data-prep · SKILL.md · xianglouw/ecom-agent-skills@34e3917
Wrong description, broken link or a security issue? Tell usDon't want to be listed? Ask for removal · handled within two business days
Similar skills
All community skills →Built a skill for cross-border sellers?
Free skills can be submitted today and appear here once reviewed. Authors already listed can claim their page and maintain it; the best can ship a Pro edition with us for a royalty.