Home › Amortization schedule Excel download
Amortization schedule Excel download
Build your schedule, then download it to Excel in one click — a finished, formatted .xlsx with your numbers already filled in. No blank template, no typing.
Build, then download to Excel
Amortization schedule
| # | Date | Payment | Principal | Interest | Extra | Balance |
|---|
Estimates only, not a loan offer. Excludes taxes, insurance and fees unless entered. See our disclaimer.
The finished spreadsheet, not a blank template
Search "amortization schedule Excel" and you mostly find empty templates — you still have to learn the formulas and re-type your loan. This page does the opposite: enter your loan above and click Excel (.xlsx) to download the completed schedule, correctly calculated, with a formatted summary tab and every payment laid out.
What's inside the .xlsx
- Summary tab — loan amount, rate, term, payment, payoff date, total interest, and (with extra payments) interest and time saved.
- Schedule tab — every payment with beginning balance, principal, interest, extra, ending balance, plus cumulative interest and principal columns most free tools leave out.
- Comparison + dual schedules — if you add extra payments or choose biweekly, the file also includes a side-by-side comparison and both the accelerated and baseline schedules.
- Real Excel formatting — currency number formats, real date cells, a frozen header row, and an autofilter so you can sort and slice it yourself.
Prefer a different format? The same one-click download is available as a clean
CSV for your own analysis or a printable
PDF.
Why people download it
- Track how much interest is deductible each year for taxes.
- See exactly how extra payments move your payoff date before committing.
- Share a clean schedule with your spouse, lender, or accountant.
Frequently asked questions
- How do I download an amortization schedule to Excel?
- Enter your loan amount, rate and term above, then click the Excel button. You instantly get a formatted .xlsx workbook containing a summary tab and the full month-by-month schedule — already filled in with your numbers. No template, no manual typing.
- Is the Excel download free?
- Yes, completely free with no sign-up. You also get one-click CSV and PDF downloads of the same schedule.
- What is in the Excel file?
- A Summary tab (loan details, payment, payoff date, total interest, and interest saved if you add extra payments) plus a Schedule tab with every payment: beginning balance, principal, interest, extra, ending balance, and cumulative interest and principal. If you add extra payments, the workbook also includes a Comparison tab and both the accelerated and baseline schedules.
- How is this different from a blank Excel template?
- A template is empty — you still have to build the formulas and type your loan in. This builds the finished schedule from your inputs and hands you the completed file, correctly calculated, with a guaranteed exact $0.00 final balance.