Data and spreadsheets
Data, spreadsheets & business records
Clean, compare, match, validate, and prepare business records so the result is ready to use, review, import, or report on.
Cleanup & structure
- CSV and XLSX cleanup
- Repair broken headers and table structure
- Make column names, dates, currencies, statuses, and IDs consistent
- Review missing or invalid values
- Keep clean rows, problem rows, and rejected rows separate
Reconciliation, matching & duplicates
- Two-file and multi-file comparison
- Exact duplicate checks and probable duplicate matching
- When you provide confirmed examples, matching rules can be built from them
- Those rules are tested before automatic use; uncertain or conflicting matches stay separate for review
- Amount, status, and field mismatch detection
- Counts that account for every source row, plus mismatch reports
Spreadsheet formula checks, repair & reconstruction
- List and check formulas in a supplied XLSX workbook
- Check for links and formulas that depend on outside or changing sources
- Repair clear formula gaps and reconstruct missing or inconsistent formulas when the workbook clearly supports one formula
- Keep a cell-by-cell change log showing what changed and why
- If the intended business or accounting logic is unclear, it is flagged for clarification or left unchanged rather than guessed. Calculated results are not claimed as independently verified
Catalogs, databases & reports
- CRM, lead-list, product, SKU, inventory, and supplier-list cleanup
- Import-ready files with a clear guide to how columns map
- Queries and safe data moves for copied SQLite databases
- Move supplied data into an agreed structure
- Customer review and survey analysis
- Static HTML, Markdown, workbook, and operational reports