Skip to content

Free spreadsheet tools

Most spreadsheet chores aren't hard, just slow: copying rows between files, hunting for the customer who appears twice, working out what changed since last month's version.

These tools read Excel and CSV files on your own computer and hand back a file you can open in Excel or Google Sheets.

Use them one at a time or chain them: convert a bank statement to Excel, merge it with the rest of the year, remove the duplicates, then compare the result with another copy. Contacts move both ways too: from a phone's .vcf file to a spreadsheet, and from a spreadsheet back to a .vcf.

  1. Turn a PDF bank or card statement into rows you can sort, filter and reconcile, checked against its balances.

    You bring: PDF statement. You get: Excel or CSV

  2. Turn a contacts file from iPhone, Android or Google into an Excel or CSV list, one column per phone and email.

    You bring: Contacts file (.vcf). You get: Excel or CSV

  3. Turn a contact list in Excel or CSV into a .vcf file to import on iPhone, Android or Google Contacts.

    You bring: Contact list. You get: .vcf contacts file

  4. Stack several files into one sheet, even when their columns are in a different order.

    You bring: Two or more files. You get: One combined file

  5. Find repeated rows by the columns you choose and keep one of each.

    You bring: A list in Excel or CSV. You get: The list, deduplicated

  6. See which rows were added, removed or changed between two versions of a sheet.

    You bring: Old and new version. You get: Differences, highlighted

  7. Break one sheet into separate files by a column such as State or Sales rep, or by row count.

    You bring: One Excel or CSV file. You get: One file per group

From a PDF statement to a clean report

Each tool works on its own, and each one hands its file straight to the next.

  1. The month's statement arrives as a PDF. Turn it into rows.

    Bank statement converter

  2. Add those rows to the sheet that holds the rest of the year.

    Merge Excel and CSV files

  3. Drop the transactions that were already in both files.

    Remove duplicates

  4. Check the result against your bookkeeper's copy to see what doesn't match.

    Compare two Excel files

  5. Send each account owner a file with only their rows.

    Split a spreadsheet