Convert SQL file to Excel file in a few clicks

by

Want to convert SQL file to Excel file?

Your SQL 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 SQL file to Excel file easily and fast, no need to program, just a few mouse clicks!

Support Windows, Linux, macOS.

Here’s how to.

Example

Example source SQL file

convert SQL file to Excel file - source SQL file

After converting, got Excel file

convert SQL file to Excel file - created excel file

Convert

Please download and install DataFileConverter, then run it.

Click “Start a New Convert” at task dialog.

convert SQL file to Excel file - task window

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

create Excel file by SQL file - select type

1. Open source SQL file.

transform SQL file to Excel file - open a SQL file

2. Config target Excel file.

generate Excel file by SQL file - config Excel file

3. Summary.

convert SQL file to Excel file - summary

4. Convert SQL to Excel.

convert SQL file to Excel file - convert file

After converting, you can view the output Excel file.

convert SQL file to Excel file - view Excel file

Save/load session

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

1.Save Session.

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

SQL to Excel - save session

click “OK” button.

2.Load Session.

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

SQL to Excel - load session

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

SQL to Excel - start session

Run in command line

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

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

SQL to Excel - save session

The “Save & Make Batch File” form shows.

SQL to Excel - 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 “SQL to Excel” 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.

SQL to Excel - create batch file

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

SQL to Excel - scheduled task application

SQL to Excel - scheduled task name

SQL to Excel - scheduled task time

SQL to Excel - scheduled task user

SQL to Excel - 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