Excel To SQL

1. Copy from Excel, pasted into text editor
2. Escape single quotes:
   • Find: '
   • Replace: \\'
3. Replace tab-delimited with SQL VALUES formatted lines:
   • Find: ([^\t\r]*)\t([^\t\r]*)\t([^\t\r]*)\t([^\t\r]*)\t?([^\t\r]*)?\t?([^\t\r]*)?\t?([^\t\r]*)?
   • Replace: ('masters', '\1', '\2', '\3', '\4', '\5', '\6', '\7'),
4. Remove the last comma from the end of the file.
5. Add INSERT statement to top of file:

INSERT INTO theses
( `group` , `department` , `last_name` , `first_name` , `title` , `year` , `notes` , `alternate_formats`) 
VALUES