Guides
Check how the table was read before changing it.
Choose a guide for parsing, cleanup or conversion. A wrong separator or encoding changes what the cells mean, so correct the import before removing rows or choosing an export format.
Try an exampleStart with separators and accents
If the preview puts a whole record in one column, inspect the detected separator. If names have broken accents, inspect the encoding. Compare the first rows with the source and check whether the header is really a header before applying cleanup.
Remove only the rows you intend to remove
Trim stray spaces before checking duplicates. Read which columns define a duplicate: two people with the same name can still be different records. Check the reported row changes and use Undo if the chosen rule removes useful data.
Choose the format the next system expects
Use CSV for delimited records, JSON for structured records or XLSX for a workbook. Keep identifiers such as 001 as text when leading zeros matter. Conversion writes values; it does not preserve or calculate spreadsheet formulas, charts or styling.
Check the downloaded copy
- Compare the exported row and column counts with the cleanup result.
- Reopen the file in the receiving program and check accents, identifiers and dates.
- Keep the original files until you have checked the downloaded copy.
Practice without personal files
Open the sample CSV using UTF-8 and a comma separator. Trim spaces, drop the empty row and remove the repeated record using all columns. The expected result is three records with IDs 001, 002 and 003. Save a copy and reopen it to check the accents and leading zeros.
The practice files contain synthetic examples. Their text is in English.
Open the practice guide