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.
Open the cleanerSteps
- 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