Simple spreadsheet cleanup · $49 USD
One CSV file or one XLSX file with one worksheet, containing one rectangular table with one header row. This single-table layout is what we mean by a flat file. The input file can be up to 12 MB. Up to 20,000 data rows, 20 columns, and 3 agreed repeatable cleanup rules.
What counts as a cleanup rule?
One rule is one agreed operation applied consistently to specified columns—for example, trimming extra spaces, converting unambiguous dates to one agreed format, or applying an agreed category map.
What you receive
You receive the preserved original, a separate cleaned copy, a row-referenced change log and exception list, and a before-and-after row-count check. The logs identify the original row for each change or question; an exception is a record that needs your decision. The cleaned table stays whole; cleaned data and logs may be supplied as separate files, and large change or exception logs may be supplied as numbered files with the same source-row references.
Every source data row remains accounted for. Existing identifiers and leading-zero text values are preserved, and missing values are not invented. Possible duplicates and uncertain records are flagged for your decision, not silently deleted or merged.
What is outside this package?
Formulas or macros, merged or multi-table layouts, multiple worksheets, merging files, manual research or adding missing information, fuzzy-match decisions (judging whether similar-looking records represent the same thing), dashboards or other custom reports, and changes to live systems are not included. If the task does not fit, we discuss the standard cleanup or a separate quote before you commit.
Fit, revisions, and payment
The free fit review uses your file description and, when useful, a redacted sample to check the table structure, requested rules, and how many records may need your decision. We confirm the accepted scope and delivery date in writing before work starts.
One consolidated in-scope preference revision is included. A consolidated in-scope preference revision is one collected request to adjust the delivered work within the accepted input file, columns, output structure, and agreed rules. New files, added rules, expanded or different column sets, and a different output design are new scope. Covered corrections under the 30-day corrections guarantee are separate and do not use the included preference revisions.
You review and approve the finished work before paying. Final editable files follow confirmed payment.
No account, file upload, or payment is needed to inquire. Describe the file type, approximate row and column counts, and the changes you need. Share files only after we agree how to proceed.
Ask about the $49 USD simple cleanupStandard cleanup: what you receive
- The preserved original and a separate cleaned copy.
- A row-referenced change log and exception list showing what changed, which rule applied, and what still needs your decision.
- A before-and-after row-count check accounting for every source data row.
- For the standard cleanup, before-and-after sums for up to three agreed numeric columns, with differences caused by approved conversions or flagged exceptions explained.
- For the standard cleanup, a rule-by-rule validation report stating how many rows were checked, changed, and flagged under each rule and whether the corresponding rule check passed.
The cleaned table is not divided into partial tables. The cleaned data, change log, and exception list are separate deliverables; large logs may be supplied as numbered files that keep the same source-row references.
The validation report documents the checks for each agreed rule; it does not certify that every source value is true or accurate. Dashboards, recurring reports, and other custom reports are quoted separately.
Standard cleanup: scope and limits
The $99 USD standard cleanup covers one flat CSV file or one XLSX file with one worksheet, containing one rectangular table with one header row: an input file up to 12 MB, 50,000 data rows, 25 columns, and five agreed repeatable cleanup rules. It includes two consolidated in-scope preference revisions, before-and-after sums for up to three agreed numeric columns, and the rule-by-rule validation report described above.
The $49 USD simple cleanup has the same flat-file and 12 MB input requirements and covers up to 20,000 data rows, 20 columns, and three agreed repeatable cleanup rules, with one consolidated in-scope preference revision. A consolidated revision is one collected request to adjust the delivered work within the accepted input file, columns, output structure, and agreed rules. New files, added rules, expanded or different column sets, and a different output design are new scope. Covered corrections under the 30-day corrections guarantee are separate and do not use the included preference revisions.
Formulas or macros, merged or multi-table layouts, multiple worksheets, merging files, manual research or adding missing information, fuzzy-match decisions, dashboards or other custom reports, and changes to live systems are outside these packages. Larger or more complex work is quoted separately after review. Your team approves unresolved records and any operational use.
We confirm the accepted scope and delivery date in writing before work starts. You review and approve the finished work before paying. Final editable files follow confirmed payment. Payment takes place on a hosted Stripe invoice after approval; this website does not collect card details.
When this work is useful
You have inconsistent names or formatting, possible duplicates, or a flat file that takes repeated manual sorting and checking. We first separate repeatable cleanup rules from decisions that need your knowledge of the business.
- Make purchasing fields consistent and list the records that need attention.
- Make names consistent and flag possible repeated records before anyone decides whether to combine vendor or item lists.
- Show which records were changed, left unchanged, or held for review.
You’ll need to identify the source, explain how you plan to use the file, and name someone who can answer business questions. If the right source or matching rule is unclear, we record that question before making changes.
For contact records or a confirmed destination template, see CRM cleanup and import preparation. Operational work can include order, vendor, inventory, or reporting exports; each source and output is agreed before work begins.
What to bring
- A description of one flat file: one CSV file, or one worksheet in one XLSX file, containing one rectangular table with one header row.
- The input-file size, number of data rows and columns, and up to five repeatable cleanup rules you want considered.
- Field definitions, approved category maps, the agreed format for unambiguous dates, and any numeric columns you want checked.
- Known problems, a normal row, representative problem rows, and the person who can decide ambiguous cases.
The free fit review uses your description and, when useful, a redacted sample to check the table structure, requested rules, and likely number of records that cannot be changed safely without your decision. Leave out passwords, full payment details, and unnecessary personal records. We confirm the accepted scope, permitted transfer method, and delivery date in writing before work starts.
From source file to reviewed handover
- Use the file description and, when useful, a redacted sample to confirm that the table, requested rules, and likely exceptions fit a package.
- Agree on the input file, included columns, rules, output structure, reviewer, completion checks, price, and delivery date in writing.
- Preserve the original; prepare the cleaned copy; record changes and exceptions by source row; and run the agreed row-count, numeric, and rule checks.
- Review the cleaned output, validation results, and open decisions with you, then provide final editable files after approval and confirmed payment.
Preparation does not authorize a live import, merge, deletion, or change to your operational systems.
Standard cleanup: how the work is checked
- Account for every source data row and give the cleaned copy a source-row reference when the file has no stable identifier.
- Preserve existing identifiers and leading-zero text values; do not invent missing values.
- Flag possible duplicates and uncertain records for your decision rather than silently deleting or merging them.
- Validate each agreed rule against its specified columns and convert dates only when they are unambiguous and the output format is agreed.
One rule is one agreed operation applied consistently to specified columns—for example, trimming extra spaces, converting unambiguous dates to one agreed format, or applying an agreed category map.
See the files and the finished work
The real retail cleanup includes 2,000 original and prepared records, a full Excel download, and explanations of actual edits and questions left for the owner.
The UK procurement-spending project brings three published source files into one checked workbook. It preserves every selected record, reconciles the totals, and keeps possible duplicates available for review.
Read the reconciliation guide or prepare your cleanup brief.
Start a standard cleanup inquiry
Send the file type, input-file size, approximate data-row and column counts, requested cleanup rules, and the result you need. Include any delivery date to consider. We’ll confirm whether the simple cleanup, standard cleanup, or a custom quote fits.
Ask about the $99 USD standard cleanup · Download the editable project brief
Clear scope. Careful checks.