How to Create a Monthly Budget That Survives Real Life
Five steps, one spreadsheet, and a weekly habit that takes less time than making chai. Here is the monthly budget method we build into every template.
Sheetzy guide
By Mani Dazzle, Template maker at Sheetzy · 17 November 2026
CSV stands for comma-separated values: a plain text file where each line is a row and commas mark the columns. Banks, Shopify, Etsy, payment apps and government portals all export data this way because every spreadsheet program on earth can read it.
There is nothing to install and nothing to convert. Google Sheets reads CSVs out of the box - the only skill is knowing which of the three import routes fits what you are doing.
Go to sheets.google.com and click the folder icon (Open file picker) at the top right. Choose Upload, drag your CSV in, and Sheets opens it as a brand-new spreadsheet in one step.
This is the route for a quick look at a bank statement or an export you will not keep. The new file lives in your Drive like any other Sheet.
Open your existing file, then File > Import > Upload and pick the CSV. The important choice is the Import location dropdown: Append to current sheet adds the rows under your data, Replace data at selected cell drops them where your cursor is, and Insert new sheet puts them on their own tab.
This is the route we use when a template needs historical data loaded in - for example past transactions going into a budget tracker's data tab. Set Separator to Comma rather than Detect automatically if the columns come out wrong.
Drag the CSV into drive.google.com. Once uploaded, double-click it and choose Open with > Google Sheets. Drive shows a plain preview first, so do not panic at the unformatted table - the Sheets version opens properly columned.
This route is best when someone emails you a CSV and you want it filed in a specific Drive folder before you even look at it.
If the whole import sits in column A with commas visible, the separator guess went wrong. Delete the imported data, import again, and this time choose the separator manually: Comma for most exports, Semicolon for files from some European tools, Tab for TSV files.
Already imported and do not want to redo it? Select the column, then Data > Split text to columns, and pick the separator there. Same result, no re-import.
Sheets helpfully converts anything date-shaped into its own date format and strips leading zeros from numbers. 007 becomes 7, and 03/04/2026 may flip day and month depending on your locale.
For codes and IDs that must keep their zeros, format the target column as Plain text (Format > Number > Plain text) before pasting or importing. For flipped dates, check File > Settings > Locale - a file exported in US format read under a UK locale swaps day and month silently.
Google Sheets tops out at 10 million cells per file. Most CSVs never come close, but multi-year payment exports can. Split the CSV by year (any text editor can do it) and import the parts onto separate tabs, then point your summary formulas at all of them.
Once your data is in, the next step is usually turning it into something readable - our guide on building a Google Sheets dashboard covers exactly that, and the Ledger sales tracker has the data tab pre-formatted so CSV imports land cleanly.
Yes, natively. Upload the CSV to Google Drive and open it with Google Sheets, or use File > Import inside an existing spreadsheet. No converter or paid tool is needed.
The import guessed the wrong separator. Re-import and set the separator option to Comma (or Semicolon for some European exports) instead of Detect automatically. The columns will split correctly.
Sheets auto-formats anything that looks like a date or a number: 01/02 becomes 1 February and 007 becomes 7. Import into a plain-text formatted column, or fix the column format right after import and re-type only the broken cells.
Save the CSV to Google Drive, open the Drive app, tap the file, and choose Open with Sheets. The mobile app handles small CSVs fine; for files over about 10 MB, use a computer.
Five steps, one spreadsheet, and a weekly habit that takes less time than making chai. Here is the monthly budget method we build into every template.
Half to needs, a third to wants, a fifth to savings. The 50/30/20 rule is the lowest-effort budget that still works - here is how to run it with real numbers.