Data Processing Expert - Merge & Clean Multiple Excel Files into Structured Dataset

Job ID: 40140690

Budget: ₹12,500 – ₹37,500 INR

We have a large set of Excel files extracted from a third-party source. These files currently have no headers and inconsistent formatting. We require an experienced data professional to:

Scope of Work:

Analyze all Excel files and identify the correct column structure.
Add appropriate headers based on data patterns.
Merge all files into a single structured dataset.

Perform data cleaning and normalization:

Remove duplicates.
Standardize formats (emails, phone numbers, URLs, etc.).
Deliver the final dataset in a usable format (Excel, CSV, or database).
Provide scripts or documented steps for future processing.

Deliverables:

Cleaned and consolidated dataset.
Automation script or documented process.
Summary report of actions taken.

Skills Required:

Expertise in Excel/CSV handling and data cleaning.
Familiarity with database loading (MySQL/PostgreSQL) is a plus.

Additional Information:
NDA required.

Please include in your proposal:

Your approach to handling files without headers.
Tools and techniques you will use for efficient processing.
Estimated timeline and cost.