Click on the Upload button, choose "Files", and find your csv file on your computer or a drive you're connected to (such as Homeserver).įrom "My Drive" in Google, find the csv file you've uploaded, right-click the file, choose "Open with", then select "Google Sheets".Īs you'll see, Google Sheets preserves the special characters and displays them correctly.įrom the "File" menu, select "Download as", then select "Microsoft Excel (.xlsx)". However, if you first open the file in Google Sheets, the special characters will be preserved. When you generate or receive a csv (comma-separated value) file that contains special characters from the UTF8 character set (é, for example), Excel for the Mac will not properly preserve the special characters. Search the Help Desk Search Converting csv files with UTF8 Data for Excel on the Mac
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |