Database to Excel Data Entry
Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted1 hour ago
I have a live database that holds mixed data—text fields blended with numeric values—and I need every record copied accurately into an Excel spreadsheet. I will share a clean template that already includes the proper column headers and basic data-validation rules; your job is to populate it row by row, preserving the original field order and data types.
The source tables can be exported in whatever format you prefer (SQL dump, CSV extract, or direct read-only connection). Feel free to use Access, Power Query, VBA, or any other productivity tools that speed up the transfer, as long as the final deliverable remains a single Excel workbook.
Deliverables
• Fully populated Excel file that mirrors all records from the database
• Basic spot-check report (any anomalies, empty fields, or datatype mismatches you run into)
Acceptance criteria
• 100 % of records transferred; random 5 % cross-check shows zero discrepancies
• No formula errors or broken validations in the final sheet
• Completion within the agreed timeframe and with clear documentation of the import process
If any field mapping appears ambiguous, flag it before proceeding so we can clarify on the spot. Looking forward to a smooth hand-off.
The source tables can be exported in whatever format you prefer (SQL dump, CSV extract, or direct read-only connection). Feel free to use Access, Power Query, VBA, or any other productivity tools that speed up the transfer, as long as the final deliverable remains a single Excel workbook.
Deliverables
• Fully populated Excel file that mirrors all records from the database
• Basic spot-check report (any anomalies, empty fields, or datatype mismatches you run into)
Acceptance criteria
• 100 % of records transferred; random 5 % cross-check shows zero discrepancies
• No formula errors or broken validations in the final sheet
• Completion within the agreed timeframe and with clear documentation of the import process
If any field mapping appears ambiguous, flag it before proceeding so we can clarify on the spot. Looking forward to a smooth hand-off.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.