On 16 January 2023, Max wrote:

> Does anyone know a tool or hack to help fix a problem at a CSV that's
> causing a "The rows are not all the same number of columns." error when
> trying to import the CSV at a web application?

At a shell, this could help narrow things down:

$ cat foo.csv
one,two,three
two,three,four
three,four,five,six
four,five,six
$ while read line; do echo $line | tr -dc "," | wc -m; done < foo.csv
2
2
3
2

There's no counter to show you which line has the strange number of commas, but 
you could do this after you've eyeballed it and seen most have two:

$ while read line; do echo $line | tr -dc "," | wc -m; done < foo.csv > counts.csv
$ grep -v 2 -c counts.csv

This ignores "quoted,commas,in,one,column" but if there aren't too many of them 
they won't get much in the way.

Bill

--
William Denton
https://www.miskatonic.org/
Librarian, artist and licensed private investigator.
Toronto, Canada
CO₂: 419.29 ppm (Mauna Loa Observatory, 2023-01-15)