Spreadsheet Entry & SQL Cleanup
Budget: ₹750 – ₹1,250 INR
I have two parallel data-oriented tasks that need to move quickly and accurately. First, raw information arrives daily in mixed formats; your job is to place it into a structured spreadsheet, respecting the column order I provide and double-checking for typos or missing fields before you hit save.
Once the spreadsheet portion is solid, the same data feeds into an existing SQL database. I need you to connect (MySQL/PostgreSQL—whichever you prefer), run targeted cleansing queries, and eliminate duplicates, malformed dates, stray white-space, and other common inconsistencies. No schema changes are required—just clean, validate, and report back.
Deliverables
• Completed spreadsheet, fully validated
• SQL scripts (or a log of statements) used for the cleaning pass
• Brief summary of issues found and fixed
If you already have a dependable workflow for spreadsheet input and can demonstrate past SQL data-cleaning success, this will be a straightforward assignment. Let me know your typical turnaround time and any clarifying questions so we can get started.
Once the spreadsheet portion is solid, the same data feeds into an existing SQL database. I need you to connect (MySQL/PostgreSQL—whichever you prefer), run targeted cleansing queries, and eliminate duplicates, malformed dates, stray white-space, and other common inconsistencies. No schema changes are required—just clean, validate, and report back.
Deliverables
• Completed spreadsheet, fully validated
• SQL scripts (or a log of statements) used for the cleaning pass
• Brief summary of issues found and fixed
If you already have a dependable workflow for spreadsheet input and can demonstrate past SQL data-cleaning success, this will be a straightforward assignment. Let me know your typical turnaround time and any clarifying questions so we can get started.
Related categories:
Data Entry
SQL
Microsoft Access
MySQL
PostgreSQL
Database Programming
Data Cleansing
Database Management