How do I open a UTF-8 CSV in Excel without encoding issues?

Excel struggles with UTF-8 unless the file declares a BOM (byte-order mark). If your CSV shows garbled characters in non-ASCII URLs (foreign-language paths, accented characters), three fixes. First: import via Data → Get Data → From File → From Text/CSV, and explicitly set File Origin to '65001: Unicode (UTF-8)'. Second: re-save the CSV with UTF-8 BOM — in VS Code, change the encoding picker at the bottom-right to 'UTF-8 with BOM' and save. Third: open in Google Sheets first, which handles UTF-8 cleanly by default, then download as CSV. xmlsitemapmaker.com writes UTF-8 without BOM by default for maximum tool compatibility; the import flow handles the rest.