← 发现
制作步骤 / 使用自己的 AI
Make a messy CSV easier to read
Trim extra spaces and flag duplicate rows while keeping the original data untouched.
结果示例
name, city " Ana "," Seoul " → name,city Ana,Seoul Duplicates: 2 flagged, not deleted.
准备工作
An AI coding tool, a CSV with made-up sample data, and a spreadsheet app for checking the output.
快速开始
1. Give your AI the recipe and a sample header.
2. Test quoted commas, empty cells and non-English text.
3. Compare row counts and open the output in a spreadsheet.
限制与支持
CSV dialects vary. Review encoding, delimiters, leading zeros and formula-like values. Do not use real personal data during development.
Starter example; questions are welcome, with no ongoing support commitment.
用你的智能体重新制作
把它交给你自己的 AI 智能体，做出你的版本。这是别人写的指令，运行前请先阅读。
有 Disposable 技能时，对智能体说：
帮我重新制作这个 Disposable 工具： https://disposable.xify.kr/zh-Hans/tools/messy-csv获取技能 →
Build a local CSV cleaner for one exported table. Let me choose a file and encoding. Parse CSV correctly, including quotes, embedded newlines and commas; do not split lines or commas manually. Trim leading and trailing spaces in text cells. Preserve leading zeros, date strings, blank cells and row order. Flag exact duplicate rows in a separate report without deleting them. Export a new file and show input/output row counts. Do not modify the original, upload data or evaluate spreadsheet formulas. Flag cells starting with =, +, - or @ and ask how to export them safely. Test with entirely invented data, including Korean, Japanese and Chinese text.
向作者提问
问题、错误和“我试过了”都发到 GitHub issue，由作者回复。发帖需要 GitHub 账号。