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

Angelika Methner

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

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

Borislav Kiprin

20 innovative Tools for Excel & Google Sheets in 2022

Innovative Tools Excel

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

Angelika Methner

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

self service app

Angelika Methner

4YFN Barcelona – Hotspot for Innovation & Impact

MWC und 4YFN Barcelona

Angelika Methner

Open as App appoints Michael Stoelwinder as new CEO

Michael_Stoelwinder_OpenasApp

Angelika Methner

New Pricing Plans in 2021

pricing

Angelika Methner

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

successful no-code tools

Angelika Methner

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

Angelika Methner

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

Angelika Methner

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

Angelika Methner

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

Angelika Methner

How to Build Manufacturing Solutions With 4 No-Code Apps

man holding gray steel frame

Angelika Methner

The Top Custom Mobile App Design Tips

person writing on white paper

Borislav Kiprin

Excel Tricks to Create Professional Apps for Businesses

two person standing on gray tile paving

Angelika Methner

Shadow IT and Its Damaging Consequences for Companies

shadow it

Angelika Methner

How to Boost Your Consulting Business with Apps

consulting business

Let’s keep in touch!

Newsletter-Girl
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

Projektmanagement-Checklist

Alexandra Müller

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

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

11 good reasons for your business to have an app

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

Alexandra Müller

Construction site safety checklist – how an app can improve safety

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

Alexandra Müller

How much does it cost to develop an app?

Digitales Bautagebuch mit Open as App erstellen

Alexandra Müller

How to create your digital construction daily log

CRM-Systeme mit Excel erstellen

Alexandra Müller

Creating CRM systems with Excel