中文版:请帮我检查和清洗这份Excel数据。

请重点检查重复记录、空白单元格、异常值、错误日期、格式不一致、大小写不一致、前后空格、数字被识别为文本、金额格式混乱以及同一客户或产品存在多个名称的问题。

请建立数据质量检查清单,并按照“问题类型—发现数量—影响范围—处理建议”的方式输出结果。

对于可以安全自动修正的问题,请给出Excel公式、Power Query方法或操作步骤。

对于无法确定的数据,不要擅自修改,而是单独标记为“待人工确认”。

最终给出清洗前后字段结构,并确保清洗后的数据能够用于排序、筛选、数据透视和统计分析。

英文版:Help me inspect and clean this Excel dataset.

Check for duplicate records, blank cells, abnormal values, invalid dates, inconsistent formats, inconsistent capitalization, leading or trailing spaces, numbers stored as text, inconsistent currency formats, and cases where the same customer or product appears under different names.

Create a data-quality checklist showing issue type, number of affected records, impact, and recommended action.

For issues that can be safely corrected, provide Excel formulas, Power Query methods, or step-by-step instructions.

Do not modify uncertain information automatically. Mark it as requiring manual review.

Provide the field structure before and after cleaning and ensure the cleaned dataset is suitable for sorting, filtering, pivot tables, and statistical analysis.

该提示词已在以下工具中验证有效:ChatGPT、Claude、Gemini、Copilot