I will clean validate and document your excel CSV or json data
Public Data Automation and API Specialist
About this Gig
Messy Excel, CSV, JSON, or API data can break analysis, imports, and automations. I will clean one bounded, buyer-authorized dataset and return documented output you can audit.
Depending on the package, delivery can include type normalization, duplicate handling, a missing-value summary, up to five deterministic validation rules, a field dictionary, cleaned Excel/CSV/JSON output, and a separate reason-coded exceptions sheet. Records are never silently discarded.
My reproducible proof workbook shows the full process on synthetic data: 12 raw rows, 6 accepted rows, 6 traceable exceptions, a data dictionary, and formula-driven QA checks. It is lab work - not a client claim.
This Gig does not scrape restricted sources, bypass access controls, process regulated sensitive data, or guarantee business outcomes. Do not send passwords, API keys, payment data, health data, identity documents, or unrestricted production credentials. Prefer a sanitized export, test endpoint, or revocable least-privilege access.
Before ordering, confirm file type, record and field counts, known problems, duplicate policy, desired output, and authorization to share the data.
Technology:
Excel
•
Google Sheets
•
Python
•
Zapier
My Portfolio
FAQ
What counts as one dataset?
One API response family, CSV, or JSON export sharing one approved schema. Unrelated tables, endpoints, or data models require separate scope.
Will you delete bad rows?
Not silently. Rejected or unresolved records go to a separate exceptions file with a reason.
Can you use production credentials?
No unrestricted credentials. Prefer a sanitized export, test endpoint, or revocable least-privilege access with a strict data boundary.
Do you guarantee business outcomes?
No. Delivery covers only the selected cleanup, validation, documentation, and delivery scope—not revenue, compliance, model accuracy, or downstream decisions.
