How to use this tool
- Open the workbook and choose the worksheet. Check the preview for title rows, repeated headers, and the first record you expect.
- Inspect Data Issues and Column Profile. Preview each repair, starting with clear problems such as extra spaces in category labels.
- Download a new workbook with the cleaned table. Compare its row count and a few key values with the source sheet.
Worked examples
| Original data | After review |
|---|---|
| “West ” and “West” in the Region column | Both values read “West” after trimming |
| A workbook with Sales and Notes worksheets | A new workbook containing the cleaned Sales table |
Frequently asked questions
Will export preserve the whole original workbook?
Export writes a fresh workbook from the selected table. Keep the source workbook for other worksheets, formulas, charts, styles, and pivot tables.
Which worksheet should I choose?
Choose a sheet with one record per row and one field per column. A summary or pivot sheet may contain totals that look like ordinary records.
