How to turn Excel calculations into apps

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.

excel in app

Damian Roller

Best Practice

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

Step 1: Select your data source

Step 1: Select your data source

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

Step 2: Select a template for your app

Based on the data in your spreadsheet, Open as App automatically suggests an app type that might be suited 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

Step 3: Select all relevant input and output cells

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

Step 4: Choose a design for your app

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

Step 5: Create your app

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 of the process in order to turn your Excel calculations into apps.

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.

Category

App App Apps Best Practice Case Studies Events Features Guide Guides Press Uncategorized Webinars

Popular posts

Alexandra Müller

How to optimize your workflow analysis with a smart app 

workflow analysis

Alexandra Müller

Creating digital signatures: All information at a glance

digital signature

Alexandra Müller

Conducting an energy audit: How a smart app can help you

energy audit with app

Alexandra Müller

How can I create my own iPhone app without coding?

creating an iPhone app

Borislav Kiprin

20 innovative Tools for Excel & Google Sheets in 2023

Innovative Tools Excel

Alexandra Müller

Survey tools: The 6 best alternatives to Google Surveys

survey app

Alexandra Müller

Factory acceptance test via app – what you need to know

Factory Acceptance Test per App

Alexandra Müller

Mandatory recording of working hours – how apps can help with the implementation

recording of working hours with apps

Alexandra Müller

How to optimize your manufacturing process plan with apps

Manufacturing process planning with apps

Alexandra Müller

Project management: Why you can’t go without a checklist

Projektmanagement-Checklist

Alexandra Müller

11 good reasons for your business to have an app

Young urban professional man using smart phone in office building indoors. Businessman holding mobile smartphone using app texting sms message wearing suit jacket and bag.

Alexandra Müller

Construction site safety checklist – how an app can improve safety

Checkliste für Baustellensicherheit – mit einer smarten App zu mehr Sicherheit

Alexandra Müller

How much does it cost to develop an app?

Wie hoch sind die Kosten für die Entwicklung einer App?

Alexandra Müller

How to create your digital construction daily log

Digitales Bautagebuch mit Open as App erstellen

Alexandra Müller

Creating CRM systems with Excel

CRM-Systeme mit Excel erstellen

Alexandra Müller

How to make money with no-code apps

make money with no-code apps

Alexandra Müller

The 8 best app makers

Mit einem App-Baukasten einfach eine App selbst erstellen

Alexandra Müller

How can I create an app?

App erstellen - so funktioniert es

Alexandra Müller

Embedding an iframe – what you need to know

Embedding an iframe - step by step

Borislav Kiprin

Create an App With Google Sheets for Your Business

Create an app with Google Sheets

Manfred Streit

How to Turn an Excel Spreadsheet Into an App

Excel spreadsheet into an app

Manfred Streit

The Basic Guide to No-Code Apps and Platforms

basic guide no-code apps

Damian Roller

Self-Service Apps based on Spreadsheets – Three Strategies for Beginners

self service app

Damian Roller

4YFN Barcelona – Hotspot for Innovation & Impact

MWC und 4YFN Barcelona

Damian Roller

Open as App appoints Michael Stoelwinder as new CEO

Michael_Stoelwinder_OpenasApp

Damian Roller

New Pricing Plans in 2021

pricing

Damian Roller

No-Code Tools Comparison: Open as App and Glide Apps

successful no-code tools

Damian Roller

How to boost your workflow automation with no-code apps

workflow-automation-no-code-apps

Borislav Kiprin

Custom mobile app development in Microsoft 365

Custom mobile app development

Damian Roller

How to Select between BI and Excel Data Analysis [Tableau Alternative]

Tableau Alternative

Borislav Kiprin

Enhancing App Security and Data Protection: No-Code Apps

app security

Damian Roller

Bread baking per app – enjoy great home-made bread every day

home made bread

Borislav Kiprin

How to Drive Digital Innovation without the IT Department

digital innovation

Borislav Kiprin

How a Multi-Devices KPI Report App Can Improve Performance

KPI report App

Damian Roller

Best 8 No-Code Apps to Boost Real Estate Agent Performance

Boost real estate agent performance

Borislav Kiprin

Open as App adds the power of non-technical citizen developers to Microsoft 365

microsoft

Let’s keep in touch!

Skip form
Form skipped
Newsletter-Girl
workflow analysis

Alexandra Müller

How to optimize your workflow analysis with a smart app 

digital signature

Alexandra Müller

Creating digital signatures: All information at a glance

energy audit with app

Alexandra Müller

Conducting an energy audit: How a smart app can help you

creating an iPhone app

Alexandra Müller

How can I create my own iPhone app without coding?

Innovative Tools Excel

Borislav Kiprin

20 innovative Tools for Excel & Google Sheets in 2023

survey app

Alexandra Müller

Survey tools: The 6 best alternatives to Google Surveys

Factory Acceptance Test per App

Alexandra Müller

Factory acceptance test via app – what you need to know

recording of working hours with apps

Alexandra Müller

Mandatory recording of working hours – how apps can help with the implementation

Manufacturing process planning with apps

Alexandra Müller

How to optimize your manufacturing process plan with apps