Bulk GST calculator
Open a CSV or paste from a spreadsheet. Choose the price column and the direction, then download your list with GST columns added.
The short answer
Every row is worked out to the cent in your browser and the file never leaves your device. The total GST row by row can differ by a few cents from GST on the column total; both are shown.
Item,Price Flat white,5.50 Banana bread,6.90 "Beans, 1kg",42.00 Keep cup,24.95
Your file is read in your browser and never uploaded.
Worked example: a café price list with GST added.
| Item | Price | GST exclusive | GST | GST inclusive |
|---|---|---|---|---|
| Flat white | 5.50 | 5.50 | 0.83 | 6.33 |
| Banana bread | 6.90 | 6.90 | 1.04 | 7.94 |
| Beans, 1kg | 42.00 | 42.00 | 6.30 | 48.30 |
| Keep cup | 24.95 | 24.95 | 3.74 | 28.69 |
How it works
Paste rows from a spreadsheet or open a CSV file. The tool finds the price column, adds or removes GST on every row, and adds three columns: before GST, GST and including GST. Commas, semicolons and tabs all work, and amounts with dollar signs and thousands separators, like “$1,234.50”, are read correctly.
Nothing is uploaded
Your file is read by your browser and never sent to us or anyone else. The result is created on your device and downloaded from the page. Close the tab and it is gone.
Rows and totals
Each row is rounded to the cent. Added up, the row-by-row GST can differ by a few cents from GST worked on the column total; the tool shows both. In a GST return, boxes 8 and 12 are worked on totals (IR375 pp12 to 13).
When this does not apply
- Lists that mix zero-rated or exempt items: filter them out first.
- Files over the row limit: split them.
Sources
Official sources checked 17 November 2026. General information, not tax advice; if anything here differs from Inland Revenue’s guidance, follow IRD.
Questions
Is my file uploaded?
No. It is read and processed in your browser, and the download is created on your device.
What formats work?
CSV with commas, semicolons or tabs, or rows pasted from Excel or Google Sheets. Amounts can include $ signs and thousands separators.
More calculators
Every GST calculator
GST calculator
Type any amount: GST added, GST removed and the GST, at once.
Open →Add GST
Exclusive to inclusive: times 1.15.
Open →Remove GST
Find the GST in a price: times 3/23.
Open →Reverse GST
From a GST amount back to both prices.
Open →Price rounding
Shelf prices like $9.99 that land exactly.
Open →Invoice calculator
Many lines, per-line or per-total rounding, and what the invoice must show.
Open →GST return estimate
Boxes 5 to 15 of the GST101A, with the due date.
Open →Due dates
Your next returns, with weekends and holidays, as a calendar file.
Open →Registration checker
Have you passed $60,000? The rolling 12 months.
Open →Entertainment adjustment
The 50% rule for box 9.
Open →Secondhand goods
Claim 3/23 on goods from private sellers.
Open →Apportionment
Mixed use, adjustment periods, wash-ups and sales.
Open →Flat-rate credit
Uber, Airbnb and delivery: the 8.5% credit.
Open →Property sale GST
15%, zero-rated or no GST, and “plus GST (if any)”.
Open →Imports
Duty, GST and levies, and the $1,000 rule.
Open →Long-stay accommodation
After 4 weeks, GST on 60%.
Open →