How to turn a spreadsheet into a web app in 3 minutes

EducationI’ve mentioned the dangers of spreadsheet misuse on many occasions, and explained why it’s so important to put that spreadsheet data into your database. However, I realized that I’ve never showed you how to turn your spreadsheets into database-driven web apps.

So, we created a video to do just that. The following video explains why you should convert your spreadsheets into web apps, and even shows you how it’s done. You might be surprised to learn just how simple this process is.

Note: This video is best viewed in 720p(HD) resolution at full screen. Click the “gear” icon below the video to change the resolution.

Related Posts:

29 thoughts on “How to turn a spreadsheet into a web app in 3 minutes

  1. I have a spreadsheet that has complex formulas. I don’t think I saw a way your solution can help me.
    Would you take a look and see if I am wrong?

  2. Hi Gordon,

    Thanks for the question. m-Power can actually support every formula you can do in Excel (and more). We’ll contact you directly with more details.

    Thanks!

    1. Would love to know your answer on how to convert excel sheet with formulas to a responsive cross platform desktop and mobile app

  3. I have multiple spreadsheets that track various things or provide reference to other sheets. Each sheet has many tabs so this is a complex setup with many vlookups and formulas. Can you handle references to many sheets? I want end users to update the count of the items for specific items and then also determine the age of items since last update for reporting.

    1. Hi Tim,

      That’s a great question! The short answer is “yes”, you can turn multi-tabbed spreadsheets into web applications, and even reference (or link to) data from different sheets. We will reach out to you via email to answer any additional questions you may have.

      Thanks!

  4. This sounds very interesting. I’m currently writing an app in WP which I’m learning as I go but I know excel inside out.
    The database side would be excellent but how secure would it be if used internationally with personal details on file? I would want various buttons to find data and manipulate the data before it is shown. Each user would need to be able to store their ‘progress’. Plus graphics would be embedded within the app and a pop up intelligent help system will need to be written. How does your software cope with Excel workbooks containing a lot of complex vba? Would the storage side be able to cope with 800,000 users? Could you email me as I have further questions. Thanks.

  5. Hi,

    1. I have two questions, does the tool allow me to use the underlying php which i can then input into a wordpress website?

    2. I want to create a calculator, but i want the inputs fields to reset to zero after every user has used the tool, is that possible?

    Thanks.

  6. Hi there
    I’m creating an Excel spread sheet that I want users to be able to input their daily on and off times.
    the sheet will keep track of hours worked during the day, week and year. There will be multiple inputs available for each day that will all contribute to their own running totals. Inputs will be in time formats and simple text as well as a pay calculator. The spreadsheet is tailor made for our specific work life. Ideally the app must be user friendly to all ages, 18-65.
    Does this sound possible to do.

  7. I have some very expansive excel docs (more like programs than just spreadsheets), and this concept of converting it to a web app so easily is very attractive, as I’d like to offer some of our capabilities to a new client base, but without compromising the core of the programs. I’m very interested to learn more and see how M-Power would perform when there are tens of thousands of reference points that recalculate when certain variables are changed.

  8. I need exactly the same thing and wonder how you can help me to turn my companies excel spreadsheet into application. Please contact me

  9. Hi,

    I have a developed excel workbook that helps my business price up various support options base on ceratin selctions, decisions and background calulations. I want to get this web based so my teams can use it and give near real time pricing to clients.

    Also I need to output the information to a client facing document. This is also in excel or word.

    Can you help

    Gary

  10. I have a spreadsheet I am wanting to market to individuals for a particular line of work, it helps them calculate there time and miles, but needs to be sold and used by only each individual, is this possible.

  11. Hi, i made a spreadsheet for electrical and power engineers on an aspect of engineering. it contains so many tables, six tabs with several referencing from one sheet to the other. i intend making sales of the spreadsheet as it’s proven so useful by those who have used it. how can i turn this into a web application in 3 minutes. kindly reply.

  12. Want to convert Numers / Excel spreadsheet to an iPad app or Web app as in your demo.
    Small operation, 3 people. 30 transactions a day.

    Were is database stored? What platform?

    What is the cost if I develop the app? If I pay you to?

  13. Do you guys offer any solutions to the average consumer? I don’t need this for work use, but for personal. Would love to be able to create my own apps using my skill in excel. M power seems to be the solution I’m looking for but its out of my price range as a one man show.

    Thanks

  14. Hi,

    I have an excel workbook with many tabs, complex formula and VBA macros. The macros are linked to buttons in the workbook. Can this be built into the app?

    Thanks

  15. Dears,
    as many others I would also need customized solution for my spreadsheets. I have built a calculator which is taking data from over 20 tabs. can you please contact me via e-mail
    thanks

  16. Thank you for making this quick and easy to understand.

    My Excel Workbook has 6 spreadshheets, each a tool that is used in a call centre environment, helping with calculations for Annual leave, Long Service calculator, pay etc reducing call times with complex queries, essentially a HR Tool covering several processes on one workbook. Using VBA for specific Microsoft Date picker and DATEDIF function- long complex formulas using over 100 characters

    I can send you an overview and look and feel, I am trying to convert in to a secure app on Android Platform or Web based app. I appreciate the time you have taken to read this and hope this intrigued you enough to help or point me in the right direction

    Your faithfully

    mo.kk@live.co.uk

  17. Hey Gang – much the same challenges as others commenting above, I have an Excel workbook full of formulas and macros that roll up to the summary pages where a user interacts with only a few fields that, in turn, outputs a lot of financial info. Our IT group has attempted a few different quick and dirty things to make this web accessible and interactive, to no avail. This solution sounds helpful and I’d love to see if it would actually work for us.

  18. Hello,
    My excell spreadsheets use excel open solver to solve an optimization problem. Would it be possible to turn it into a web aplication?

    Thank you

  19. Sound is great.See that’s lot things avail,possible and easy but we don’t aware about that when we just get title or listen things that things also avail we are able to find more details only things we needed that is the new things.

    This article is one of the example of them.

    The advantages of this is we can get backup anywhere while it is on live server also crash problem are solved out.

    Nice concept bring with also how do that.

    I appreciated your hard-work.

    Please also if any another cool interesting avail let me know .

    Again thanks for sharing information with us.

  20. Hi,
    I have Excel 97 to 2003 On My Pc
    I want to Convert Excel With Formula Into A Webpage , Where My Customer Can Go And Use This Sheet.
    I Tried Google Docs And Microsoft Cloud Already But I Am Not Satisfied With The Interface As Its Unfriendly To Use On Cell Phone

    Please Show Me An Alternative ..

    Thx

Leave a Reply

Your email address will not be published. Required fields are marked *