Clean and Format Product Excel Data

$10-16 USD

Posted 1 minute ago

•

Ends in 6 days

$10-16 USD

Paid on delivery

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: 40814017

About the project

9 proposals

Open for bidding

Remote project

Active 11 secs ago

Place your bid

Bid amount Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

It's free to sign up and bid on jobs

9 freelancers are bidding on average $12 USD for this job

User Avatar
Flag of PAKISTAN

Accurate spreadsheet cleanup and data entry are central to my work, and my 5+ years of bookkeeping experience have trained me to handle records with strong attention to detail. I can organize all 100 product records in Microsoft Excel, standardize product names and categories, remove unnecessary spaces, and ensure prices and stock quantities use the correct formats. My Excel and data-entry skills are well suited to checking SKU uniqueness, confirming required fields are complete, and preserving exactly 100 records. I will also format the worksheet with clear headers, filters, and a frozen header row so the finished .xlsx file is professional and easy to use in Microsoft Excel. Choose me to prepare a clean, consistent, and reliable product workbook for your e-commerce data.

User Avatar
Flag of PAKISTAN

Hello, I see that you're looking to clean and format a list of 100 e-commerce products in Excel. It sounds like the goal is to make the data more organized and consistent, which is essential for effective management and analysis. To tackle this, I would start by carefully reviewing each product record in the source workbook. I’ll ensure that the product names and categories are standardized and remove any unnecessary spaces. I'll also convert prices to the correct numeric format and ensure stock quantities are whole numbers. Maintaining unique SKUs and completing all required fields is a priority as well. Finally, I’ll format the final worksheet with clear headers and filters for easy navigation. With my experience in data processing and Excel, I’m confident in delivering a polished and professional final product. Best regards, Muhammad Arshman

User Avatar
Flag of TURKEY

Hi there, I understand you're looking to standardize and format 100 product records in Excel. I can efficiently organize the product names, ensure all prices are in numeric format with two decimal places, and eliminate any unnecessary spaces. I'll also verify that the SKUs remain unique and the necessary fields are complete, creating an easy-to-use final workbook with headers and filters as per your requirements. Once I complete the task, I'll deliver the .xlsx file fully aligned with your specifications. Please let me know if you have a preferred format for the product descriptions or if there's additional information you wish to include. Regards, Ali

User Avatar
Flag of PAKISTAN

Hi, I can clean and format your 100 product records in Excel, standardizing capitalization, removing extra spaces, and delivering a final xlsx file with filters and a frozen header row. I will work through each record to convert prices to two decimal places, fix stock quantities to whole numbers, verify all SKU values are unique, and confirm no required fields across the six columns are missing. My PDF and Word formatting work gives you a sense of how I handle structured data and document cleanup: https://www.freelancer.com/portfolio-items/11110454-pdf-and-word-formatting Could you share the source workbook so I can see the current formatting issues before starting? Wasim Ameen

User Avatar
Flag of UNITED STATES

Hi, I can clean up all 100 product records and deliver a tidy .xlsx file in 2 days. I'd start by reviewing every row, standardizing product names and category capitalization, trimming extra spaces, converting prices to numeric USD with two decimals, and turning stock counts into whole numbers. I'd then check that every SKU is unique and no required field is blank, and format the sheet with bold headers, filters, and a frozen top row. I'll ask you right away if any product name or price looks ambiguous rather than guessing. I'm based in Florida on Eastern time and reply quickly if you have questions.

内容来自 Freelancer News,版权归原作者所有。

阅读原文 ↗

把喜欢的内容,留在你的新标签页。

打开我的订阅