CSV to SQL Converter

Ek CSV ko MySQL, PostgreSQL, SQLite, ya SQL Server ke liye SQL INSERT statements mein badlein, seedhe aapke browser mein. Aapka data aapke device par rehta hai.

CSV to SQL Converter poori tarah aapke browser mein chalta hai. Jo CSV aap paste ya drop karte hain aur jo SQL yeh generate karta hai woh kabhi aapke device se bahar nahi jaate aur kuch bhi ArrayKit ko upload nahi hota.

SQL Formatter kholein

CSV to SQL Converter ke baare mein

CSV to SQL Converter ek CSV file ko ready-to-run SQL mein badal deta hai. Apna data paste ya drop karein, ek dialect pick karein — MySQL, PostgreSQL, SQLite, ya SQL Server — aur yeh har column ka type infer karta hai, table aur column names ko us dialect ki tarah quote karta hai, aur har value escape karta hai taaki single quotes, empty cells, numbers, aur booleans sahi aayein. Aapko per row ek INSERT ya ek batched multi-row INSERT milta hai, plus ek optional CREATE TABLE taaki aap scratch se ek schema seed kar sakein. Yeh un developers ke liye bana hai jo ek dev database seed kar rahe hain, ek spreadsheet export import kar rahe hain, ya ek migration likh rahe hain aur chahte hain ki SQL unke liye generate ho, hazaaron values hand-type karne ke bajaye. Poora conversion aapke browser mein hota hai, isliye jo CSV aap load karte hain woh kabhi aapke device se bahar nahi jaata.

Features

CSV to SQL Converter kaise use karein

  1. Apna CSV paste karein ya ek .csv file chunein — pehli row ko header rakhein
  2. Target dialect pick karein: MySQL, PostgreSQL, SQLite, ya SQL Server
  3. Table name set karein aur agar aapko schema chahiye to CREATE TABLE on toggle karein
  4. Generated SQL copy karein ya use ek .sql file ke roop mein download karein

Example

Input

id,name,active
1,O'Brien,true
2,Ada,false

Output

INSERT INTO `my_table` (`id`, `name`, `active`) VALUES (1, 'O''Brien', 1);
INSERT INTO `my_table` (`id`, `name`, `active`) VALUES (2, 'Ada', 0);

O'Brien mein apostrophe escape ho jaata hai aur MySQL ke liye booleans 1 aur 0 ban jaate hain.

Common errors aur troubleshooting

Aksar pooche jaane wale sawaal

CSV to SQL Converter har column ka type kaise decide karta hai?
Yeh ek column ki har non-empty cell scan karta hai. Agar woh sab whole numbers hain to integer use karta hai, sab decimal wale numeric hain to float, sab true/false-style tokens hain to boolean, aur baaki mein text. 007 jaise zero-padded numbers text rehte hain taaki leading zeros na khoyein.
Mere data mein single quotes aur apostrophes kaise handle hote hain?
String values single quotes mein wrap ho jaati hain aur koi bhi embedded single quote double ho jaati hai (''), jo standard SQL escaping hai. Isliye O'Brien 'O''Brien' ban jaata hai aur chaaron dialects mein safely run karta hai.
Empty cells ke liye yeh kya SQL generate karta hai?
Empty cells aur tokens NULL, NA, aur N/A ek empty string ke bajaye SQL keyword NULL ban jaate hain, taaki aapki rows blank text ke bajaye asli nulls ke saath insert hon.
Kya yeh rows insert karne ke saath table bhi create kar sakta hai?
Haan. CREATE TABLE on karein aur yeh aapke dialect ke liye mapped ek column type wala CREATE TABLE statement emit karta hai, phir INSERTs. MySQL, PostgreSQL, aur SQLite IF NOT EXISTS use karte hain taaki script re-runnable rahe.
Multi-row INSERT option kis liye hai?
Default roop se har row apna khud ka INSERT statement hai, jo padhna aur diff karna aasaan hai. Multi-row INSERT kai rows ko ek shared VALUES list wale ek statement mein group karta hai, jo MySQL, PostgreSQL, aur SQLite mein bade files tez load karta hai.
Kya SQL generate karne ke liye mera CSV upload hota hai?
Nahi. Parsing aur SQL generation poori tarah aapke browser mein JavaScript se chalti hai. Jo CSV aap paste ya drop karte hain woh kabhi ek server ko nahi bheja jaata, isliye sensitive spreadsheet exports aapke device par rehte hain.

Related tools

Saare ArrayKit tools