← 見つける
レシピ / 自分の 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/ja/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 アカウントが必要です。