I will clean selected CSV fields and flag duplicates with an audit report
About this Gig
I will clean agreed fields in your UTF-8 CSV and return a cleaned copy with a JSON audit. Typical work includes trimming spaces, standardizing selected text fields, preserving ID strings and leading zeros, and flagging duplicates or invalid dates, email formats and quantities.
You choose the rules. Ambiguous duplicates stay for review. I flag uncertain facts instead of inventing corrections. Formula-like cells receive documented protection; import ID columns as text to preserve leading zeros in spreadsheet apps.
Send column names, a redacted sample and your expected result if the format or rules are uncertain. Every package delivers within one day after complete requirements; simple work can ship within hours.
Delivery includes the cleaned CSV, audit and notes on unresolved flags. Premium also includes a reusable Python script with run instructions. No scraping, missing-fact recovery, database writes or macro execution.
Have a different budget or file volume? Send your task and budget for a custom quote, including smaller jobs. The cover is a service illustration, not client data.
FAQ
Can you work with a different budget or file volume?
Yes. Send your budget, row/file counts, size, rules and desired result. I can propose a useful custom scope below or beyond the listed packages where deliverable. Each package’s row limit is the total across its included files.
Will you delete duplicates or recover missing facts?
I flag exact matches and key collisions and retain ambiguous records. Removing records needs a separate explicit rule. I can flag missing or invalid facts; recovering them from other sources is outside these packages.
Will IDs and leading zeros survive?
The CSV preserves ID strings. Import ID columns as text in spreadsheet apps. Formula-like values, including IDs, receive a documented protective apostrophe; original values remain in the audit.
Which file formats and checks are included?
These packages cover UTF-8 CSV. Email checks validate format, not deliverability. Excel workbooks and other encodings need separate review; macros, formula execution, scraping and database access are excluded.
What counts as a rule or a revision?
One rule is one operation or check on one column. Basic uses one duplicate key; Standard can use a composite key. Revisions refine the approved schema and rules: 1 for Basic, 2 for Standard/Premium. New schemas or more volume need scope review.
What is included in Premium?
Up to 3 matching-schema CSVs, 10,000 total rows and 10 MB total, with 12 shared rules. You receive cleaned outputs, audit, review notes and a tailored standard-library Python script with run instructions.
How quickly can you deliver?
All listed packages deliver within one day after complete requirements. Straightforward work can ship within hours. Send a redacted sample and clear rules so I can confirm scope before an uncertain order.
How is confidential data handled?
Use a redacted initial sample. We will agree how confidential data is handled before processing. Tell me any tool or data-handling restrictions before ordering. I review and test the finished work.
