Is there anything you would like to know?
Text appears garbled when opening a task CSV file

Description:

It is normal when opening the csv file with Excel on your PC, but it is garbled when sending to others. "File owner" must first save the CSV file as UTF-8 encoding.

 

Solution:

  1. Open the csv file with Microsoft Excel and Save as type as CSV (Comma delimited) (*.csv) option
    1. Open the csv file with Excel;
    2. Select Save as type as CSV (Comma delimited) (*.csv) option;
    3. Resend the csv file or import it to Teampel.
       
  2. Open the csv file with Notepad and Save as using UTF-8 encoding:
    1. Open the csv file with Notepad;
    2. When Save as new file, use UTF-8 encoding;
    3. Resend the csv file or import it to Teampel.
       
  3. Open the csv file with Libre Office and Save as CSV:
    1. Open the csv file with Libre Office;
    2. Go to File > Save as. When Save as new file, select Text CSV (.csv) from the Save as type drop-down.
    3. Check the Edit filter settings options > Save;
    4. From the Export Text File dialog box that appears, select the Unicode (UTF-8) option from the Character set drop-down. Set the field and text delimiter as you wish or leave as is > OK;
    5. Resend the csv file or import it to Teampel.
       
  4. Open the csv file with Google Spreadsheet and download as CSV:
    1. Upload and open the csv file with Google Spreadsheet;
    2. Go to File > Download as, and select Comma-separated values (.csv, current sheet) option;
    3. Resend the downloaded csv file or import it to Teampel.
       
  5. Open the csv file with Apple Numbers and Export To CSV:
    1. Open the file with Apple Numbers;
    2. Go to File > Export To  > CSV;
    3. Under Advanced Options, select Unicode(UTF-8) option for Text Encoding > Next… > Export;
    4. Resend the csv file or import it to Teampel.

Couldn't find the answer you need?

Contact our support team.