SheetPrep
Cleans and prepares spreadsheet data for import into accounting software.
Strips macros, embedded objects and VBA code, normalises dates and amounts, and exports a clean file ready to import into your accounting software. Everything runs in your browser — no data is uploaded anywhere.
Drop your spreadsheet here
.xlsx · .xls · .csv accepted
Keep formulas
Formulas will be preserved in the output file
On
Convert negative amounts to positive
Some accounting software (e.g. VT Transaction) requires amounts to be entered as positive values
Off
⚠ This file is over 5 MB — processing may be slow or cause your browser to struggle. You can still proceed.
✓ File cleaned and ready to download
Download Clean File⚠ Always open and check the downloaded file before using it. Verify that all data — especially dates, amounts, and account names — has been preserved correctly. This tool processes files automatically and cannot guarantee accuracy in every case. You remain responsible for the integrity of your financial data.
What this tool does
- Preserves formulas (or replaces with values — your choice)
- Removes embedded objects & ActiveX controls
- Strips macros and VBA code
- Normalises dates to DD/MM/YYYY on CSV export
- Optionally converts negative amounts to positive (required by some accounting software)
- Exports each sheet as a separate CSV when multiple sheets are present
- Outputs XLS / XLSX / CSV or a VT Transaction-formatted CSV
- 100% local — your file never leaves your browser
Note — if your accounting software won't install or load with Excel: SheetPrep prepares your data for import, but it cannot fix an add-in that refuses to load. Many accounting applications — including VT Transaction, Sage 50 Payroll, and others — are built as 32-bit Excel add-ins. These cannot run inside 64-bit Excel, and no file conversion can change this. The only fix is to reinstall Microsoft Office as the 32-bit version. Your Microsoft 365 licence covers both versions at no extra cost. If you use VT Transaction, see their step-by-step reinstall guide →