How to Change File Encoding to UTF-8 in Excel

If you see unreadable characters when importing contacts, as in the screenshot, it means that the file encoding is not suitable for importing to UniSender. The file must be converted to UTF-8. Fortunately, this is easy to do and we will tell you how.

unreadable numbers.

 

Go to the Data tab and select “From Text”.

getting data from text.

 

The text import wizard dialogue will open.

With current encoding, the file content is unreadable.

In the “File origin” field, we look through the encodings until we find the one where the text is displayed correctly. Find the desired format, click "Next".

current encoding.

choice of encoding format.

 

Select delimiting characters. In our case, this is a comma.

select the separator characters.

 

This is what the imported text looks like in Excel.

How does the document look like in Excel.

Now click "File" → "Save as".

Name your file, select CSV file type, and click "Tools" → "Web Options" below.

save the file.

 

Go to the Encoding tab, In the dropdown for Save this document as: choose Unicode (UTF-8) and click "OK".

choose the encoding.

 

The file is saved.

Now we import it and see that the text is displayed correctly.

wright import.

Useful links:

Preparing Contacts for Import
How to import your contact base
How to Import Phone Numbers
How to Use the Import Error Report
How to Remove the Inactive Contacts From Your Database

Did we answer to your question?

3
0