CSV 編輯器

未載入CSV資料

關於此工具

CSV編輯器是一個基於瀏覽器的工具,讓您可以用類似試算表的介面查看、編輯和管理CSV檔案。點擊任意儲存格即可編輯,隨時新增或刪除列和欄,然後即刻匯出。所有處理都在您的瀏覽器本地完成——沒有伺服器上傳、沒有資料收集,您的檔案保持私密。

主要功能

  • 視覺化表格編輯器:在直觀的試算表風格網格中處理CSV資料
  • 內嵌儲存格編輯:點擊任意儲存格編輯其值——更改立即生效
  • 新增/刪除列和欄:透過簡單控制項修改表格結構
  • 多種分隔符:支援逗號、分號、制表符和管道分隔符
  • 標題列切換:標記首列為標題以更好地組織資料
  • 100%客戶端處理:您的資料從不離開瀏覽器

常見用例

  • 在匯入資料庫前清理CSV檔案——修正錯誤、刪除重複項、填充遺失值
  • 編輯WhatsApp群發收件人清單——無需Excel即可更新電話號碼和姓名
  • 為QA和開發準備測試資料——快速產生或修改CSV資料
  • 在系統間轉換資料——新增欄位、重構配置、映射欄位
  • 更新包含多語言翻譯字串的本地化檔案
  • 無需啟動笨重的試算表應用即可快速編輯

如何使用

  1. 1.上傳您的CSV檔案或載入範例資料集開始使用
  2. 2.點擊任意儲存格編輯其值——表格即時更新
  3. 3.使用'新增列'在底部插入列,或'新增欄'在右側新增欄
  4. 4.點擊列或欄標題中的垃圾桶圖示即可刪除
  5. 5.從選項欄選擇您的分隔符(逗號、分號、制表符或管道)
  6. 6.完成後點擊下載,以您喜好的分隔符匯出為CSV

無論您需要清理資料、更新聯絡人清單還是準備測試檔案,CSV編輯器都為您提供直接在瀏覽器中處理CSV資料的快速私密方式。無需Excel、無需檔案上傳——只需開啟、編輯和下載。

What is CSV Editor?

CSV Editor is a browser-based spreadsheet-style editor for opening, editing, sorting, resizing, and exporting CSV files without sending the file to a server. It supports comma, semicolon, tab, and pipe delimiters, preserves quoted values, and keeps data local to the browser.

How to use it

Upload a CSV file, paste CSV text, or load a sample dataset. Edit cells inline, add or delete rows and columns, sort by clicking a column header, drag column borders to resize, and download the edited CSV when finished. Toggle Header when the first row should be treated as column labels.

Large files

The table uses virtualization for the default non-wrapped view so large CSV files can be inspected without rendering every row at once. Files above 100,000 data rows are capped for browser safety, and very large datasets may skip autosave with a warning so users can download a copy instead of relying on browser storage.

CSV compatibility

Parsing and export are handled with Papa Parse. Quoted commas, escaped quotes, quoted newlines, empty cells, Unicode text, duplicate column names, missing trailing values, and extra trailing values are normalized into a consistent editable table and round-trip through export.

Privacy and persistence

CSV content is processed locally in the browser. Small and medium sessions autosave to IndexedDB after changes, while display preferences such as wrap text and auto-fit stay in localStorage. Clear removes the current editor session from local browser storage.

Limitations

Browser memory, storage quota, and main-thread parsing limits still apply. Extremely wide files, very long cell values, or very large row counts can be slower than a desktop spreadsheet or database tool. Split oversized CSV files before editing when possible.