Saving a file in UTF-8 Format

Windows:

In Microsoft Excel

1. Open the *.xlsx file from Excel.
2. Click Menu | Save As (Other Formats).
3. Put any name for the file and choose “Unicode Text (*.txt)” for “Save as type :.”
4. Click Save.

In Notepad

5. Open the unicode text file using Microsoft Notepad.

– Some characters can look like a box, this is because Notepad can’t display some unicode characters, you can ignore this.

6. The file needs to be tab delimited, replace tabs with a comma (“,”).

– Select a tab character by dragging the character between two column headers and press ctrl+c.
– Replace all tab characters with comma using Replace function ctrl+H.

JJNlSJBAtp

 

7. Click Save As.
8. Name the file, and change the Encoding: to UTF-8.
9. Change the file extension from “*.txt” to “*.csv”.
10. Click Save.

– The file icon should be changed to MS Excel now. If it is not changed, check Windows Folder options.

Back in Excel

11. Open the CSV file and verify if the data is okay.

– If you run into a problem in this step, don’t save the file in Excel, it’ll cause encoding issues. Just check the data only in Excel.

You can use this CSV file for importing through Import Wizard or Apex Dataloader. If you’re using the Import Wizard, make sure that you choose right encoding option “Unicode (UTF-8)” on “Upload the file” step.

If you’re still having encoding issues, you can try these steps:

1. Find the file.
2. Right click on the file | click Open With.
3. Click Notepad.
4. Click File | then Save As.
5. Navigate to the folder where you want to save your file.
6. Provide a name for your file.
7. Add .csv to the end of the file.
8. Make sure that the encoding is set to UTF-8.
9. Click Save.
10. Open the newly created file.
11. Make sure that everything is correct

OSX

You can make sure TextEdit saves files in Unicode (UTF-8) by going to TextEdit > Preferences… > Open and Save, and making sure the Save As setting is “Unicode (UTF-8)”.

Choose “Unicode (UTF-8)” for the Save As setting to ensure TextEdit saves documents in UTF-8

Rate This Article

(3 out of 12 people found this article helpful)
Post Comment

6 comments

  1. JOHN CARUSO

    I have tried several times to import contacts and have failed. This last time I used contacts.ldif and it was rejected. I do not know how to convert to UTF-8. Please respond.

  2. Proton Editor

    The file format you are trying to use is unsupported. ProtonMail supports importing of .csv (Comma separated values) and .vcf (vCard) files. Please try exporting your contacts to one of these two formats.

  3. el

    i also tried but failed. its way to complicated for the normal user. you need to be a computer scientist to import contacts on protonmail.

  4. ProtonMail Support

    Please contact our support team using the support form: https://protonmail.com/support-form, at contact@protonmail.ch or support@protonmail.ch.

  5. Erin

    I agree with the commenter above. This is far too complicated for an ordinary user who just wants to import a file.

  6. ProtonMail Support

    Importing contacts should work without any issues, depending on how the source service exports the file. If you are having trouble importing a contact file, please contact our support team at https://protonmail.com/support-form.

Leave A Comment?