CleanMySheet guide
Turn N/A, NULL, and dashes into blank cells
CleanMySheet maps n/a, NA, NULL, none, nil, #N/A, -, and similar tokens to blank. Numeric and boolean cells are left alone. Combine with Drop empty rows/columns to delete all-blank records.
Empty placeholders will show after scan.
Drop CSV or Excel here
Tap to choose a file. Parsing stays on this device.
Parsing stays on this device. Optional: drop a .cleanmysheet.json recipe with it.
Steps
- Scan the file
- Apply Unify empty values
- Optionally Drop empty rows/columns
Survey data
Google Forms and Typeform exports often mix blanks and “N/A”. The Survey responses bundle trims, unifies empties, maps yes/no, and deduplicates.
Related searches this page answers
- replace n/a with blank excel
- unify null csv
- empty placeholder spreadsheet