Project Overview:
We are seeking a detail-oriented data-entry freelancer to assist with digitizing and organizing citizen service request records into a structured spreadsheet. This data will support internal tracking, reporting, and interdepartmental coordination.
Objective:
Create a clean and well-formatted spreadsheet using data from citizen service request forms (provided in PDF or scanned format). This spreadsheet will help streamline how service issues are tracked and addressed across departments.
Spreadsheet Requirements:
The spreadsheet should include the following columns:
Request ID (assigned reference number)
Resident Name
Service Type (waste pickup, street repair, utility complaint)
Submission Date
Assigned Department
Resolution Status (Pending, In Progress, Completed)
Please organize the records by submission date, with filters enabled for sorting and searching by service type or department.
Data Entry Instructions:
Input all data accurately as shown in the source forms
Standardize formats (e.g., date formats, department names)
Double-check for typos and missing fields
Flag any unclear or illegible entries for review
Use consistent capitalization and alignment throughout
File Format:
Final deliverable should be in Excel (.xlsx) or Google Sheets format
Spreadsheet should be ready for future updates or reports
Deliverables:
One completed spreadsheet with all citizen request data from the provided files
Clearly labeled and structured for usability
Optional: a brief summary listing any records that were incomplete or needed clarification
Timeline:
Please complete the project within 24 hours after receiving the documents.
Confidentiality:
All information shared is for internal use only. Please handle all data securely and professionally.