Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

如果 CSV 檔案是以 BOM (Byte Order Mark) 儲存,則可以正常開啟以 UTF-8 編碼的 CSV 檔案。 否則,您可以透過下列其中一種方式開啟它。

  1. 透過 PQ (Power Query) 使用 [取得資料] 下拉式清單。 流覽至 [資料] 索引標籤>檔案取得資料 > >從文字/CSV 取得資料。   
    透過 [資料] 索引標籤開啟 txt/csv

  2. 使用 [從文字取得資料] 選項。 此選項可在 [操作說明搜尋] 和功能區中使用。

    [從文字取得資料] 選項 它會開啟文字彙入精靈,不會建立活頁簿的外部連結。


Need more help?

Want more options?



Was this information helpful?

How satisfied are you with the translation quality?
What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!