Excel Data Cleaning & Formatting

via Freelancer ·

Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted3 hours ago
I have a sales-data spreadsheet with well over twenty columns that needs a meticulous clean-up. The file currently contains duplicate rows, inconsistent date and number formats, scattered blank cells, and several fields—especially names and email addresses—that must be converted to ALL CAPS for consistency.

Here’s what I need done:
• Remove every duplicate record without losing unique information.
• Standardise dates, currency, and numeric fields so the whole sheet follows one clear format.
• Re-organise names, emails, phone numbers, and any loose text into their correct columns.
• Identify blanks or incorrectly formatted entries and either correct or flag them for me.
• Finish by applying a tidy, professional layout (freeze headers, clear font hierarchy, conditional formatting where useful).

You may use native Excel tools, formulas, or Power Query—whatever gets the job done accurately. When you’re finished, I’d like:
1. The cleaned .xlsx file, ready for immediate use.
2. A concise note (or separate tab) summarising the main fixes, so I can trace what changed if needed.

Let me know your price and the turnaround time you can commit to, and I’ll get the file to you right away.
data processing data entry excel word excel vba excel macros data analysis data management
Apply on Freelancer →

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