Click any tag below to further narrow down your results
Links
This is a free web tool that converts bank statement PDFs and images into Excel, CSV, or JSON formats for analysis or accounting software imports. It processes up to 100 files at once, checks running-balance arithmetic for errors, and doesn't store your files.
- Handles multiple formats (PDF, JPG, PNG, WebP, TIFF) and can batch-process up to 100 statements at 50 MB each
- Verifies running-balance arithmetic and flags mismatches within two cents; lets you review extracted data before downloading
- Doesn't store statements or results — files go directly to OpenRouter for processing and are deleted after extraction
The author shares their shift from using Excel and Google Sheets to DuckDB and SQL for handling CSV files, highlighting the efficiency of querying data directly. They discuss the benefits of using SQL for data manipulation and invite readers to share their own CSV handling tips.
- DuckDB lets you run SQL directly on CSV files (joins, window functions, dedup queries) without importing them into Excel/Sheets first
- You can query CSVs from URLs or cloud storage like S3 directly, and export results straight back to CSV
- Several users find SQL queries more intuitive than replicating the same logic with spreadsheet formulas or pivot tables
- Some commenters mix in Parquet files and other extensions alongside DuckDB to further speed up ad-hoc analysis