Facing error when uploading file given in a coursera course

Question

I am in the middle of a course in coursera (Google Data Analytics)titled: "process Data from Dirty to Clean". In this course's 3rd module they gave a CSV file to upload in BigQuery to create a Table but when I uploaded the file a massage popup that says "CSV processing encountered too many errors". I didn't change or modify or did anything with that file but it's not working.

I followed the instruction step by step given in the course several time and expecting to create a Table in BigQuery with that file. I am uploading as csv files, edit as text.

Answer 1

When you download the data, the best way is to download it as a workbook. When you force it to be a csv then it looks like this .

What I did was to download it as an Excel document and then upload it to Google Sheets before downloading it as a CSV (Google Sheets has that option).

Now you can load your data from Google Sheets or download a CSV and upload it to BQ. I am feeling a bit lazy to code but you could also open the Excel file in Python for example and save it as a csv or save it directly to BQ using pandas_gbq.

Final output.