data.cleaner Browser local
PRACTICAL FIELD NOTES

Fix the cause, not just the file.

Step-by-step guides for common import errors, damaged structure, duplicates, private information and safe exports.

FIELD NOTEHow to clean a messy CSV safelyHow to clean a messy CSV safely. Practical steps, common causes and a matching browser-local DataCleaner tool.Read guide ↗FIELD NOTEHow to remove duplicate rows from a CSVHow to remove duplicate rows from a CSV. Practical steps, common causes and a matching browser-local DataCleaner tool.Read guide ↗FIELD NOTEFix CSV columns shifting after importFix CSV columns shifting after import. Practical steps, common causes and a matching browser-local DataCleaner tool.Read guide ↗FIELD NOTEFix broken CSV accent and Unicode charactersFix broken CSV accent and Unicode characters. Practical steps, common causes and a matching browser-local DataCleaner tool.Read guide ↗FIELD NOTEHow to check email columns before importHow to check email columns before import. Practical steps, common causes and a matching browser-local DataCleaner tool.Read guide ↗FIELD NOTEMerge CSV files with different columnsMerge CSV files with different columns. Practical steps, common causes and a matching browser-local DataCleaner tool.Read guide ↗FIELD NOTEHow to handle empty cells in CSV dataHow to handle empty cells in CSV data. Practical steps, common causes and a matching browser-local DataCleaner tool.Read guide ↗FIELD NOTEHow to remove private information before sharing a CSVHow to remove private information before sharing a CSV. Practical steps, common causes and a matching browser-local DataCleaner tool.Read guide ↗FIELD NOTEPrevent CSV formula injection in exported filesPrevent CSV formula injection in exported files. Practical steps, common causes and a matching browser-local DataCleaner tool.Read guide ↗FIELD NOTENormalize CSV dates without swapping month and dayNormalize CSV dates without swapping month and day. Practical steps, common causes and a matching browser-local DataCleaner tool.Read guide ↗FIELD NOTEHow to diagnose and repair invalid JSONHow to diagnose and repair invalid JSON. Practical steps, common causes and a matching browser-local DataCleaner tool.Read guide ↗FIELD NOTEFix malformed JSON Lines recordsFix malformed JSON Lines records. Practical steps, common causes and a matching browser-local DataCleaner tool.Read guide ↗FIELD NOTEConvert tab-separated data to CSV without broken quotingConvert tab-separated data to CSV without broken quoting. Practical steps, common causes and a matching browser-local DataCleaner tool.Read guide ↗FIELD NOTEProfile a dataset before changing anythingProfile a dataset before changing anything. Practical steps, common causes and a matching browser-local DataCleaner tool.Read guide ↗FIELD NOTEConvert an Excel worksheet to CSV safelyConvert an Excel worksheet to CSV safely. Practical checks, limitations and safer export steps for browser-local DataCleaner.Read guide ↗FIELD NOTECheck XLSX worksheets and formulas before cleanupCheck XLSX worksheets and formulas before cleanup. Practical checks, limitations and safer export steps for browser-local DataCleaner.Read guide ↗FIELD NOTERemove duplicate Excel rows by exact valuesRemove duplicate Excel rows by exact values. Practical checks, limitations and safer export steps for browser-local DataCleaner.Read guide ↗FIELD NOTERemove completely blank Excel worksheet rowsRemove completely blank Excel worksheet rows. Practical checks, limitations and safer export steps for browser-local DataCleaner.Read guide ↗FIELD NOTEExport selected Excel columns to CSVExport selected Excel columns to CSV. Practical checks, limitations and safer export steps for browser-local DataCleaner.Read guide ↗FIELD NOTEConvert CSV to Excel without interpreting formulasConvert CSV to Excel without interpreting formulas. Practical checks, limitations and safer export steps for browser-local DataCleaner.Read guide ↗FIELD NOTERemove CSV duplicate records by a unique keyRemove CSV duplicate records by a unique key. Practical checks, limitations and safer export steps for browser-local DataCleaner.Read guide ↗FIELD NOTEJoin two CSV files by ID without multiplying rowsJoin two CSV files by ID without multiplying rows. Practical checks, limitations and safer export steps for browser-local DataCleaner.Read guide ↗FIELD NOTEFind mixed numbers dates and text in CSV columnsFind mixed numbers dates and text in CSV columns. Practical checks, limitations and safer export steps for browser-local DataCleaner.Read guide ↗FIELD NOTEInspect spaces and split combined CSV fields safelyInspect spaces and split combined CSV fields safely. Practical checks, limitations and safer export steps for browser-local DataCleaner.Read guide ↗