The choice component needs a list of items for the choices - and a location where the choice will be written to. The best way to do this is to add a choice component and make it read from the Categories table. We really don’t want to type a category each time - it would be much better if we could just pick one from a list. But we have a set number of specific categories that we want to use. Glide has added entry fields on this screen to match the columns in our table, and it’s almost perfect! Let’s add an image picker component and link the component to the image column in our table.īefore submitting this expense, we want to be able to categorize it.Ĭurrently, we have a field that we are just typing any value we want into. We’ll configure this list to show the category, the date, and the amount we spent, and then sort the list to show the newest items first Because this is an app to track our expenses over time - let's use the calendar layout. We can choose different styles for this list. Glide has automatically created a list for us based on the data in our table. We don’t need to use it in our project, for now, so we’ll remove the Tab that Glide created for it. The ‘Categories’ table is there to help us create reports. Glide creates a basic App as a starting point and if we look in the Data Editor, we can see and edit our 2x Tables. We'll start a new project in Glide and upload this Excel file as our data source. This is great, but logging and viewing these in an app would be much more fun. We already have an Excel file with some transactions.

It's a win-win for effective expense management. You retain all the powerful tracking capabilities of Excel but gain the accessibility and convenience of a mobile app. By turning your Excel spreadsheet into an app with Glide, you transform a potentially cumbersome process into a simplified, user-friendly experience. In this guide, we're going to build a simple app to track our daily expenses. You can also share your app with team members or family, so everyone involved can contribute to and access the expense data. Every time you enter data into your app, it's automatically updated in your Excel sheet in real time.

Sync and Go: Once you're satisfied with your app, all that's left to do is to sync it with your spreadsheet. Glide's intuitive drag-and-drop functionality makes this process straightforward.Ĥ. For instance, you can add a form for inputting new expenses, create categories for better organization, or include visual elements like charts and graphs for a more visual representation of your expenses. Add and Modify Features: Depending on your expense tracking needs, you can add various features to your app. You can choose colors, fonts, and layouts that match your brand or personal preference.ģ. Glide's user-friendly interface allows you to personalize your app's look and feel without any coding or design skills. Customize Your App: Next, you'll customize your app. Glide will automatically interpret your spreadsheet data and create a basic app layout.Ģ. Once you've uploaded your Excel file to Google Sheets, you can easily import it into Glide. Connect Your Spreadsheet: The first step is connecting your existing Excel spreadsheet to Glide. This level of convenience is possible with Glide. Imagine being able to enter expenses directly into a beautifully designed, intuitive app right from your mobile device, and then having those expenses automatically synced to your Excel spreadsheet. The good news is that you can simplify and streamline this process by converting your Excel expense tracker into a user-friendly app with Glide.

However, working with Excel spreadsheets, especially complex ones, can often be daunting for those not entirely comfortable with the software. It allows you to input data systematically, apply formulas to calculate totals, and analyze data through graphs or pivot tables. Turning your Excel Expense Tracker Into an App Without Codeįor many businesses and individuals, Excel has been a go-to tool for tracking expenses due to its powerful computational and organization capabilities.

Excel budget expense tracker