I am trying to download a fresh dataset for Fife and I am getting many records with errors. The ID column has over a thousand records with what looks like sentences/comments data. Have I done something wrong?
I have emailed an example, it is something to do with how I open the csv file I think. If I open the csv without loading it into excel it doesnt have these errors? May have to re-think my process.
There's probably a comma in there somewhere which has confused excel opening the csv