Excel Product Data Cleanup
$3-20 USD / hour
Posted 1 minute ago
•
Ends in 6 days
$3-20 USD / hour
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.
Project ID: 40814016
About the project
5 proposals
Open for bidding
Remote project
Active 5 secs ago
Place your bid
Bid amount Email addressBenefits of bidding on Freelancer
Set your budget and timeframe
It's free to sign up and bid on jobs
5 freelancers are bidding on average $13 USD/hour for this job


Prices hiding as text like "$1,299.00" or "12 pcs" in stock will break sorting and totals; you get true numbers that sum and filter. You get a cleaned 10-row sample within a day to confirm the look, then the full workbook with a short change log noting every value I altered, well inside 7 days. 1. If a price is in a non-USD currency, which rate should I apply? 2. For a true duplicate SKU, keep the first row or flag it for your call? Happy to start as soon as you open a chat.


Hi there, I see you need help organizing a list of 100 e-commerce products in Excel. It sounds like you’re looking for someone to clean up inconsistent formatting, standardize product details, and ensure that all necessary information is accurate and easy to navigate. I can help with that! My approach would involve going through each product record carefully to make sure everything is consistent—this includes standardizing names and categories, cleaning up spaces, and formatting prices and stock quantities correctly. I’ll also ensure that SKUs are unique and that all required fields are complete. After organizing the data, I’ll format the final worksheet with headers and filters for easy use. I’m confident in my ability to deliver a polished Excel file that meets your criteria. Best regards, Muhammad Arshman


Hi there, I see you need to standardize a list of 100 e-commerce products in Excel. I can ensure accurate formatting by reviewing each record for consistency in product names and categories while converting the prices to numeric USD values with two decimal places, as well as ensuring stock quantities are whole numbers. Each SKU will be kept unique while verifying that all required fields are filled in appropriately. I will deliver a professional, easy-to-use Excel file with all the records accurately formatted, including clear headers and filters as outlined. Looking forward to collaborating on this task. Regards, Ali
内容来自 Freelancer News,版权归原作者所有。
阅读原文 ↗