Upload files into Spreadsheet as UTF-8
Quote:
Originally Posted by
billsstamps
I have had problems uploading spreadsheets files when they contain exported data from Ebid.
It is when I use uncommon symbols such as half, quarter, Euro.
Now I know the secret - File Origin.
Excel has a File Origin default of MS DOS PC8
Instead I have to select UTF8
OK, my memory is not what it was, and I have been forgetting to import text files, such as Ebid exports, into Excel spreadsheets as UTF-8 files.
The default is now Windows (ANSI) which corrupts yen, umlaut, and other symbols into gibberish.
Sorry I wasted support time asking the question. Again.
Now I am looking at how to change the default file origin on Excel to UTF-8. Any tips?
Export from Ebid, and updating things in a spreadsheet is much easier for me than using the bulk edit because there are more nuanced facilities for search and replace in Excel.