Search code examples
encodingutf-8looker-studio

can't upload csv file with cyrilic data to google data studio - encoding utf-8 error

Basic Googling revealed I should save my file as CSV file. I did and uploaded again - the error is still there:

This file has processing errors.
Row 2: Invalid characters in the file. Only UTF-8 encoded characters are supported.

Some columns have Cyrillic names, "address", "name".

How do I solve this?

Solution
    • What's the objective (CSV or to get the data to Google Data Studio)?
    • If the aim is to load the data from the Excel file to Google Data Studio, there are two approaches:

    1) CSV UTF-8

    Was the file saved as a CSV or was it specifically encoded as a UTF-8 CSV (images from Dear Systems, 2019)?

    Step 1:

    Step 1

    Step 2:

    Step 2

    Step 3:

    Step 3

    2) Google Sheets

    • Load the Excel file (as is) to Google Drive;
    • Open the Excel file in Google Drive and save as a Google Sheet;
    • Use the Google Sheet as the Data Set when creating the Data Source and subsequently the Google Data Studio Report.

    Update with a GIF

    • Alternatively, you could Copy from Excel and Paste in Google Sheets:
      • Select All (Excel): Ctrl + A
      • Copy (Excel): Ctrl + C
      • Paste Values (Google Sheets): Ctrl + Shift + V