For our proposal, the wizard looks to the left of the selected cell until it finds a text. In our example, the labels are taken from column A. It should be noted that the label of the respective cell is automatically transferred from the Excel file, if this is arranged logically. If desired, make changes to the appearance and format of the element here. This now shows the cell from your Excel document. (2) After a few seconds, a first preview of your element will be displayed. The app should preferably contain input cells and some calculated cells (results). If you're converting complex calculations with many cells into an app, be extra careful not to forget a cell at this step. You have shown the App Creator what input and result cells you want in your app. Check the selection in the preview. If you already want to change something about the individual elements added here, move the mouse over the element, open the editor, and make the element-specific changes.To do so move the mouse over the element and click the pencil icon. You can change the automatically set captions in the element's editor. Just look at the preview on the left, when selecting the cells from your data source. Note that we automatically add captions to the cells, so it is not necessary to add the cells containing the value itself and the cell containing the description of it. Select the cell you want to operate and see in your app from your spreadsheet.Now select the cells from your Excel that you want to see/control in the app. The logic of your Excel is completely preserved, as you will do nothing but use the cells in your Excel file with the app. It is sufficient to focus on relevant inputs and outputs. It is not necessary to add all cells from Excel just because they are dealing with the calculation. What you do in the "Select cells" step is to specify which cells of your Excel you want to use and see in the app. Think of the app as a new front-end or mobile user interface for your Excel. Step 2: Select relevant input and output cells For details, see the article "What happens with my data?". For this reason, Excel files that are (optionally) hosted by us are stored protected from third parties in the Microsoft Azure West Europe Cloud. Of course, you can also start directly with your own Excel calculation.ĭata security is our highest priority.
All files can be found below the data selection box where you select your data source (first step of the app creation process).
Feel free to use them to train your skills. We prepared some sample files (like the calculator in this tutorial).
The data source (file) can come from the PC as well as a third party online storage - for example, an Excel in your Dropbox, your OneDrive / SharePoint Online, or a Google Sheet from your Google account.įor detailed information about which data sources you can use and where your file (spreadsheet) can be hosted, see the section: Data Selection. In this example, we want to turn a Calculation that we currently do with Excel into an app. Your app is based on data from your Excel file, Google Sheet, or third-party systems such as Salesforce, Microsoft Dynamics CRM, and many more. Start the App Creator by clicking on the "Create your first app now" button on our home page Alternatively, use this URL to go directly to the App Creator and start the free build process: !/apps/wizard/data We enable automated app creation from Excel or business systems with a cloud-based tool, which works without any programming knowledge of the user.Īpp creation takes place in the web browser. Use Open as App to mobilize existing data sources, such as your Excel files or Google Sheets. It is a very simple example, which is dedicated to giving you a "quick start". Thus, four variables are calculated for the input number - just like in the Excel spreadsheet that serves as our source file. The app created in this tutorial will consist of one input field and four results. Launch the free app creator by clicking on the "Create Your First App" button on our home page.
How to build a calculation app for iOS, Android, and Windows in just a few minutes? Watch and learn in this tutorial:Īpp creation takes place in the web browser.
Of course, the logic from the Spreadsheet remains in the app and can be extended with additional functions. These can be simple calculators or complex offer calculations that you have (so far) done with Excel or Google Sheets. With the Open as App Wizard, you'll be able to turn the mass of calculations in your business into native apps. In this tutorial, you'll learn how to turn a simple Excel spreadsheet into an app.