← 探索
製作步驟 / 使用自己的 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-Hant/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 帳號。