Sometimes when you export an file in CSV the characters are in a different language and turns out funky looking. Here’s how to fix it.
- Open it in notepad
- Save it as a txt file
- Reopen the file Excel
- Save as CSV UTF-8
- Then open up again, and it should be okay
You can see above there are two types of CSV, but there are actually more. This is what causes the issues it reads differently. It’s best to use XSL file, if not it’s okay!
Hope that helps!
Leave a Reply
You must be logged in to post a comment.