Excel to CSV
Export one worksheet or every worksheet as CSV files
Excel to CSV — what it does
Export one worksheet — or every worksheet at once — from an Excel workbook to CSV. Formulas leave as their calculated values, formatting falls away, and what remains is the plain, portable text file that databases, scripts and import routines actually want to consume.
When this tool helps
- Preparing workbook data for a system that only imports CSV.
- Extracting every sheet of a multi-tab workbook into separate files in one pass.
- Converting a colleague's formatted spreadsheet into data a script can parse.
How to use it
- Choose the Excel file.
- Select a worksheet, or tick export all worksheets.
- Process the export.
- Download the CSV file or files.
Accuracy, limits, and good practice
- CSV holds one table per file — merged cells, colours, charts and multiple header rows do not survive, by design.
- Check date columns after export: what CSV records is the formatted text, and reimporting tools may parse it differently.
- Long numbers such as card or account identifiers should be verified — the value exported is what Excel held, which may already be truncated.
- Export the sheet you actually need rather than all of them: a folder of CSVs named after forgotten scratch tabs is its own small mess.
Frequently asked questions
Do formulas come through?
Their results do. CSV is a value format, so the calculation logic stays behind in the workbook.
What encoding is the output?
UTF-8, which preserves accents and CJK text. Tell the receiving system the encoding if it asks.
How are multiple sheets delivered?
As one CSV per worksheet, so each file remains a single clean table.
What happens to merged cells?
CSV has no concept of merging, so the value lands in one cell and the rest come through empty.
Related tools on this site
- CSV Column Statistics — Calculate numeric and uniqueness statistics for one column
- Split CSV by Column — Create separate CSV files for each field value
- Excel Sheet Renamer — Rename worksheet tabs and export a new Excel workbook
Everything above runs inside this page. Excel to CSV needs no account, no upload, and no server round trip — close the tab and nothing is left behind.
Excel 轉 CSV能做什麼
從 Excel 活頁簿匯出單一工作表——或一次匯出全部工作表——成 CSV。公式以計算結果離開、格式全部褪去，留下的就是資料庫、腳本與匯入程式真正想要的純文字可攜檔案。
什麼時候用得上
- 為只接受 CSV 匯入的系統準備活頁簿資料。
- 一次把多分頁活頁簿的每個工作表拆成獨立檔案。
- 把同事排版過的試算表轉成腳本能解析的資料。
使用步驟
- 選擇 Excel 檔案。
- 選定工作表，或勾選匯出全部工作表。
- 執行匯出。
- 下載 CSV 檔案。
精確度、限制與實務建議
- CSV 一檔一表——合併儲存格、顏色、圖表與多列標題都不會留下，這是格式本質使然。
- 匯出後請檢查日期欄：CSV 記錄的是格式化後的文字，再次匯入的工具可能以不同方式解析。
- 卡號、帳號等長數字請驗證——匯出的值就是 Excel 裡存的值，可能早已被截斷。
- 請只匯出真正需要的工作表：一整包以被遺忘的暫存分頁命名的 CSV，本身就是另一種混亂。
常見問題
公式會過去嗎？
結果值會。CSV 是數值格式，計算邏輯留在原活頁簿裡。
輸出是什麼編碼？
UTF-8，可保留重音字與中日韓文字。接收系統若詢問編碼，請告知 UTF-8。
多個工作表怎麼交付？
每個工作表各一份 CSV，讓每個檔案都維持單一乾淨表格。
合併儲存格會怎樣？
CSV 沒有合併的概念，值會落在其中一格，其餘幾格則是空白。
本站相關工具
- CSV 欄位統計 — 計算指定欄位的數值與唯一值統計
- 依欄位拆分 CSV — 依指定欄位值建立多個 CSV 檔案
- Excel 工作表重新命名 — 重新命名工作表分頁並匯出新的 Excel 活頁簿
以上步驟全部在這個頁面內完成，Excel 轉 CSV 不需要註冊、不上傳檔案、也不經過伺服器，關閉分頁後不會留下任何資料。