Excel is good at messing up data files, doubly when encoding are involved!
Before converting to data.json it would be good to add a check for the strcuture and consistency of the CSV to find bad encoded characters, line breaks etc.
This tool is useful https://csvlint.io/
It has an API too...
Excel is good at messing up data files, doubly when encoding are involved!
Before converting to data.json it would be good to add a check for the strcuture and consistency of the CSV to find bad encoded characters, line breaks etc.
This tool is useful https://csvlint.io/
It has an API too...