Home – New › Forums › Tech talk › Convert Excel to web form?
- This topic is empty.
-
AuthorPosts
-
November 24, 2011 at 5:33 am #975968Up::0
Does anyone know if there’s a tool that allows you to convert an excel spreadsheet with formulas etc, into a web form that people can interact with on a website?
Preferably free if possible hehe
November 24, 2011 at 10:15 am #1077798November 24, 2011 at 11:32 am #1077799Up::0Nah i mean I want to take a excel spreadsheet, and have it so that it’s a website page, not an excel spreadsheet that’s hosted online.
November 24, 2011 at 12:38 pm #1077800Up::0What sort of interaction are you talking about?
Do you want the formulas to dynamically update.
November 25, 2011 at 2:33 am #1077801Up::0you can convert excel into a single webpage through excel…
Are you using Excel after 2007?
The options are in the top left and save as other… Look for like single web page, and done…
If you get stuck let me know.
What are you trying to do anyway? Are you looking for formulas or something like that?
Talk soon,
November 27, 2011 at 9:38 pm #1077802Up::0Yeah I’ve got a spreadsheet that i’d really like to publish as a web page but don’t want to have to re-work everything just so it works online.
November 28, 2011 at 1:37 am #1077803Up::0Syron, post: 98093 wrote:The options are in the top left and save as other… Look for like single web page, and done…If you get stuck let me know.
What are you trying to do anyway? Are you looking for formulas or something like that?
Hey yeah I tried that and the webpage comes out fine which is cool, but yeah I have some formulas where I want someone to enter a value, and it can still respond like a normal spreadsheet. Is that possible?
November 28, 2011 at 1:42 am #1077804Up::0I know with Joomla, you can upload Excel spreadsheets and they can function like that on the site and can be saved and things like that but you might have to convert to either HTML5 or PHP, I mean it isn’t hard but it’ll depend on how many calculations you want to do.
For example: http://www.syron.com.au/webadvertising.html#Calculator
How many calculations have you got to do? Is it like a finance calculation or something like that?
November 28, 2011 at 3:19 am #1077805Up::0I don’t think excel will export the formulas, just the format of the spreadsheet.
If you convert the excel spreadsheet to html, the html will also be a bit messy which will make futures updates more complicated than they need to be.The right way to do it is to create an html table (gasp) and use javascript to update it. Personally I use JQuery to make it simple
The easiest way, I guess, would be to simply create a link to the excel spreadsheet itself, which I’ve seen on a few websites.
I’d offer to help but I saw the dreaded ‘free’ word
However, having literally just done something like this, I can send some example code if you want to figure it out yourself and have access to raw html files in whatever package you’re using.November 28, 2011 at 3:27 am #1077806Up::0Haha yeah it’s just a very simple project I’m doing for a friend of mine. Looking for a quick easy fix.
It’s all good though I found a plugin you can buy for like $30 and it converts it right out of excel.
November 28, 2011 at 3:43 am #1077807October 13, 2013 at 1:00 pm #1077808Up::0Hi There,
Can you post on here the name of the Excel file converter to html that you purchased as it will be interesting to do some research on it for some work that I do for clients. In the past I have not been able to find any converter that converts Excel financial models that are complex in nature to web pages without full blown web development inclussive of dB work in the back end or going down the other path and buying web based budgeting applications.
Cheers and thank you in advance.
Arthur
October 13, 2013 at 11:07 pm #1077809Up::0InsightFocus.com.au, post: 175145 wrote:Hi There,Can you post on here the name of the Excel file converter to html that you purchased as it will be interesting to do some research on it for some work that I do for clients. In the past I have not been able to find any converter that converts Excel financial models that are complex in nature to web pages without full blown web development inclussive of dB work in the back end or going down the other path and buying web based budgeting applications.
Cheers and thank you in advance.
Arthur
I dont know if this is what he used. but this might do the trick.
http://www.spreadsheetconverter.com/Steve
October 14, 2013 at 1:53 pm #1077810August 12, 2016 at 4:12 pm #1077811Up::0If you don’t have a google account, create one.
Upload the Excel file to google docs.
Convert it to a Google Sheets format.
Protect the sheet and add exceptions for cells you want to allow people to change.
From there you can share sheet or embed it into a web page -
AuthorPosts
- You must be logged in to reply to this topic.