Using the templates in Google Sheets, Excel or LibreOffice

All spreadsheet templates in the library are saved as .xlsx, the most widely supported spreadsheet format.

Microsoft Excel

Double-click the file. If Excel shows a “Protected View” bar, click Enable Editing so formulas can update.

Google Sheets

Open Google Drive, click New, then File upload, and choose the template. Right-click the uploaded file and pick Open with, then Google Sheets. Use File, then Save as Google Sheets to keep an editable copy.

LibreOffice and Numbers

Open the file directly. Formulas recalculate when you change a yellow input cell.

Tip: start on the Start Here tab, then look at Sample Data before typing your own numbers into the Tracker tab.

Get the templates behind this post

Join free and download 3 items every month, or upgrade for the full library. See plans