Who this is for
A finance administrator, operations lead or small-business owner who must consolidate several inherited workbooks before a move to new software, a database or a proper pivot analysis.
A migration or a reporting project is waiting on spreadsheets that nobody dares touch, and earlier import attempts failed on the first bad row.
The result
You buy the finished set, not the individual repairs. Each workbook in the agreed list becomes a flat, consistent table with one header row, real dates and numbers and no formula errors, backed by a readiness sheet that reports, column by column, what the data now holds.
What is included
- An agreed list of up to eight workbooks, with a fixed inventory settled after we have read it
- Repairs and clean-up in one fixed order: formulas first where they return errors, then layout, then dates and numbers, then duplicates for product, parts, asset or company lists that hold no personal data. Each workbook gets only the steps it needs
- A readiness sheet per table: each column's type, blank count, distinct count and whether the agreed key is unique
- Checks against the target's published import template or column list if you supply one, run on copies only
You receive
- A cleaned copy of each workbook in the agreed list, with the originals untouched
- A readiness sheet for each table, and a combined summary
- The change logs, reconciliations and ambiguity lists from each step
- A short note of the rules applied
What is not included
- Loading the data into any live system, database or accounting package; that is yours to do
- Deciding which figures are correct, or any tax, accounting or financial advice
- Macros, add-ins or live data connections
- Workbooks that hold personal data about individuals, such as lists of people with names, email addresses or phone numbers: this project does not take them
- Workbooks added after the price is agreed, unless you add them in writing
What we need from you first
- A list of the workbooks: what each is for, the number of sheets and rows, and the problems you can see
- What the tables will feed, such as a named import or a pivot analysis
- No workbooks in the first enquiry
Never send passwords, keys, customer records or confidential code in the first enquiry. Secure handover is agreed after scoping.
How we check it is done
- For every workbook in the agreed list, the cleaned table has one header row, no merged cells, and every date and number column holds real values or its rows are on a listed exception.
- For each step on each workbook, the reconciliation shows record counts and numeric column totals equal to the original under the agreed rules, with every difference listed.
- Where you supplied a target column list, each table has exactly those columns in that order, and the agreed key is unique or its duplicates are listed.
- Your named person accepts each cleaned table or removes the workbook from the list in writing.
You open each cleaned table beside its original, read the readiness sheet and the logs and accept each table or send it back with comments, then accept the finished set.
When we would stop or decline
- The results depend on macros or live connections that we cannot see
- Nobody can say what a column or a key means, and the choices would be guesses
- The set is really a large system migration, so we propose a different scope
- A workbook holds personal data about individuals
- No secure way to hand the workbooks over can be agreed in writing; nothing starts and nothing is charged
Questions
Do you load the data into our system?
No. You receive clean tables and a readiness sheet. Loading is yours to do, under your own checks, on a copy first.
What if only some workbooks need all of the steps?
That is normal. Each workbook gets the steps it needs, and the proposal prices each workbook separately before you agree. A workbook that needs only one step costs less than one that needs several.
How is this different from buying the single jobs?
Each single job fixes one kind of damage in one file. The project runs them in a safe order on a whole set, and ends with a readiness sheet for every table.
Can you clean a workbook that lists customers, members or staff with their names and emails?
Not under this project. Workbooks of people's details are not covered, and no secure upload route exists yet. Please do not send one.
Price and terms
From £1,500 · untested offer price. The payment schedule is set in the written proposal. Nothing is charged until you have agreed it.
This is a new service with no published client results. The price is a starting point we have not yet tested with buyers. Nothing is ordered or charged by the enquiry. The full specification is on the Synthetic Industry catalogue.