I'm using Excel, and when I open the CSV that I downloaded, any non-English or formatting characters like bullet points are all messed up. What's going on?
A. Oddly enough, Excel doesn't read CSVs properly out of the box. You actually can't just open a CSV with Excel and expect it to work properly. You have to "import" it though other office suites like LibreOffice will open it up just fine. To fix this, read more on the subject here.