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.

- Open the CSV (Comma Separated Values) file in Notepad++
- Enclose each data values in CSV file with Single Quotes.
- Forming the Query Go to Find and Replace,
- Now lets complete the Sql script.
- [Solution] Notepad++ Compare option unavailable
- How to delete all text after a character or string in Notepad++
- Notepad++ hex editor Examples
- Add Custom header and footer to Windows Notepad file
- Unable to edit file in Notepad++
- Locate Notepad++ unsaved files backup location
- Add Text at Start and End of Each Line Notepad++
- [Tutorial] How to Customize Notepad++ Toolbar
- How to hide lines in Notepad++
- How to close all tabs of Notepad++?
- Notepad++ Save Failed - Please check if this file is opened in another program.
- How to connect to an FTP or SFTP location using Notepad++
- How to add or remove bookmark on a line in Notepad++
- Enabling Notepad++ Dark Theme
- Notepad++ Reload - This file has been modified by another program. Do you want to reload it?
- Prettify JSON in Notepad++
- Portable Notepad++ for windows
- Alternatives for Notepad++ on Mac in 2021
- Indent XML Formatting In Notepad++
- Go to Line Number option in Windows Notepad
- Word count in Notepad++
- Show Notepad++ tabs in multiple lines instead of scroll on tab bar
- [Nopepad++] How to add text at end of each line
- How to open a new tab in Notepad++
- How to open Notepad?
- How to upgrade pip/pip3 package installer for Python - PIP
- How to Save Eclipse console logs in external log file - Eclipse
- zsh hello world example - Linux
- How to repeat background image in Android Activity - Android
- #HappyBirthdayJimin trending Happy Birthday Jimin BTS Army - BTS
- import servlet API to eclipse project (javax.servlet cannot be resolved error) - Java
- Disabling Spell Check in Android Studio - Android-Studio
- [Solved] Notepad++ Menu Bar Missing - NotepadPlusPlus
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
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.
Find : ^
Replace : insert insert myTable values\('
^ is a regex character to add data at the start of each line in the file.
Keep in mind to select "Regular Expression" in Search Mode. \ (slash) is an escape character for braces in the regex.
Result :
insert insert myTable values('1','data1','data-a','323
insert insert myTable values('2','data2','data-b','324
insert insert myTable values('3','data3','data-a','325
insert insert myTable values('4','data4','data-b','326
insert insert myTable values('5','data5','data-a','327
insert insert myTable values('6','data6','data-b','328
Go to Find and Replace again and,
Find : $
Replace : '\);
Make sure that you select "Regular Expression" in Search Mode. \ (slash) is an escape character for braces in regex.
Result :
insert insert myTable values('1','data1','data-a','323');
insert insert myTable values('2','data2','data-b','324');
insert insert myTable values('3','data3','data-a','325');
insert insert myTable values('4','data4','data-b','326');
insert insert myTable values('5','data5','data-a','327');
insert insert myTable values('6','data6','data-b','328');
$ is a regex character to add data at the end of each line in file.
Thats it!! Our SQL Script is now ready!..
Note: Data may not be as simple as we have considered in our example. We may have Single Quotes (') in within itself, So in such cases, you need to first escape it by,
Find : '
Replace : ''
⚠️ Remember to move search mode in "Regular Expression" while using RegEx or else you may not get results.