Data Entry 400 Records from PDF + Cleaning + Excel Analysis Report

via Freelancer ·

Budget / Salary$10–11
TypeFreelance project
LocationRemote
Posted1 hour ago
Data Specialist Needed: Enter 400 Records from PDF + Clean + Analyze & Report (Excel)

I have a customer list for an electronics store (400 records in a PDF). I need an accurate person to transfer it into Excel, clean it, then analyze it and deliver a report with recommendations. The work has 3 sequential milestones; each milestone is delivered and reviewed by me before the next one starts.

Payment: $10 total, split into 3 milestones ($3 + $3 + $4).

MILESTONE 1 - Data Entry ($3)
- Transfer all 400 records from the PDF into the attached Excel template exactly as written (no corrections or edits).
- If a value is unreadable, write a note in the last column "ملاحظات المُدخِل" (Data Entry Notes). Do not guess.
- Deliverable: Excel file in the template + list of any unreadable records.

MILESTONE 2 - Data Cleaning ($3)
- Standardize date formats (yyyy-mm-dd), mobile numbers (11 digits, English numerals) and prices.
- Odd or missing values must be left as they are and flagged for review. No guessing.
- Deliverable: clean file + change log + list of rows needing review with the reason for each.

MILESTONE 3 - Analysis ($4)
- Summary (total revenue, average order value) and breakdown by product, city, month and payment method.
- At least 2 charts and 5 recommendations based on the numbers.
- Use Excel formulas (not hard-coded numbers) so I can audit the calculations.
- Deliverable: one Excel file containing all of the above.

Note: the template headers are in Arabic. The data PDF will be shared with the awarded freelancer.

Tools: Excel. Experience with Power Query or Python is preferred.
data processing data entry excel pdf excel vba excel macros data visualization data analysis data management data annotation
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.