Format
Leave empty for default settings (Excel dialect)
Or enable autodetection (which often will not detect the right options)
And / or set and overwrite (some) options manually
Charset
{{ form.sniff_encoding.errors }}
{{ form.sniff_encoding }}
Or set other charset manually:
{{ form.codec.errors }}
{{ form.codec }}
Leave empty and disable autodetection for modern, universal and international default (UTF-8) or if needet (because autodetection or this default UTF-8 results to corrupted data espacially on special chars) try with older charsets:
For example iso8859-15 for former western european or german standard or cp1252 for western european standard encoded with windows)
CSV dialect
{{ form.sniff_dialect.errors }}
{{ form.sniff_dialect }}
Most CSV are standard format and the sniffer often does not autodetect quoted content with multiple lines, so try without autodetection first.
All following settings will overwrite standard settings or automatically detected or guessed values:
Delimiter
{{ form.delimiter.errors }}
{{ form.delimiter }}
Leave empty for default , (comma) or set to ; (semikolon) or another char used as delimiter
{{ form.delimiter_is_tab.errors }}
{{ form.delimiter_is_tab }}
If this CSV (comma seperated values) is a TSV (tab seperated values)
Quotechar
{{ form.quotechar.errors }}
{{ form.quotechar }}
Leave empty for default " or set to another char used as quotechar (i.e. if a field contains a text with more than one line the next line shound not be considered as new row if in quote chars)
{{ form.escapechar.errors }}
{{ form.escapechar }}
Leave empty for none or set to another char like \ used as escapeechar)
{{ form.doublequote.errors }}
{{ form.doublequote }}
Quote chars inside quotes are masked by doubling the quote char