Fix the spreadsheet problems you deal with every week
Each page below covers one common problem — PDF tables, text dates, subtotals, encodings — with a real before-and-after example. Or just drop your file here: the first one works without an account.
Drop files here
or browse your files
XLSX, XLS, CSV, TXT, PDF · up to 25 MB · 1 file without an account
Or try a sample:
- Convert a PDF table to ExcelTables from PDF reports and statements, joined across pages, with real numbers.
- Clean a messy CSV fileTitle rows, blank lines, spaces, text amounts and total rows — fixed and checked.
- Fix dates stored as textText dates in any format become real dates — US and UK order decided from the data.
- Fix numbers stored as textAmounts with $, £, €, commas, brackets or trailing minus become real numbers.
- Split one column into several columnsAddresses into street, city, state and ZIP; names and account paths split on request.
- Remove blank rows and subtotalsBlank lines, subtotals and totals out of the data — and used to check it.
- Merge multi-row headers into one rowTwo- and three-row headers become one row of clear column names.
- Clean a bank statement CSVBank exports with headers, local date formats and balances — typed and checked.
- Clean an accounting exportTrial balances, P&L and ledgers flattened, with account paths and checked totals.
- Extract invoice data to ExcelFields and line items from US, UK and EU invoices, with the arithmetic checked.
- Combine many PDFs into one tableA batch of PDFs into one table with a Source file column, grouped by layout.
- Fix CSV encoding problemsGarbled characters (�, é, —) fixed by detecting the real encoding.