I've opened thousands of CSV files directly in Excel and never had one not open correctly (unless the file itself was not valid CSV, especially with things not quote-enclosed properly).

It's likely I've mostly had to deal with ASCII / Latin alphabet, so don't know how well it handles unicode.