Understand your files

A clear explanation.
A fix you can check.

Short, practical guides to the problems that appear between an export and an import. Each includes an example, a next step, and its limits.

Treat product codes and postal codes as text, before a spreadsheet changes them.

Check the separator, preview the records, and export the delimiter you need.

Understand UTF-8, the byte order mark, and what an encoding change can recover.

Read a tricky record correctly instead of splitting on every comma.

Choose a safe key, compare the removed records, and keep the first occurrence.

Separate empty records from missing cells and meaningful quoted line breaks.

A clear explanation.A fix you can check.