CSV and Excel import for India Post booking
The workflow available today. Bring an export from any store, marketplace panel or accounting tool, map the columns once, and let validation catch the rows that would have been rejected.
Import mapping
february-orders.xlsx · 248 rows
- Shipping NameRecipient name
- Shipping ZipPIN code
- Total Weight (g)Weight · converted to kg
- Payment MethodCOD flag
241
Validated
5
Warnings
2
Errors
- Row 118 · PIN code has 5 digits
- Row 204 · phone number includes country prefix
Fields PostVery expects
Your columns can be named anything — the mapping screen connects them to these fields. The exact booking template depends on your service and channel, so confirm it with your booking office before a first large run.
Store PIN codes and phone numbers as text in Excel. Numeric formatting silently removes leading zeros and adds separators, which is the most common cause of rejected rows.
| Field | Notes | Requirement |
|---|---|---|
| Reference | Your order number | Required |
| Recipient name | Printed on the label | Required |
| Address 1 / 2 | Split address lines | Required |
| City / State | Destination | Required |
| PIN code | Six digits, stored as text | Required |
| Phone | Ten digits, no prefix | Required |
| Weight | Single unit across the file | Required |
| Declared value | For insured movement | Optional |
| COD amount | Zero or blank for prepaid | Conditional |
| Contents | Short description of goods | Optional |
From upload to booking file
- 1
Upload
Drop in a CSV or XLSX export. The header row is detected automatically.
- 2
Map
Connect your columns to PostVery fields, or reuse a saved mapping.
- 3
Validate
PIN, phone, weight, value and COD checks run on every row.
- 4
Generate
Produce the booking file, then import the result to attach article numbers.
Works with any source
- Shopify order export
- WooCommerce export
- Marketplace seller panel
- Accounting software
- Your own tracker sheet
Spreadsheet import FAQs
CSV, XLS and XLSX. The first row is treated as the header row and is used for column mapping.
No. Map your existing export columns once and the mapping is saved, so later imports from the same source are a single click.
They stay in the batch with an error flag and are excluded from the generated booking file. You can correct them inline and regenerate without re-uploading everything.
No. Spreadsheet preparation produces a file you submit through your own India Post channel. Direct API booking requires an eligible contractual account and approval from the department.
Files are processed in batches. Early-access workspaces handle several thousand rows per file; very large files are split automatically.
Stop cleaning spreadsheets by hand.
Import, validate and generate booking files from one screen — available in early access today.