Withdata FileToDB, Import data from Fixed-Width Text files to databases
Withdata FileToMongo, Import data from Fixed-Width Text files to MongoDB
What you can do with the Fixed-Width Text Import 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.
- Import a file into a database table, creating the table if it does not exist.
- Choose the load mode: Append, Replace, Update, Upsert, Insert Ignore or Delete.
- Import several files into one table, or a whole folder into many tables.
- 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 FileToDB and try it free. It runs on Windows, macOS and Linux.
See Withdata FileToDB