Convert TSV file to SQL file in a few clicks

by

Want to convert TSV file to SQL file?

Your TSV files are too large to use online convert services?

Need local native software for data security and data privacy?

Using DataFileConverter, a native GUI tool, you can convert TSV file to SQL file easily and fast, no need to program, just a few mouse clicks!

Support Windows, Linux, macOS.

Here’s how to.

Example

Example source TSV file

convert TSV file to SQL file - source TSV file

After converting, got SQL file

convert TSV file to SQL file - created sql file

Convert

Please download and install DataFileConverter, then run it.

Click “Start a New Convert” at task dialog.

convert TSV file to SQL file - task window

Select From “File” “TSV” To “File” “SQL”.

create SQL file by TSV file - select type

1. Open source TSV file.

transform TSV file to SQL file - open a TSV file

2. Config target SQL file.

generate SQL file by TSV file - config SQL file

3. Summary.

convert TSV file to SQL file - summary

4. Convert TSV to SQL.

convert TSV file to SQL file - convert file

After converting, you can view the output SQL file.

convert TSV file to SQL file - view SQL file

Save/load session

You can save/load session to run “TSV to SQL” conversion repeatly.

1.Save Session.

Click “Save Session” button, then enter a session file name.

TSV to SQL - save session

click “OK” button.

2.Load Session.

Click the “Open a Saved Session” in task window, select a session file.

TSV to SQL - load session

then show the wizard form, click a few “Next” to convert TSV to SQL.

TSV to SQL - start session

Run in command line

You can run “TSV to SQL” conversion in command line.

When you save session, you can click “Save & Make Batch File”.

TSV to SQL - save session

The “Save & Make Batch File” form shows.

TSV to SQL - create batch file

Click “OK” button, you’ll create a batch file, in Windows, like this:

C:
cd "C:\Users\pansh\AppData\Local\Programs\DataFileConverter"
DataFileConverter task="C:\Users\pansh\Documents\test.dfc" logfile="C:\Users\pansh\Documents\test.log"

You can run this batch file in command line.

Run as scheduled task

You can run “TSV to SQL” conversion automatically at specific time.

On Linux/macOS, you can use Crontab.

For macOS, How to Fix Cron Permission Issues in macOS.

On Windows, in “Save & Make Batch File” form, you can click “Create & Schedule Task” to set a scheduled task.

TSV to SQL - create batch file

And then, with scheduled task wizard, step by step.

TSV to SQL - scheduled task application

TSV to SQL - scheduled task name

TSV to SQL - scheduled task time

TSV to SQL - scheduled task user

TSV to SQL - scheduled task information

You’ll see created task listed in scheduled task list.

scheduled task list

Download

Here you can download DataFileConverter, and buy DataFileConverter.

Download DataFileConverter Download DataFileConverter