[已解決]open data CSV亂碼

tags: `public`

來源:https://data.gov.tw/dataset/24333

Image Not Showing Possible Reasons

The image file may be corrupted
The server hosting the image is unavailable
The image path is incorrect
The image format is not supported

藍色OK|檔名: A2_Location.csv
紅色X|檔名:19e47f685116dbc3a935994a7fa6b4dc_export.csv

解決

先
閱讀官方文件-亂碼處理說明
再看
教學文章

結論: 編碼格式=UTF-8 with BOM，EXCEL預設開啟檔案編碼為ANSI編碼，需要轉碼才能打開!
記取教訓: 以後文件一律先已VScode打開再說

附上包含經緯度的CSV 2萬多筆資料

https://docs.google.com/spreadsheets/d/1Lkiuo75b2-ESzRBC7BnMbIyQEckfbsH6bjPYOZoDOz0/edit?usp=sharing

Image Not Showing Possible Reasons

The image file may be corrupted
The server hosting the image is unavailable
The image path is incorrect
The image format is not supported