LedgerDock
Standalone Desktop App
LedgerDock reads your CSV or Excel file, helps you clean up the table structure, checks the whole thing against your real database before anything is written, then exports SQL scripts or imports directly.
See It In Action
The preflight check reads your actual destination table and reports what would break — values that won’t convert, blanks in required columns, duplicate keys, text too long for its column. Errors stop the import until you say otherwise.
Column types, sizes, and nullability are suggested automatically so you can move quickly, then adjust anything you want.
Imports report progress row by row and cancel cleanly. Whatever was already written stays written, and LedgerDock tells you exactly where it stopped.
Append, skip duplicates, upsert, truncate and reload, or replace the table outright — each one implemented properly for SQL Server, PostgreSQL, MySQL, and SQLite.
Save an import as a recipe — destination, schema, mapping, and clean-up rules together — then apply it to next month’s workbook. Recipes follow headers as they drift, so “Invoice No” becoming “Invoice #” doesn’t break anything. Your session is waiting where you left it, too.
Once a recipe works, hand it to a scheduler: ledgerdock --file … --recipe … runs the same import with no window and no clicking, and refuses rather than guessing when a column is missing or preflight objects.
LedgerDock streams rather than loading everything into memory. A 368 MB file with 36 million cells opens in under two seconds, on an ordinary laptop.
Downloads
Links are read from version.json so the page always points at the current release.
Windows may show a “Windows protected your PC” screen. LedgerDock is code-signed, but Windows SmartScreen still cautions about newer apps from independent publishers until they’ve built up enough downloads to earn reputation — it doesn’t mean anything is wrong, and it stops appearing as more people install the app. Click More info to see our verified publisher name, then Run anyway to continue. The app runs entirely on your computer — nothing is uploaded.
Simple Plans
$0
Great for testing and script-only workflows.
$29 one-time
For consultants, owners, and anyone who wants direct import.
One-time payment — never billed again, nothing to renew. The Pro features above do not expire. After 12 months you simply stop receiving new releases; the version you have keeps working. Details.
Buy ProFree stays free — loading files, fixing up the schema, saving recipes, and generating SQL scripts are all yours at no cost. Pro is one-time and includes a year of updates. Keep using your licensed version forever, even if you don't renew. Paid licenses unlock the destination step: direct import, preflight validation, progress and cancel, duplicate handling, and saved connection profiles.
The command line is licensed the same way, because it is the same import: your Pro license covers scheduled runs on the machine it is activated on. Checking a recipe against a file with --dry-run writes nothing, so it needs no license at all.
Beta licenses are the one exception, and the difference matters: a beta key grants the Pro features for six months and then reverts to Free. It is a loan, not a purchase, so it leaves no permanent entitlement behind. The end date is signed into the key and enforced on your machine — nothing phones home to check. See the beta terms.
Yes. Free supports full file review and SQL script generation. It is ideal for manual script-based workflows.
No. Paid plans unlock workflow features, not row or column caps.
Yes. Pro is one-time. You keep your licensed version permanently.
It reverts to Free. A beta license grants every Pro feature for six months from issue, and the end date is written into the key itself — there is no account or check-in involved. LedgerDock warns you in-app a month ahead, keeps working for a 14-day grace period past the end date, and then locks direct import and saved connection profiles. Loading files, schema review, rules, recipes, and SQL script generation keep working, and nothing you already generated or imported is touched. Buying Pro at any point replaces the beta license. Full terms.
CSV files are read as a stream, so there is no practical size limit — a 368 MB file with 36 million cells opens in under two seconds. Excel workbooks are different: the format has to be loaded whole, so LedgerDock checks the size first and tells you if a workbook is too large rather than running out of memory partway through. Saving that file as CSV clears the limit.
Now recruiting beta testers
LedgerDock is stable and pre-launch. Run it against your own files and your own database, and tell me what breaks.