Csv File That Doesn'T Have Commas Excel Update Your Browser

Csv File That Doesn'T Have Commas Excel Update Your Browser

Please update your browser to the latest version on or before July 31, 2020.

Unfortunately, both Mac and PC users have to avoid corrupting the exported file.

Excel treats the exported file differently for both PCs and Macs, and both operating systems have separate errors that can occur resulting in an Invalid CSV File failure.

They should look somewhat like the Students characters indicated in the red box in the image below.

After making changes and deleting these characters, it is important to click File Save As, and ensure that the file is being saved in a Comma Separated Values (.csv) format.

After saving the file as a.csv, Excel will pop-up a prompt asking if it is okay to save the file in this format.

This file format will throw off your data, and you will need to export the gradebook again and start from scratch in order to import your grade changes successfully.

The error shown in the image above does not appear until after you close and reopen your gradebook file, so it is easy to be under the impression that everything is working as intended.

Clicking Save As will allow you to choose the correct file format, CSV (Comma Delimited).

Csv File That Doesn'T Have Commas Excel For Mac