將試算表格式(.xls)(.ods)轉換為文字檔(.csv)(.txt)
1.開啟免費的文書軟體 OpenOffice
2.點選試算表新建檔案或直接開啟範例檔
3.將編輯完成的試算表(.xls)(.ods),選擇"另存新檔",並選擇"文字CSV"格式(.txt格式不見了 "_"),勾選"編輯篩選設定"
4.選擇"保留目前格式"儲存
5.將輸出的字型選擇"Unicode(UTF-8)",按確定
6.可用筆記本軟體開啟(.csv)檔案,或將附屬檔名(.csv)改成(.txt),這樣也行^_^
7.成功的將試算表欄位轉換成用逗點隔開的文字檔
引文:
How do I output my spreadsheet data as an ASCII, delimited text file?
- Select: File - Save As... from the main menu
- In the Save as dialog that appears, select File type Text CSV (.csv; .txt) from the list of spreadsheet file types.
Press T several times in the list to quickly jump to that entry.
- Click to enable the box next to Edit filter settings.
- Click Save.
- In the Export of text files dialog box that pops up, enter the field and text delimiters of your choice.
The Text delimiter is the character that will surround any text entries in your spreadsheet, to keep each phrase together as an entity, when the file is exported into ASCII format.