Part 3 of 6

How data is damaged on the way in

Separators, encodings, dates and everything the sheet decides is a number before you can object.

Teams applying the checks in this entry can also compare operational tools for employee monitoring, keeping time and review ownership outside the calculation file itself.

7of 7 written

0in preparation

Entries

3.1A comma-separated file is a convention, not a format 3.2Dates, and what the locale decides for you 3.3Leading zeros, long numbers, and everything a sheet treats as a number 3.4Encodings, and the question marks in an export 3.5Separators, quoting, and line breaks inside a field 3.6When an import becomes a process 3.7Stacking exports, and what happens when the columns disagree

src

For further context, see Microsoft guidance on text and CSV files.