Consolidate Customer Data in Excel

via Freelancer ·

Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted52 minutes ago
I have multiple Excel workbooks filled with customer contact details—names, phone numbers, email addresses—alongside their sales and order history. I need these files merged into one master sheet that is tidy, consistently formatted, and free of clutter.

Here is what matters most to me:
• Combine every worksheet into a single, well-structured workbook.
• Identify duplicate customer records and keep only the most complete version of each record, discarding the rest.
• Retain both the contact information and the corresponding sales/order history so each customer’s activity remains intact.
• Apply clear, uniform column headers and date/phone/email formatting so the data is easy to filter or pivot in the future.

Deliverable:
A final Excel file (.xlsx) containing the consolidated, de-duplicated dataset, ready for immediate analysis. A brief “change log” sheet outlining any major cleaning actions you took (e.g., number of duplicates removed) would be appreciated.
visual basic data processing data entry excel data visualization data analysis data integration data management
Apply on Freelancer →

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