Clean Excel data and create formulas with AI

Find duplicates, flag invalid values and build useful calculations.

This article was written in German by Christian Rothe and translated into English with the help of AI. Read the German original.

Explain the table’s structure first: required fields, number and date formats, and the calculations you need. This makes the analysis easier to check.

Start by flagging errors and proposing formulas. Verify how missing values are handled and whether cell references are correct before applying changes to a working copy.

How to proceed

Upload a copy of the table and explain its columns.
Use the prompt to identify anomalies and propose formulas.
Recalculate three sample rows and apply approved changes.

Specify the data range and calculation basis. Percentages need a clear denominator.

Prompt

Check the attached Excel table.
Columns: [meaning]
Required fields: [fields]
Valid values: [ranges]
Analysis goal: [goal]

Flag duplicates, missing required values and implausible entries. Explain each finding without changing the original data. Propose Excel formulas with specific cell references. Calculate three rows as verifiable examples. Ask if a column or calculation basis is unclear.