Populate Spreadsheet from CSV Data

The project is straightforward: take the raw CSV files I supply and populate a clean, well-structured spreadsheet. From each file you will extract three specific data groups—customer details, sales data, and inventory numbers—and place them into the exact column order I’ll share once we begin.

Accuracy matters. If a record is incomplete or two figures don’t match, simply highlight that cell so I can review it later; no blanks or silent fixes, please. The finished file should be ready for quick filtering and basic pivot-table analysis in Excel, so normalising date formats and trimming stray spaces as you go will be appreciated.

Deliverables
• One fully populated Excel workbook, neatly formatted
• All discrepancy cells visibly highlighted (use any colour except red, which is reserved for my internal notes)

Acceptance Criteria
• Every CSV row appears once in the spreadsheet
• Customer, sales, and inventory fields align with the template headers
• No unhighlighted discrepancies or untrimmed text remain

If you work comfortably with Excel functions such as VLOOKUP/XLOOKUP, text-to-columns, and conditional formatting, this task should be quick and clean.