← Back to guides
ImportVista · Guides · Landed Cost

Landed Cost Spreadsheet: How to Calculate Import Costs in Excel

Learn how to structure a landed cost spreadsheet and calculate purchase value, freight, duties, taxes and cost per unit in Excel.
October 03, 2026 1 min read
Landed Cost Calculator Excel dashboard by ImportVista

A landed cost calculation answers a simple but important question: what does an imported product really cost by the time it reaches your business?

What to include in landed cost

A practical landed cost spreadsheet normally brings together the purchase value, international freight, insurance, customs duties, taxes where applicable, destination charges, local transport and other operation-specific costs.

Why cost per unit matters

The total shipment cost is useful, but many purchasing decisions depend on cost per unit. Divide the total landed cost by the number of units received to estimate the real unit cost before setting margins or comparing suppliers.

A simple Excel workflow

  1. Enter the purchase value and currency.
  2. Add freight, insurance and origin/destination charges.
  3. Enter the applicable duty and tax assumptions.
  4. Add local delivery or other charges.
  5. Calculate total landed cost and unit cost.

Keeping each cost component visible makes the calculation easier to review and update when a quote changes.

Use a ready-made template

The ImportVista Landed Cost Calculator includes a quick calculator, dashboard, historical operations and unit-cost calculations in Excel.

If you also need shipment tracking and document control, the Essentials Pack combines all three tools.

1LearnUnderstand the workflow in this guide
2TryUse a free tool first
3PROMove it into a reusable template
View recommended template · €19,99 →
See use case: 20 imports/month →
Logistics resources

Get new guides and free logistics tools

Only import, export, freight and Excel content. Unsubscribe at any time.

Put the guide into practice

Use Excel tools built for real logistics operations.

Shipment tracking, landed cost, freight quotes, documentation and free days in ready-to-use templates.

Can I try ImportVista before buying?+

Yes. ImportVista offers free online calculators and Excel resources so you can test the workflow before moving to a PRO template.

Do the templates connect automatically to carriers or ERP systems?+

No. Standard templates use the data you enter in Excel. Carrier APIs, ERP, TMS and external automations are separate projects.

Is it a subscription?+

No. Standard templates and packs are one-time purchases; any product with different terms states them clearly on its product page.