Open an Excel sheet on your phone and you know the feeling straight away: tiny cells, accidental taps, pinching and zooming just to type one number. Excel and other spreadsheet programs were designed for a mouse and a big monitor. Yet most of the data we need to record (a sale, a delivery, a site visit, an expense) happens when we are away from a desk.
The good news is that a phone can be an excellent place to keep a spreadsheet. You just need to make your table for a small screen instead of copying the way you would build an Excel sheet on a laptop. This guide shows how, using Table Notes, a free table maker app for Android and iPhone.
1. Start with the question your sheet should answer
Before creating a single column, write down what you want to know at the end of the week or month. For example:
- "How much did each customer buy this month?"
- "Which sites have we inspected, and which are still pending?"
- "How much did I spend on fuel compared to last month?"
Your columns should exist only to answer that question. Every extra column is another field to fill in on a small screen, and the more fields there are, the more likely people are to skip them.
2. Make one table per thing you track
In desktop Excel it is tempting to put everything in one giant sheet with several tabs and merged cells. On a phone, a simpler structure works much better: one table for each kind of record. Customers in one table, orders in another, expenses in a third.
Each row is one record (one customer, one order, one receipt) and each column is one piece of information about it. If you find yourself typing the same details again and again in different rows, that information usually belongs in a separate table.
3. Choose the right column type for each field
This is the single biggest difference between a frustrating spreadsheet on mobile and a pleasant one. When every column is plain text, you end up typing everything, and the data becomes inconsistent ("Delhi", "delhi", "New Delhi"). When each column has a type, the phone shows the right input for the job.
Table Notes column types you choose from when you add a column:
- Number and Amount for quantities and money, so you get the numeric keypad and can total the column, just like a SUM in Excel.
- Date and Time so you pick from a calendar instead of typing dates in different formats.
- Select for a fixed list of options, such as status (Pending, Done), category or city. One tap, and everyone spells it the same way.
- Checkbox for yes/no answers like "Paid" or "Delivered".
- Phone for contact numbers you may want to call later.
- Photo, Audio, Signature and Location for things an ordinary Excel sheet can't capture easily: a picture of a receipt, a voice note, a customer's signature, or a pin on Google Maps.
- Barcode to scan a product code with your camera instead of typing it.
- Formula for values calculated from other columns, such as quantity multiplied by price.
A good rule: if a column only ever has a few possible values, make it a Select. If it is a number you will ever want to add up, make it a Number or Amount.
4. Put the most important columns first
A phone screen shows only a few columns of a table at once. Order your columns so the ones you look at most (name, date, status, amount) come first, and push rarely used details to the end. You can rearrange and hide columns at any time without losing data, so it is worth revisiting the order after a week of real use.
5. Enter data with a form, not by tapping cells
Tapping individual cells in an Excel sheet on a phone is slow and error-prone. Adding a row through a form is much faster: you get one field per column, laid out vertically, with the right keyboard or picker for each one. You scroll down, fill it in, and save. That is what makes Table Notes feel like a data entry app rather than a shrunken desktop spreadsheet.
It also makes it easier to hand data entry to someone else. A field worker or a new employee doesn't need to understand the sheet; they just fill in the form.
6. Import your existing Excel sheet
If you already have the data in Microsoft Excel or Google Sheets, import the Excel file rather than retyping it. Table Notes imports Excel sheets into a table, and you can export back to Excel at any time, so moving between your phone and a desktop spreadsheet isn't a one-way door.
For common needs such as attendance, inventory or expenses, starting from a ready-made template saves you from designing the columns yourself. You can always rename or add columns afterwards.
7. Use filters instead of scrolling
Once a table has a few hundred rows, scrolling stops being practical. Filters let you see just what matters right now: this month's orders, unpaid invoices, or one customer's history. If you use the same filter often, save it so it is one tap away next time.
8. Back up your tables and open them on your PC
A spreadsheet that lives only on one phone is one lost phone away from disappearing. Table Notes syncs your tables to the cloud, so you can sign in on another phone or tablet, or open the same data in a browser at tablenotes.net on your PC. You can also create a backup of all your tables as Excel files.
Example: a simple payment-tracking table
Say you run a small tiffin service and want to know who has paid each month. A phone-friendly table could look like this:
- Customer (Notes)
- Phone (Phone)
- Plan (Select: Lunch, Dinner, Both)
- Month (Date)
- Amount (Amount)
- Paid (Checkbox)
Six columns, almost no typing, and a filter on "Paid is unchecked" shows you exactly who to call.
The takeaway
The trick to a good Excel sheet on mobile is not cramming a desktop spreadsheet onto a small screen. It is fewer columns, the right column types, form-based entry and filters. Set your table up that way once, and recording data on the go becomes a few taps instead of a chore. Not sure which app to use? See our comparison of free Excel apps for Android and iPhone.