Integration · Spreadsheets

PRACHSO and Microsoft Excel

The munshi's register is usually an Excel file. Upload it as it is, and PRACHSO picks out vehicle and licence numbers, reads every date from the registry and shows you where the register was wrong. Every calendar view, challan report and renewal spend report exports back to .xlsx.

What moves

What is read or written, and which way.

Available on: All plans.

DataDirection
Vehicle and licence numbers from any .xlsx or .csvInto PRACHSO
Calendar, challan and spend reports as .xlsxOut of PRACHSO
Register vs registry difference reportOut of PRACHSO

Setup

4 steps to connect.

PRACHSO's onboarding team does the first import and the mapping with you during the 14-day trial.

  1. 1

    Step 1

    Upload the file, or email it to PRACHSO's team for the first import.
  2. 2

    Step 2

    Confirm which columns hold the vehicle number, licence number and branch.
  3. 3

    Step 3

    PRACHSO reads every record and returns a difference report: dates in the register that do not match the registry.
  4. 4

    Step 4

    Export any view to .xlsx from then on.

Field mapping

Where each field lands.

Microsoft ExcelPRACHSO
Vehicle No. / Gaadi No.Vehicle number
DL No.Licence number
Branch / DepotBranch
Register date (any column)Compared, not imported

How access works

File upload and download only. PRACHSO does not need access to your Microsoft account.

Questions about Microsoft Excel

Ask the team

Our register has merged cells and Hindi headings. Will it work?

Usually, yes. The team maps the columns on the first import, and the template is saved for the next upload.

Do we still need the register?

Keep it alongside PRACHSO for as long as you like. Once the difference report comes back clean, the register has nothing left to add.

Know every expiry before the checkpoint does.

Send us your vehicle list. We load your fleet and show you every date and every pending challan on the call.