VBACODE.AI / Excel tools
AI Excel Editor and Data Cleaning: Deduplicate and Normalize
Upload Excel to edit cells, trim whitespace, normalize numbers and dates, fill blanks or deduplicate by selected fields while retaining source sheets.
Open workspace →Analysis uses allowance. Confirmed execution costs 10 credits; failed execution is refunded.
Specify cleaning rules first
Deduplicating by customer ID differs from deduplicating entire rows. The supported deduplication operation keeps the first row for the selected keys. Explicitly choose values used to fill blanks.
Keep source data for comparison
Cleaning writes a new worksheet so you can compare it with the source. Outputs contain values rather than migrated source formulas or full formatting. For individual edits, select a cell and insert its reference into your request.
Handle dates and identifiers carefully
Use YYYY-MM-DD or Excel date serials. Ambiguous dates such as 01/02/2026 need clarification. Postal codes, product IDs and order IDs can have leading zeros and should not be converted to numbers without a reason.
Example request to copy into the workspace
Clean Data: trim Customer ID, convert Amount to numbers, parse Date as YYYY-MM-DD and fill blank Status with Pending. Deduplicate by Customer ID, keeping the first row. Write values to a new Clean sheet, preserve the source and do not add macros.
Current scope
Ambiguous date locales, currencies and missing business facts are not guessed. Complex cleaning may require separate steps.
Supports .xlsx / .xlsm with approximately 4 MB combined upload, up to 20,000 rows and 128 columns per sheet and 200,000 cells overall.