CSV to SQL Converter

這是一款為開發者設計的免費工具，能夠將 CSV 文件即時轉換為 SQL 的 INSERT 或 UPDATE 語句。在將 Excel 或試算表數據轉移到資料庫時，能節省大量時間並減少人為錯誤。

所有的轉換過程完全在您的瀏覽器內進行。即使 CSV 文件包含客戶名單或機密信息，也不會上傳到任何伺服器，保證數據安全。

CSV (逗號分隔值)

一種使用逗號分隔數據的純文字格式，廣泛用於與 Excel 等軟體進行數據交換。

SQL (結構化查詢語言)

用於管理和操作關聯式資料庫系統 (RDBMS) 的標準程式語言。

INSERT 語句

用於將新數據行（記錄）插入資料庫表中的 SQL 指令。

UPDATE 語句

用於修改現有資料庫記錄的 SQL 指令，通常結合 WHERE 子句使用。

轉義 (Escaping)

確保將 SQL 中具有特殊含義的字元（如單引號）視為純文字的安全處理過程。

Q.Is the CSV data I enter saved on external servers?

No, all input data is processed strictly within your PC or smartphone's browser. There is no transmission or storage of data to external servers, making it completely safe to use even with CSV files containing customer lists or sensitive information.

Q.Can it convert huge CSV files with tens of thousands of rows?

Yes, it can, but it depends on your browser's memory and processing power. Processing a few thousand to tens of thousands of rows usually completes in seconds. However, for extremely large files exceeding 100,000 rows, we recommend splitting the file before conversion to prevent browser freezing.

Q.How are numeric and string data distinguished?

The tool automatically analyzes the value of each cell internally. If it consists only of numbers (or numbers with a decimal point), it is treated as a number and quotes are removed. This automatic inference can also be disabled in the options, allowing you to force all values to be quoted as strings if required.

Q.How are NULL values or empty cells handled?

Empty cells or the string 'NULL' are output to SQL as `NULL` without quotes so that they are treated as official NULLs in the database. If you intentionally want them registered as empty strings (`''`), please adjust the CSV data beforehand or manually tweak the generated SQL.

Q.Can I use the output with both MySQL and PostgreSQL?

Yes, the basic INSERT and UPDATE statements are generated using standard SQL syntax, so you can use them directly in major relational databases like MySQL, PostgreSQL, SQLite, and SQL Server. If specific functions or dialects are required, please replace them in the output SQL using a text editor.