Heeeey lemlister! 👋

I bet you're ready to get rid of these � annoying diamond wrapped question marks... I am right? Just so you know, that's because you'll have to make your .CSV a UTF8 encoded file, because that's where it comes from.

Here's how to solve this problem: import your CSV into Google Docs, then export it into CSV.

Just in case, here's an extensive guide from PractiTest that I selected to give you an extra hand:

UTF-8 CSV File for importing

When you have issues uploading a .CSV file into you need to make sure the .CSV file is saved with the current encoding (UTF-8). This is especially important for non-English characters.

MS-Excel is known to save CSV files in different encoding standards, depending on the OS of the machine where it is installed. For this reason, it is recommended to save CSV files using other programs that will ensure the file is set to the correct encoding:

Saving as UTF-8 with Open Office

1️⃣. Open your file (if you have an option, open it as a UTF-8 File)

2️⃣. File 👉 Save As…

3️⃣. File Type 👉 Choose Text CSV

4️⃣. Character Set 👉 Choose “Unicode (UTF-8)”

5️⃣; Field delimiter 👉 , (comma)

Saving as UTF-8 with Google Docs

1️⃣. Start by uploading the file to Google Docs. Click on the Upload menu (1) In your Google Docs account, and then choose Files from the dropdown menu.

2️⃣. Select the file you would like to upload. this will open the Upload Settings window.

3️⃣. Make sure the first option is selected (“convert documents, presentations, spreadsheets, and drawings to the corresponding Google Docs format”), and click “start upload”.

4️⃣. Once uploaded, double-click on the file to open it in a new window.

5️⃣. Go to File –> Download As – and select CSV (notice that CSV format does not support multiple sheets in Excel).

The downloaded file will be saved with UTF-8 formatting and will be displayed correctly when uploaded into Lemlist.

Still need a hand to fix you CSV?

No worries, just reach out to us in the chat my lemlister.

Enjoy ❤️

Did this answer your question?