Upload multiple Excel / CSV / TXT / PDF / Image files together. The tool reads every usable file, merges all detected policies, removes duplicate Policy Nos, sorts by Expiry Date, and creates one A4 Portrait PDF.
Select many files at the same time—even mixed CSV, TXT, Excel, PDF and Image files. Each file is processed independently, then all usable policy rows are merged into one report. One unreadable file will not discard the other successfully-read files.
Choose one expiry date, or keep All Dates for one date-wise PDF.
Ready
Policy No + Expiry Date are the minimum mandatory fields. Other requested fields are captured wherever they exist; if a source genuinely does not contain a field (for example Mobile No), that cell is left blank instead of inventing data.
Version check: this page must show V5.0 beside the title.
Rows detected
0
Unique policies
0
Duplicates removed
0
Expiry dates
0
Output: Total S.No + Date S.No + Policy No + Policy Type + Vehicle Type + LOB + Insured Name + Mobile No + Vehicle Reg. No + Expiry Date + Renewed Tick
0 / 0 tickedClick anywhere on a policy row to toggle its tick.
Total S.No
Date S.No
Policy No
Policy Type
Vehicle Type
LOB
Insured Name
Mobile No
Vehicle Reg. No
Expiry Date
Renewed
Default rule: only policies whose Expiry Date is today or already past are ticked automatically. Future-expiry policies start unticked. Click the Renewed box or anywhere on a policy row to toggle it. Mixed file types are merged into one report. When all displayed Expiry Dates belong to one April–March financial year, the PDF heading automatically shows that Policy Register year. The 11 columns remain on one A4 Portrait width.