Creating a DIY debt repayment spreadsheet using CSV exports from your loan calculator
$104,215: The Average Household Debt That Demands a System
The Federal Reserve's most recent household debt snapshot puts the average American household at $104,215 across mortgages, auto loans, student debt, and revolving credit. That number is abstract until you are the one staring at three separate loan portals on a Tuesday night, trying to figure out which payment actually moves the needle.
Picture a specific scenario: you are a self-employed graphic designer carrying $47,300 in combined debt across a federal student loan, a used-car note, and a lingering business credit card balance from a slow quarter. You have already run the numbers through a loan calculator. You have the amortization schedules. What you do not have is a single view that tells you, in one glance, where you stand and what to pay next.
That is the gap a DIY debt repayment spreadsheet fills. And the building blocks are already sitting in your downloads folder as CSV exports.
$47,300: Mapping Your Total Debt From Three CSV Exports
Before you build anything, you need clean source data. Open your loan calculator of choice and export the full amortization schedule for each debt as a CSV file. For our designer scenario, that means three files:
- Student loan: $18,400 balance, 6.8% APR, 84 months remaining
- Auto loan: $22,900 balance, 7.9% APR, 51 months remaining
- Credit card: $6,000 balance, 22.4% APR, revolving
Each CSV will arrive with its own column structure. That is fine. You are not going to merge them raw. You are going to extract the four data points that matter and drop them into a single master sheet.
What to pull from every export
Open each CSV and isolate these fields: payment number, scheduled payment, principal portion, interest portion, and remaining balance. If your loan calculator's export includes a date column, grab that too. If it does not, you will generate dates manually in the next step.
4 Columns: The Minimum Viable Spreadsheet Structure
Create a new spreadsheet. Resist the urge to overengineer it. The goal is a working dashboard, not a financial model. You need four core columns per debt, plus one row per payment period.
The column map
- Payment Date — first of each month, or aligned to your pay cycle
- Debt Name — Student, Auto, Card
- Scheduled Payment — pulled directly from the CSV
- Remaining Balance — pulled directly from the CSV
Add three calculated columns after those: Actual Payment (what you actually sent), Variance (Actual minus Scheduled), and New Projected Payoff Date (recalculated when you overpay).
How to map CSV fields cleanly
Copy the scheduled payment and remaining balance columns from each CSV export into your master sheet, one debt at a time. Use a filter or sort to keep each debt's rows contiguous. If your loan calculator exports with headers like Pmt #, Interest, and Balance, rename them on paste to match your master schema. Consistency now saves you hours of debugging later.
$3,847: What Avalanche Versus Snowball Actually Saves You
This is where your spreadsheet earns its keep. With all three debts mapped, you can now model two repayment strategies against the same baseline and see the real dollar difference.
The avalanche calculation
Sort your debts by APR, highest to lowest. Apply every spare dollar to the credit card first while paying minimums on the student loan and auto loan. Using our scenario's numbers — $6,000 at 22.4%, $22,900 at 7.9%, $18,400 at 6.8% — and assuming $900 per month in total debt spend, the avalanche method retires all three debts in roughly 41 months with total interest paid of approximately $5,180.
The snowball calculation
Sort by balance, lowest to highest. Same $900 monthly spend, but you attack the $6,000 card first, then the $18,400 student loan, then the $22,900 auto loan. Total interest comes in around $9,027 over roughly 47 months.
The difference: $3,847.
That number is not theoretical. It is sitting in your spreadsheet, derived from the same CSV exports you pulled five minutes ago. Once you see it in your own rows, the strategy decision stops being a debate and becomes a click.
$312 Per Month: Building Your Repayment Trigger Formula
A spreadsheet that only shows you what is owed is a passive document. A spreadsheet that tells you what to do next is a system. The bridge between the two is a trigger formula.
Setting the minimum floor
Add up the three scheduled minimum payments from your CSV exports. In our scenario, that is roughly $268 for the student loan, $481 for the auto loan, and $120 for the credit card — a floor of $869. Round to $900 for psychological simplicity. That is your baseline obligation.
The overflow formula
In a new cell, define your monthly debt budget. Let us call it $1,200. Subtract the floor: $1,200 minus $900 equals $312. That $312 is your overflow, and it routes automatically to whichever debt sits at the top of your avalanche sort.
In spreadsheet terms, the formula looks something like:
=IF(AND(Debt="Card", Balance>0), Overflow, IF(AND(Debt="Student", Balance_Card=0), Overflow, IF(AND(Debt="Auto", Balance_Card=0, Balance_Student=0), Overflow, 0)))
When the credit card hits zero, the overflow reroutes to the student loan. When that hits zero, it moves to the auto loan. You never have to manually recalculate. The spreadsheet handles the cascade.
15 Minutes: Your Monthly Reconciliation Routine
The system only works if you feed it. Set a recurring calendar block for the first Sunday of each month. Fifteen minutes. No more. Here is the checklist:
- Export fresh CSVs from your loan calculator for each debt (2 minutes)
- Update the Actual Payment column with what you sent last month (3 minutes)
- Paste new remaining balances into the master sheet (3 minutes)
- Check the overflow cell — confirm it is routing to the correct debt (1 minute)
- Log the variance — note any overpayment or shortfall and why (3 minutes)
- Update the projected payoff date — rerun the loan calculator with the new balance if you overpaid (3 minutes)
Fifteen minutes. Six steps. If you cannot complete the routine in that window, your spreadsheet is too complex. Strip a column.
90-Day Milestones: Reading the Spreadsheet Like a Dashboard
Monthly reconciliation keeps the data current. Quarterly review keeps the strategy honest. Every 90 days, step back and read the spreadsheet as a dashboard, not a ledger.
Day 30 checkpoint
Confirm the credit card balance has dropped by at least $312 plus its scheduled principal portion. In our scenario, that is roughly $400 of progress in the first month. If the number is lower, your actual payments are not matching your plan. Find the leak.
Day 60 checkpoint
The card should be under $5,200. The student loan and auto loan should be tracking their original amortization schedules exactly — no drift, no surprises. If the auto loan balance is higher than the CSV projected, you missed a payment or the servicer applied funds to interest differently than expected. Re-export and compare line by line.
Day 90 checkpoint
This is your first real milestone. The card should be approaching $4,400. Total debt should be under $45,900. More importantly, your overflow formula should still be routing to the card. If the card is gone early, the cascade has already moved to the student loan, and your spreadsheet should reflect that automatically.
What to adjust
If your income fluctuates — and for a self-employed designer, it always does — the 90-day mark is when you recalibrate the monthly debt budget cell. A strong quarter might push it from $1,200 to $1,450. That extra $250, routed through the same overflow formula, shaves months off the back end without any structural change to the spreadsheet.
One File, Three Debts, Zero Guesswork
The point of building this yourself is not to replicate what a commercial debt app does. It is to own the logic. When you export CSVs from a loan calculator, paste them into a four-column master sheet, and wire an overflow formula to cascade payments by APR, you have built a repayment engine that is transparent, auditable, and tunable.
$47,300 becomes a row count. $3,847 becomes a cell reference. $312 becomes a monthly instruction. And the question of which debt to pay next — the one that keeps people up at night — becomes a formula that already answered itself.