Skip to content

Instantly share code, notes, and snippets.

@Unayung Unayung/CSV Import
Created Aug 22, 2013

Embed
What would you like to do?
1. 使用 Office for Mac 開啟 Excel 檔案.
2. 如有亂碼情況,先選取全部資料,將字型改為「蘋果儷中黑」可以消除亂碼情況.
3. 將無亂碼的檔案按下 「檔案」-> 「另存新檔」 格式選擇 Windows Comma Separated (.csv)
4. 如果 Excel 檔有多張 sheet, 會跳警告, 請確認只轉存第一張 sheet
5. 確認存檔後即可以此份 CSV 進行商品大量上傳.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.