Heeeey lemlister! 👋

I bet you're ready to get rid of these � annoying diamond wrapped question marks... Am I 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:

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:

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)

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.

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

Enjoy ❤️