Datakrit
Check and clean a CSV file
Everything runs on this computer; nothing is sent to the internet.
Choose the file and how to read it
CSV fileYour file is only read. It is never changed. Up to {{max_file_mb}} MB per file (several files: together); results are kept in memory for this session only.
No file chosen yet.
Next: choose a CSV file in the box above.
Choose the file
- One file checks and cleans a single CSV file. Several files applies one set of column rules to every chosen file.
- The separator is not detected automatically. If the preview in step 2 shows one wide column, switch it.
- Change the encoding if letters such as
éorñlook wrong, or the file cannot be read.
Chosen files
Every file is checked and cleaned with the same separator, encoding, and rules. The rules in step 3 are based on the columns of the file you preview.
| File | Size | Actions |
|---|
Look at the data
The first rows of your file appear here, exactly as they are stored. Use them to confirm the separator and encoding before setting any rules.
Describe the columns
After a file is loaded, each column is listed here. Every column starts as plain text: Datakrit never guesses which columns are numbers or dates. You decide, or you load a profile that already contains the rules.
A profile is a small .toml file with saved rules. You can save one in step 6.
The example shows 31 December 2026 in each format. 01/02/2026 is never guessed: it is 1 February with DD/MM/YYYY and 2 January with MM/DD/YYYY.
| Column | Contains | Written like | Must not be empty | Must be unique | Repair: trim spaces | Repair: convert format | Repair: protect formulas |
|---|
"Repair" options change values only in the cleaned copy, and only in the columns you tick. Nothing else is touched. "Protect formulas" puts a ' before text that starts with = + - or @, so that Excel shows it instead of running it as a formula.
The first row is always the one that is kept.
More settings
A longer value stops reading with "field too large". It usually means an unclosed quote. Raise it only for files with very long texts. Saved in profiles as max_field_chars.
Check the file
Finds problems using your rules. Nothing is changed.
Preview the cleaned copy
Applies only the repairs ticked in step 3 and shows every value before and after. Still nothing is saved.
Save
Files are saved through your browser's download folder. Your original file stays as it is.