This guide is in English for now. The tool itself works in your language.
E-Way Bill › E-way bills from Excel
Many e-way bills at once from Excel
The portal's bulk generation takes one JSON file with many e-way bills. Fill our Excel template, one row per item, and the maker turns it into that file, checking each e-way bill against the portal's own rules first.
Step by step
- Choose your business in step 1 of the Excel section (from your saved businesses; add one in My data if needed).
- Download the Excel template. The How to fill sheet explains every column.
- One row per item. Rows with the same Document No make one e-way bill; the buyer and transport details are read from its first row.
- Choose the filled file (.xlsx or CSV UTF-8). Fix any rows the list shows, save, and choose it again.
- Download the e-way bill file and upload it at ewaybillgst.gov.in › e-Waybill › Generate Bulk › Choose file › Generate.
- The portal lists the e-way bill numbers. Press Export to Excel there and choose that file in step 3 here: the numbers go onto your saved invoices and into the Part B table.
- No vehicle yet? Fill the Part B table later and upload the vehicle file under e-Waybill › Update Vehicle Bulk.
Which document for which reason
The portal accepts only these pairs for goods going out (NIC bulk validations):
| Sub Supply Type (reason) | Document Type | Goes to |
|---|---|---|
| Supply | INV tax invoice, BIL bill of supply | Buyer (GSTIN or unregistered) |
| Export | INV, BIL | Unregistered (URP), outside India |
| Job Work | CHL delivery challan | Job worker |
| SKD/CKD/Lots | INV, BIL, CHL | Buyer |
| For Own Use, Exhibition or Fairs, Line Sales | CHL | Yourself (your own GSTIN) |
| Recipient Not Known | CHL, OTH | Yourself |
| Others (say what) | CHL, OTH | Yourself or another party |
With a bill of supply, a delivery challan or "others", the tax rate must be 0 on every item. For "own use", exhibitions, line sales and "recipient not known" the maker puts your own GSTIN as the receiver for you.
The transport columns
| Column | What to type |
|---|---|
| Distance km | Up to 4,000. 0 lets the portal work it out from the PIN codes. |
| Transport Mode | Road, Rail, Air or Ship. Empty (with no vehicle) = Part A only. |
| Vehicle No, Vehicle Type | Like PB10AB1234; R regular, O over-dimensional cargo |
| Transporter ID, Name | Transporter's GSTIN or 15-character TRANSIN. By road, give this or the vehicle. |
| Transport Doc No, Date | LR, RR or airway bill. Needed for rail and air. |
| Ship To Address, City, PIN, State Code | Only when the goods go to another place than the buyer's address; for an export, the port in India. |
A worked example
A Ludhiana garment unit sends cut fabric to a job worker in Panipat (Haryana) on challan DC/26-27/045, worth ₹38,000. Job work to another state needs an e-way bill at any value. Row: Document No DC/26-27/045, Document Type CHL, Sub Supply Type Job Work, GST % 0, Transport Mode Road, Vehicle No PB10AB1234, Distance 0.