Guides
Guides to cleaner data and better tools
Specific how-to help for the spreadsheet that runs your business, whether or not you ever buy anything from us.
Clean up what you have
Clean a messy spreadsheet
A safe order of steps, the Excel formulas for each, and the mistakes that quietly damage data.Read the guideRemove duplicates in Excel
Highlight, count, then delete. Includes the cases where the built-in command misleads you.Read the guideMerge many Excel files
Combine a folder with Power Query, stack CSVs from the command line, and check the result.Read the guideOrganize scattered data
Map what you have, choose one source of truth for each subject, and keep it from scattering again.Read the guide
Move beyond the spreadsheet
Signs you’ve outgrown spreadsheets
Nine warning signs, cheap fixes to try first, and when the spreadsheet should simply stay.Read the guideTurn Excel into an app
Four routes, from a quick form to a custom build, and how to prepare the file for any of them.Read the guideGoogle Sheets to an app
AppSheet, Glide, Forms and Apps Script: what each does, and when the sheet itself becomes the limit.Read the guideExcel to a database
Split the sheet into tables, choose safe column types, import with real commands, and verify.Read the guide
Choose the right tool
Have a problem these guides don’t cover?
Tell us how your business runs and what keeps going wrong. We build new apps from scratch, and the first demo is free.
Get a free demo