Microdeck.tools 100% 瀏覽器本地執行

Excel / CSV 檔案結構分析與錯誤檢查器

New

針對 CSV 或 Excel 檔案建立資料輪廓 (Data Profiling):統計行列數、欄位資料型別、缺失值與唯一值比例、極值與不規則錯位行。

100% 瀏覽器本地執行 不上傳至伺服器 即時顯示結果
Choose a CSV, TSV or Excel fileFiles stay on your device.

5 rows × 4 columns

  • 1 duplicate row
  • 1 completely empty row
  • 0 rows with a different number of cells than the header
ColumnTypeFilledEmptyUniqueMinMaxSpacesMost common
Nametext413 an nguyen chi le2 an nguyen (2), BINH TRAN (1), chi le (1)
Email text322AN@example.combinh@example.com0AN@example.com (2), binh@example.com (1)
Citytext413 Da Nang Hue1Hanoi (2), Da Nang (1), Hue (1)
Amountmixed4131,250.509801,250.50 (2), 2.300,00 (1), 98 (1)

Types are guessed from the values. “mixed” means a column holds more than one kind of value, for example numbers and words. “Spaces” counts cells with spaces at the start or end.

這個工具替您省下寶貴時間了嗎? 歡迎自願贊助,協助 Microdeck 維持免費與穩定運作 · 最低 $3 起。

底層運作原理

Choose a file or paste CSV. The tool shows a summary and a table with one line for every column.

詳細操作步驟

1

Choose a file or paste CSV.

2

Read the summary and column table.

3

Fix issues with the CSV cleaner.

核心功能與效能優勢

  • Column type guess
  • Empty and unique counts
  • Min and max
  • Duplicate and ragged rows
  • Most common values

運算方法、公式與技術標準

Every column is scanned once; each value is classed as integer, number, date, boolean or text, and a column with more than one class is shown as mixed.

實作範例與邊界案例

A 5-column customer file

輸入
Result
輸出
Types, 1 duplicate row, 1 mixed column

使用限制與精準度說明

  • • Types are guesses from the values.
  • • Only the first sheet of an Excel file is read.

瀏覽器本地運算與隱私保障

傳統線上轉換網站會將您的文件、文字片段或影音檔案上傳至遠端伺服器。Excel / CSV 檔案結構分析與錯誤檢查器 完全在您的瀏覽器分頁內運行:

於此分頁本地處理

您的檔案與文字都在裝置本機計算,不會傳送內容至任何後端伺服器。

絕不記錄操作內容

Microdeck 不會記錄或儲存您在工具內貼上的任何檔案或程式碼。

分頁記憶體即時釋放

所有暫存結果僅存在目前分頁記憶體中,重設或關閉分頁後即刻清除。

常見問題 (FAQ)

What does mixed mean?

The column holds more than one kind of value, for example numbers and words.

Is anything uploaded?

No. Everything runs in your browser and your data stays on your device.

探索相關微型工具

支持 Microdeck

完全自願 · $3 起 · 免註冊帳號

選擇金額 (USD):已選金額:$5

單次最低贊助金額為 $3 USD。

完全自願 · $3 起 · 將透過 Gumroad 安全結帳頁面完成。