csv lines into Text Editor and upload it here, hence the RTF extensions. For some reason other users on this forum, Villeroy and Rory RF, wanted me to copy some of my.
My file was created in Calc and it has a. It's the embedded formatting, \this and \that, which makes up the remaining 300+ characters. The five lines of email addresses contain only 72 characters, plus some newlines. You must use CSV, not RTF.Įdit: Note that your attachment is 392 bytes. You can't see the embedded formatting in Writer either since Writer also understands RTF (though not as well at TextEdit). You can't see this with TextEdit since that application understands RTF and removes all the embedded formatting information (font table, color table, paper size, etc.) and displays only the data. Below is what your attachment looks like.
RTF format is not CSV format, and it's almost certain that Contacts will not accept RTF.
Import and export Outlook email, contacts, and calendarĪdd your other email accounts to Outlook.(392 Bytes) Downloaded 4 timesYou have attached a file in RTF format. Related TopicsĬreate, view, and edit contacts and contact lists in Įxport contacts from to a CSV fileĬlean up or remove duplicate contacts in If you're having trouble importing contacts to your account, see Fix problems importing contacts to. Enter a name for your file, and select CSV UTF-8 (Comma delimited) (*.csv) as your file type. In the dialog box that appears, under File Origin, choose the encoding that makes the characters in the text appear correctly, for example, Cyrillic Windows 1251, and then select Load.Ĭheck that characters are displayed correctly in Excel.
Browse to your exported CSV file (you may have to select to display Text Files (.csv) to see it). In Excel, create a new blank document (workbook).įrom the Data menu, select From Text/CSV. How to convert your CSV file to UTF-8 using Microsoft Excel 2016: How to do this will be different between apps and app versions. If you can't export your contacts using UTF-8 directly, you can convert the exported CSV file using Excel or third-party apps. Therefore, you should save the contacts file with UTF-8 encoding if you have that option during export. However, if the contact information includes characters not found in the English alphabet, such as Greek, Cyrillic, Arabic, or Japanese characters, this can cause problems when importing contacts. Typically, you can import contacts without worrying about the underlying details of how the text is stored in the CSV file.
0 kommentar(er)
