A clearer working file

Spreadsheet cleanup

Need one CSV or single-table worksheet cleaned without losing track of the source? Choose the $49 USD simple cleanup or the $99 USD standard cleanup. Receive the preserved original, a cleaned copy, row-referenced changes, records held for review, and documented checks.

$49 USD
Simple spreadsheet cleanupUp to 20,000 data rows · 20 columns · 3 agreed rulesPreserved original, cleaned copy, row-referenced changes and exceptions, and a row-count check.One consolidated in-scope preference revision.Ask about the $49 USD simple cleanup
$99 USD
Standard spreadsheet cleanupUp to 50,000 data rows · 25 columns · 5 agreed rulesEverything in the simple package, plus before-and-after sums for up to three agreed numeric columns and a rule-by-rule validation report.Two consolidated in-scope preference revisions.Ask about the $99 USD standard cleanup

Both packages: one flat CSV file or one XLSX file with one worksheet and one header row, up to 12 MB. We confirm the scope and delivery date in writing after a free fit review.

Confirm the scope and price first · Approve the finished work before paying

At a glance

Useful when
A single-table spreadsheet has inconsistent entries or records that need checking before you can use it.
What you receive
The preserved original, cleaned copy, changes and questions linked to the original rows, and documented checks.
Choosing the right service
Choose cleanup to standardize one spreadsheet. If the file must fit an import template, see CRM import preparation or product catalog preparation.

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 cleanup

Standard 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

  1. Use the file description and, when useful, a redacted sample to confirm that the table, requested rules, and likely exceptions fit a package.
  2. Agree on the input file, included columns, rules, output structure, reviewer, completion checks, price, and delivery date in writing.
  3. Preserve the original; prepare the cleaned copy; record changes and exceptions by source row; and run the agreed row-count, numeric, and rule checks.
  4. 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

Help opening these files

Select the file link, then check the page that opens or your Downloads folder.

PDF: read it in your browser. DOCX: edit it in Word or a compatible document app. XLSX or CSV: open it in a spreadsheet app. TXT: open it as plain text. You can read the example on this page without downloading anything.

If a file does not open, tell us the file name and what happened. Do not send private data in your first message.

Have a task in mind?

Start with the result you need.

Tell us what you need
Need help using this site?

New here? You do not need to know the service name. Tell us what you have now and what a useful finished result would look like.

  1. Start a short inquiry. A few sentences are enough, and no account or files are needed.
  2. Compare services, package prices, and quote options, or see complete public-source examples before you ask.
  3. Already working with Cleargrain? Use Client Login for private requests, files, messages, and project review.

Still unsure? Describe the result you need, including technical detail if useful. Larger spreadsheets and custom work are welcome; we’ll review the task before agreeing on the work and price.

What do the file types and technical terms mean?
PDF
A document you can read in a browser or PDF reader.
XLSX
An Excel workbook. Open it in a spreadsheet app to inspect the full example.
DOCX
An editable Word document. Open it in Word or another compatible document app.
CSV
A plain spreadsheet file. Open it in a spreadsheet app to see rows and columns.
TXT
A plain-text checklist or template. Open it in a text editor or copy its text.
SOP (standard operating procedure)
A step-by-step guide for a recurring task.
CRM (customer relationship management)
A system used to organize customer or contact records.
Workflow
The steps that move a task from start to finish.
Flat file
One table of rows and columns, with one header row.
Exception list
Records that need a decision or more information, with references to the original rows.
Source-ready procedure
A procedure written from approved material you already have, rather than from a supplied walkthrough.
Preference revision
One collected round of requested adjustments within the agreed work. Correcting work that fails the written scope is separate.
White-label support
Work prepared for your agency to review and present in its own branding.

To download a file, select its download link. It may open in your browser or appear in Downloads. If the browser asks, choose where to save it. Downloading an example does not place an order.