Open Downloaded CSV files in UTF-8

Sometimes, downloaded CSV files can show converted characters (e.g., dashes '-' turn into Äî). This happens when your default application to open a CSV file is Microsoft Excel which sets your setting to Macintosh format instead of UTF-8.

There are two ways to ensure your file opens in UTF-8:

• Convert the file to UTF-8 in Mac Excel
• Open the file in Google Sheets

Option 1: Convert to UTF-8 in Mac Excel

1. Download the desired CSV in Lattice. 
2. Create a New file.
3. Navigate to File > Import > CSV File.
4. Select the downloaded file and select Get Data.
5. For the data type, select Delimited.
6. For the file origin, select Unicode (UTF-8).
7. Add Comma as Delimiter and select Finish.

Option 2: Open in Google Sheets

1. Download the Calibration CSV. 
2. Within Google Sheets, navigate to File > Import > Upload. 
3. Drag the downloaded file into the uploader. 
4. Click Import data.