CSV and Excel problem guides
Each guide starts from what you see on screen, explains why it happens, and shows how to fix it by hand in Excel or Google Sheets. Where SpreadsheetFix can fix it for you, the guide says how, and what it won’t catch.
Bookkeeping and bank exports
Tools for bookkeeping and bank exportsRemove duplicate transactions from a bank CSV
Why bank CSV exports contain duplicate transactions, how to find them in Excel without deleting real repeat payments, and how to check the totals after.
How to stop Excel changing dates in a CSV, and fix swapped days and months
Why Excel reads 03/04/2024 as 4 March, not 3 April, when it opens a CSV, how to import it with the right date order, and how to fix every date at once.
Fix European number formats (1.234,56) in Excel and CSV imports
Why Excel can’t add 1.234,56 or 950,00 and leaves them as text, how to convert European number formats by hand, and how to fix a whole bank export.
Contact lists and CRM
Tools for contact lists and CRMCSV file cleanup
Tools for CSV file cleanupWhy your CSV shows é and ’ in Excel, and how to fix it
Why a CSV shows é, ’ or ü in Excel, how to import it with the right encoding by hand, and how to repair text that is already garbled.
VLOOKUP returns #N/A but the values match: fixing hidden spaces
Why VLOOKUP and XLOOKUP return #N/A on values that look identical, how to find trailing and non-breaking spaces in Excel, and how to clean a whole file.
CSV vs XLSX: which format to use for exports and imports
CSV is plain text that every system can read; XLSX keeps types, formulas and formatting. How to choose, and the problems each one causes.