Drop in an export from any app, even a PDF. Data Cruncher Pro removes duplicate rows, blank rows and stray spaces in seconds, shows you exactly what changed, and hands back a clean Excel, CSV, PDF, JSON or XML file, or one ready to import into QuickBooks. Even a 10-million-row export.
Windows & macOS · offline · up to 10 million rows · from $19 one-timeMost online cleaners make you upload the file. Data Cruncher Pro never sends it anywhere: it works with no internet connection at all.
Overlapping exports, re-imports and copy-paste create identical rows. Each one is kept once, and you can see every row that was removed.
Gaps from exports and copy-paste break filters, sorts and pivot tables. Empty rows are removed automatically.
“AWS ” and “AWS” don't match, so lookups fail silently. Leading and trailing spaces are trimmed from every text cell.
Excel can't open more than 1,048,576 rows. Data Cruncher Pro cleans files ten times that size, row by row, without filling your computer's memory.
Duplicates are found across the whole file, and you get one clean file back. An Excel export that big continues on a new sheet in the same workbook.
Drag in an .xlsx, .xls, .csv, PDF, JSON or XML file from your bank, your accounting or sales software, a CRM or any other app.
Compare the original and cleaned rows side by side, with every removed row and trimmed cell highlighted.
Save as Excel, CSV, a printable PDF, JSON or XML, or straight into QuickBooks Online or Desktop. Your original stays untouched.
No. Everything happens on your computer and the app doesn't need an internet connection. Nothing is uploaded, and there's no account. The only thing ever sent is your license key, when you activate it and about once a week to check it's still valid.
It reads .xlsx, .xls and .csv exports, text-based PDF statements, and JSON or XML data files, and saves clean copies as .xlsx, .csv, .pdf, .json or .xml, or as a QuickBooks Online upload (.csv) or Web Connect file (.qbo). CSV files can have up to 10 million rows; an Excel export that big carries on across extra sheets in the same workbook.
No. The original is never modified. You choose where the clean copy is saved.
By default, two rows count as duplicates when every cell matches after trimming spaces. You can also choose the columns that must match, such as Date and Amount, to catch a record imported twice with a different reference number. The first copy is kept, the before-and-after view shows which row each removed duplicate matched, and you can keep any that are genuine.
Yes. Save clean transactions as a QuickBooks Online bank upload (.csv) or a Web Connect file (.qbo) for QuickBooks Desktop or Online. You check which columns hold the date, description and amount, and see a preview before saving. It's included in both plans.
It's an estimate: 3 seconds per duplicate row, 1 second per blank row and 1 second per trimmed cell, roughly what each fix takes by hand.
Not yet. It reads PDFs that contain real text, like statements downloaded from online banking. A scan or photo of a page has no text to read, so download the statement as CSV, Excel or a regular PDF instead.
Yes, on Windows and macOS.