How to Convert CSV file to SQL Script using Notepad++

Created: 26th Jan 26 1 Views
Review needed
Verified
Loading...
Loading...
Comments

If you have a .csv file and you want to convert it into an SQL insert Query (be MySql, SQLite, Oracle), this can be done in just a few simple steps using Notepad++ Find and Replace with some Regular Expressions.

GIF showing csv to sql script using Notepad++
GIF showing csv to sql script using Notepad++
  1. Open the CSV (Comma Separated Values) file in Notepad++

    2. Our Sample CSV Data :

    1,data1,data-a,323
2,data2,data-b,324
3,data3,data-a,325
4,data4,data-b,326
5,data5,data-a,327
6,data6,data-b,328
  2. Enclose each data values in CSV file with Single Quotes.

    3. Open Find and Replace by pressing "Ctrl + F", go to replace tab and,

    Find : ,
Replace with : ','

    Result :

    1','data1','data-a','323
2','data2','data-b','324
3','data3','data-a','325
4','data4','data-b','326
5','data5','data-a','327
6','data6','data-b','328

    Now data values are enclosed with Quotes, expect the row start and end. For this we need to use Regular Expression.

    Comments & Discussion

    Facing issues? Have questions? Post them here! We're happy to help!