Withdata DataFileConverter converts SQL dump / script files to Fixed-Width Text locally — single file, batch, or merge multiple SQL files into one Fixed-Width Text. 100% local, secure, and cross-platform.
SQL dump and script files contain INSERT statements.
SQL files are read and converted on your own computer. Nothing is uploaded to any cloud server.
Large SQL files are processed in streaming mode with low memory usage — millions of rows within a minute.
Batch convert many SQL files to Fixed-Width Text files, or merge multiple SQL files into one Fixed-Width Text.
Define the width of every column (N columns need N-1 widths). No delimiter and no quoting are needed.
Native builds for Windows, macOS and Linux, with a step-by-step GUI wizard and a command line interface.
Save a conversion session and run it automatically from Windows Task Scheduler or crontab.
| Feature | Supported details |
|---|---|
| Input source | Local SQL file, batch SQL files, selected tables in a dump |
| Output format | Fixed-width text with detected or custom column widths |
| Conversion mode | Single file · merge many SQL files into one Fixed-Width Text · batch (one to one) |
| Running mode | GUI wizard · command line · scheduled tasks |
| Source options | Table selection, statement parsing |
| Output options | Column mapping, encoding, date format, empty value handling |
| Platform | Windows, macOS, Linux (native, 64-bit) |
INSERT statements in SQL dumps and scripts are parsed into rows.INSERT or UPDATE/UPSERT using a multi-column key can be generated.In GUI mode the conversion is a step-by-step wizard: choose the SQL source, choose the Fixed-Width Text destination, check the preview, and click Convert. See Withdata DataFileConverter.
After converting SQL to Fixed-Width Text in GUI, and saving the "SQL to Fixed-Width Text" session, you can run it from the command line:
Download Withdata DataFileConverter for a free trial. Runs on Windows, macOS and Linux.