How to fix CSV import "BLOB" error

Root Cause:

This "BLOB" error is caused when the uploaded CSV file contains non-UTF-8 format characters - such as characters with accents, or special symbols, or commas in non-text fields.

Google Sheets:

The first way to fix the BLOB error is through Google Sheets:

1. Copy and paste the information into a new document,
2. Highlight information
3. Click the drop-down menu for "Format"
4. Change to "Plain text"
5. CTRL F > click the ellipse "..."
6. Under the "Find" box, add in a comma ","
7. "Replace All" leave the box empty

Once you have changed the format you will need to save it as a CSV file:

1. Click the drop-down menu for "File"
2. Download as
3. Comma-separated values (.csv, current sheet)

Excel (Unicode UTF-8): 

*Try this method only if Google Spreadsheets does not work*

Within Excel:

1. Save as
2. Format = CSV
3. Click Tools (to the left of the Save button)
4. Click web options
5. Select the Encoding tab
6. Save Document as Unicode UTF-8
7. OK
8. Save

Excel (non-Unicode UTF-8):

Within Excel:

1. Save as
2. Format = CSV
3. Click Tools (to the left of the Save button)
4. Click web options
5. Select the Encoding tab
6. Save Document as anything other than Unicode UTF-8
7. OK
8. Save
9. Close Excel
10. Re-open the file
11. Save as
12. Format = CSV
13. Click Tools (to the left of the Save button)
14. Click web options
15. Select the Encoding tab
16. Save Document as anything other than Unicode UTF-8
17. OK