原文核对：2026-10-13 · 中文正文 · 英文提示词与演示
场景定位
拖入或提及杂乱的 CSV 或电子表格，说明你看到的问题，让 ChatGPT 生成清理后的副本，同时保留原始文件。
- 难度
- 入门
- 时间跨度
- 5 分钟
适合用于
- 包含混杂日期、货币格式、重复项、汇总行或缺失值的 CSV 和电子表格导出文件。
- 需要处理多来源数据的团队。
相关工具
检查表格文件、清理列，并生成便于审阅的结果。
起步提示词
英文原文 · 可复制后按实际材料修改
Clean @marketplace-risk-rollout-export.csv.
What's wrong:
- dates are mixed between MM/DD/YYYY and YYYY-MM-DD
- currency values include $, commas, and blank cells
- a few duplicate customer rows came from repeated exports
- region and category names use several aliases
- there are pasted summary rows mixed into the data
What I want:
- write a cleaned CSV
- keep the original file unchanged
- use one date format
- keep blank currency cells blank
- preserve source row IDs when possible
- add a short data-quality note with rows you changed, removed, or could not clean confidently简介
ChatGPT 很适合系统地清理表格数据。当 CSV 或电子表格包含日期格式混杂、重复行、货币字符串、空单元格、别名或粘贴的汇总行时，可以让 ChatGPT 清理一份副本，保留原文件。
使用步骤
- 将文件拖入 ChatGPT，或在提示词中提及它，例如 @customer-export.csv。
- 描述你已经发现的问题。
- 说明清理后的目标格式：CSV、电子表格工作表，或可直接上传的文件。
- 使用前先检查清理后的副本。
首次清理可以使用本页起步提示词，并换成自己的文件名和问题列表。最有帮助的信息是你看到的问题，以及接下来需要的文件形态：干净的 CSV、清理后的工作表，或可上传的文件。ChatGPT 生成副本后，先从对话中打开结果文件和数据质量说明，再将数据用于后续工作。
展开英文原文对照
Drag in or mention a messy CSV or spreadsheet, describe the problems you see, and ask ChatGPT to write a cleaned copy while keeping the original file unchanged.
Introduction
ChatGPT is great at cleaning systematically tabular data. When a CSV or spreadsheet has mixed dates, duplicate rows, currency strings, blank cells, aliases, or pasted summary rows, ask ChatGPT to clean a copy and leave the original file unchanged.
How to use
- Drag the file into ChatGPT or mention it in your prompt, such as @customer-export.csv.
- Describe the problems you already see.
- Tell ChatGPT what the cleaned version should be: CSV, spreadsheet tab, or upload-ready file.
- Review the cleaned copy before using it.
Use the starter prompt on this page for the first cleaning pass. Replace the file name and bullets with your own. The useful details are the problems you already see and the file you need next: a cleaned CSV, a clean spreadsheet tab, or an upload-ready file. After ChatGPT writes the clean copy, open the cleaned file and the data-quality note from the chat before using the data downstream.