Free Excel templates for people who import goods
This site publishes free spreadsheet templates for importers, with no email gate and no signup. Every template is a plain .xlsx file you download directly and open in Excel, LibreOffice, or Google Sheets.
Available templates
Each template is added to this list when it is finished and tested. The first two are Excel files; the chart and the calculator below them are free too.
- Landed cost calculator (Excel template) — adds every import cost across nine sections and returns landed cost per unit, net margin and the break-even selling price for a single SKU.
- Proforma invoice template (Excel) — a quotation in invoice format, with Incoterms 2020 and currency dropdowns, twelve goods lines, and automatic deposit and balance amounts.
- Incoterms 2020 chart (free PDF) — all eleven rules on one page: who pays, who carries the risk, and where risk passes from seller to buyer.
- Intimates landed cost calculator — classifies bras, panties, shapewear and sleepwear by fiber and construction, then builds the per-unit landed cost.
The first two work together: quote the buyer with the proforma invoice, and cost the purchase with the landed cost calculator before you agree a price.
Free calculators
Quick calculators that run in your browser. Every rate is editable.
- US tariff & import duty calculator — MFN duty, Section 301 and 232 add-ons, MPF and HMF, and landed cost per unit.
- Freight class calculator — LTL density and class on the 13-step NMFC scale.
- Dimensional weight calculator — billable weight for UPS, FedEx, USPS, express and air freight.
- CBM calculator — carton volume, LCL and air chargeable weight, and container fill.
Rather have someone handle it in China? Get help with sourcing, inspection or shipping.
Guides
Short worked guides that explain the numbers the templates ask for.
- Landed cost formula, explained line by line — two worked examples shipping from China to the US.
- How to calculate tariffs on imports from China (2026) — the duty layers for Chinese goods and what changed after the IEEPA ruling.
- How to calculate import duty and tariffs — find the HTS code, set the customs value and stack the duty layers.
- How to allocate freight costs across SKUs — the same shipment split by weight, volume and value.
- DDP vs FOB vs EXW — one shipment quoted three ways, and which costs you pay under each.
- Hidden import costs — bonds, chassis fees, demurrage and other charges a supplier quote leaves out.
Why these templates have no signup
An email gate adds friction without improving the file, so there is not one here. Downloads are static files served straight from this site, with no redirect page, no tracking interstitial, and no newsletter prompt.
What this site does not do
This site does not give customs, tax, or legal advice, and it does not publish duty rates. Rates and fees change and depend on product classification and country of origin, so the templates leave those inputs to you and to your customs broker. Read the full disclaimer.
Last updated: November 11, 2026