Import Excel

Upload vendor data — Sheet 1 (C&Ds), Sheet 2 (JNUP)

196 vendor records currently in database (118 fetched from GST portal). Last import: GST_Remaining.xlsx on 05 Apr 2026 09:52

Upload Vendor Excel (.xlsx)

Select Excel File

Drag & drop or click to browse

Excel Structure: Sheet 1 = C&Ds | Sheet 2 = JNUP. Required columns: ProjectWorkPkg_Vendor_Id, PersonJuridiction_GSTIN, PersonJuridiction_Firm_Name. All other columns imported as-is with no validation.

Uploading will replace all existing data (vendors + GST fetch results). Use Clear All Data above first if you want a clean start.

Clear All Data

This permanently deletes all 196 vendor records and all 118 GST fetch results from the database. Identity counters are reset to 1. This cannot be undone.

Column Reference

Column	Description	Required
`ProjectWorkPkg_Vendor_Id`	Unique vendor/package ID	Key
`Person_Name`	Contact person name	Optional
`Person_Mobile1`	Primary mobile	Optional
`Person_Mobile2`	Secondary mobile	Optional
`Person_FName`	Father's / firm name	Optional
`PersonJuridiction_GSTIN`	15-digit GSTIN to verify	For GST
`PersonJuridiction_PAN`	10-char PAN	Optional
`PersonJuridiction_Firm_Name`	Firm name (matched with portal)	For match