Car Track POC

Excel Sheet Merger & Cleaner

Upload one or more branch Excel files. They will be cleaned and merged into a single downloadable sheet.

📂
Drop Excel files here
or click to browse  ·  .xlsx / .xls

Cleaning applied to each file

  • Reads the 2025 sheet (falls back to first sheet if not found)
  • Strips leading/trailing spaces in all text columns
  • Replaces __ phone placeholders with blank
  • Converts "لم تصل" date placeholders to empty date cells
  • Fixes invoice numbers stored as decimals (e.g. 3100019535.0 → 3100019535)
  • Drops fully blank rows
  • Adds a Source File column to identify origin of each row