Excel Product Data Cleanup

Project Description
I have a list of 100 e-commerce products that needs to be organized in Microsoft Excel. The source workbook
contains product details with inconsistent text formatting and mixed data formats. I need a freelancer to
standardize the records and deliver a professional, easy-to-use Excel file.
Tasks Required
1. Review all 100 product records in the source workbook.
2. Standardize product names and category capitalization.
3. Remove unnecessary leading and trailing spaces.
4. Convert all prices into numeric USD values with two decimal places.
5. Convert stock quantities into whole numbers.
6. Keep the SKU values unique and verify that required fields are complete.
7. Format the final worksheet with clear headers, filters, and frozen header row.
Required Columns
SKU | Product Name | Category | Price (USD) | Stock | Description
Acceptance Criteria
The final workbook must contain exactly 100 product records, have no duplicate SKUs or missing required
fields, use consistent formatting, and open correctly in Microsoft Excel. Please return the completed .xlsx file.
Communication & Payment
The project is simulated for training purposes. In a real Freelancer.com project, the client should create and
fund a $10 milestone before work begins. The freelancer submits the completed file through the platform and
requests milestone release after client review.