Create your first app
blog-header.svg

Blog

Get ideas, learn from industry best practices and get updates on new features.

How to turn Excel calculations into apps

by Daniel, on April 18, 2019 | Topics:Best Practice

If you are interested in a simple way to turn your business spreadsheets into accessible, easy-to-use and actually portable tools, look no further! In just 5 simple steps, Open as App enables you to create your own apps based on the spreadsheets you use in your daily business life.

Step 1: Select your data source

Data sources Open as App

You can either work with data directly from your hard drive or you can connect a web service of your choice. We are continuously expanding our list of supported services.

We deeply care for the security of your data. If you host a spreadsheet with us, your data will be stored within the Microsoft Azure Western Europe Cloud. 


Step 2: Select a template for your app

App Type

Based on the data in your spreadsheet, Open as App automatically suggests an app type that might be suiting for you. Simply select the app type that fits best for your purpose. For this example, we are building a calculation app, thus choosing the app type "Calculation".


Step 3: Select all relevant input and output cells

Cell selection for calculator

In this step, you are going to select all cells that are relevant for your calculations. Every cell you select in this step will be represented in your app. Be sure to select all relevant cells for your calculations.
To aid you in selecting the right cells, the phone on the left side dynamically displays all cells you have selected, just like they will be shown in the finished app later.


Step 4: Choose a design for your app

Design theme select

Now is the time to make your data look good. You can choose from one of our preset themes and customize them later on to make them fit into your corporate design.


Step 5: Create your app

Bildschirmfoto 2019-04-16 um 12.03.01

All that is now left to do is to give your app a name, filling in the description (for others to better understand what your app does) and pressing the "Create my app" button.

App ready to use

You are all set! Invite others to use your app, customize it even further or open it in our web client and enjoy a new level of data mobility!

 

For a deep dive, please head over to our help center. In this support article, you will get deeper insights into what is possible and what has to be done in every step.

Let's build an app!

 

Please note:
To get the best experience while using Open as App, please make sure that your spreadsheet does not rely on merged cells and/or macros. As iOS does not allow for apps to reload data, macros can't be used and have been blocked.

Comments

Open as App

Create Apps for your team and your customers based on the data of your daily work. Automatically, always up-to-date, instantly available.

GERMANY/Munich
Open as App @WeWork
Oskar-von-Miller-Ring 20
80333 Munich
Phone +49 (89) 38012952-1
Email contact@openasapp.net 

GERMANY/Hamburg
Open as App @WeWork
Axel-Springer-Platz 3
20355 Hamburg

USA
Open as App
1355 Market Street, Runway
San Francisco, CA 94103

Support & Help

Browse our help center

Get in touch with our team
support@openasapp.com

Useful links

Subscribe to our updates

© 2019 Open as App - Imprint - Privacy - Terms of Service