Here are some fixedwidth export tools, to export data from databases to Fixed-Width Text, or export data from MongoDB to Fixed-Width Text.
Withdata DBToFile, Export databases data to Fixed-Width Text files
Withdata MongoToFile, Export data from MongoDB to Fixed-Width Text files
What you can do with the Fixed-Width Text Export tools
Fixed-width text is a plain text format in which every column has a fixed character width and no delimiter is used. For N columns you define N-1 widths, for example 10,25,8, and the last column simply takes the rest of the line.
- Export a database table, a view or a SQL query result to a file.
- Batch export many tables to separate files, or several similar tables into one file.
- Run the export from the command line and schedule it.
- Column widths can be detected from the data (measured width plus 15% slack), or set by hand.
Frequently asked questions
No. All the tools on this site run on your own computer, so your files never leave your machine.
Yes. The desktop tools have native builds for Windows, macOS and Linux, with both a GUI wizard and a command line.
Specify the width of each column. For N columns you enter N-1 widths, for example 10,25,8 — no delimiter is used.
Yes. When writing fixed-width output the widths are measured from the data (plus 15% slack), and they can be edited before the job runs.
A header row is optional and leading rows can be skipped.
Yes. Every Withdata desktop app can be downloaded and tried for free before you buy it.
Get started
Download Withdata DBToFile and try it free. It runs on Windows, macOS and Linux.
See Withdata DBToFile