To use the tables feature in Google Sheets, select your expense log, open Format > Convert to table, and then set a type for each column from its header menu: Date for the date, Currency for the amount, Dropdown for the category. New rows typed under the table then pick up the same formatting and the same dropdown automatically.
How do I convert my expense log into a table?
- Make sure the log has one header row with a name for every column, such as Date, Description, Category, Amount and Mode.
- Click any cell inside the data.
- Choose Format > Convert to table. The range gets banded colours, filter arrows and header menus. A keyboard shortcut for the same step exists, but the menu is easier to find.
- Confirm the range Sheets proposes. If it grabbed an empty row or left out a column, adjust it in the side panel.
If the menu item is missing, the feature may not be available on your account or file yet, or you may be viewing the file without edit rights. Older files should still convert, but test on a copy first.
Which column types should an expense log use?
| Column | Column type | What it gives you |
|---|---|---|
| Date | Date | A date picker, and a consistent date format on every row |
| Description | Text | Free text for the merchant or reason |
| Category | Dropdown | A fixed list of categories, so spelling stays the same |
| Amount | Currency | Rupee formatting, which can be set to show ₹ and two decimals |
| Mode | Dropdown | UPI, Card, Cash and so on, picked from a list |
Open a column's menu from its header (the small arrow) and choose the column type. For Dropdown, you type the list of options once and give each one a colour if you like. Colours make the sheet easier to scan, especially for categories.
Do new rows really inherit the setup?
Yes, and this is the main reason to bother. Click the first empty cell beneath the table and type. The table grows to include that row, and the new row gets the date type, the dropdown and the currency format from its column. With a plain range, you would have to copy formatting down or set data validation again.
How do formulas treat a table?
Tables let you refer to a column by name rather than by cell address. You can write something like =SUM(Table1[Amount]), where Table1 is the table's name and Amount is a column heading. As rows are added, the reference follows. The table's name is shown in the side panel for the table, so read it there rather than assuming.
Plain ranges still work as they always did. If you prefer, you can keep using =SUMIFS($D$2:$D$500, $C$2:$C$500, "Groceries") for totals and use the table only for entry. That also keeps your formulas readable by someone who has not met tables before.
What are the limits to know about?
- A table is a feature of newer Sheets. A file shared with someone on an older setup may not show it the same way, so check with a collaborator.
- Column types describe the data, but they do not clean old entries. A date typed as text before conversion may need to be fixed first.
- Existing entries that are not in your dropdown list stay as they are, and may show differently until you add that option or change them.
- Converting back is possible from the table menu, which returns the data to a plain range with the formatting kept.
How should I set up the dropdown list?
Think of the list as the vocabulary of your budget. Keep it to the categories you will actually total, such as Groceries, Rent, Fuel, Eating out, Utilities, School fees and Medical. Add a Misc option only if you must. Check the spelling now, because a later rename will not change the rows already filled. Avoid two categories that overlap, such as Food and Groceries, since you will end up splitting similar spends between them.
When does a table stop being enough?
A table is a good entry form, but you are still the one typing, and still the one who has to read rows from a bank statement. When that becomes the tedious part, an app that imports statements may help. SpendixAI lets you upload a bank or card statement as PDF, CSV or Excel, review the rows, and keep each transaction against its account.
Set-up checklist
- One header row, no blank columns.
- Date, Currency and Dropdown types set.
- Category list agreed and spelled once.
- A test row typed under the table.
- A copy of the file saved before you begin.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


