linking excel to my website

[quasar]

Good day everyone,

I have this excel files with many data..now i want to make a website that will make use of these excel files and then make graphs out of it...

Any idea on how to make it? I mean i need a steps to follow...

Thanks a lot..

[LostMyMap]

While it is possible to use a spreadsheet as a data source for a web site, you will be a lot happier in the long run if you move the data to a database.

I guess I would really need to know exactly how your web site is going to make use of the data. What do you want it to do?

[quasar]

thanks for that.. so i need to make a database out of my excel files..in making the database what are the things that i should do? what are the things that i should learn?

I want the website to give visual information to the visitors (line supervisors and managers) regarding their productivity, absenteeism, quality issues and a many more.

thanks

[LostMyMap]

Originally Posted by quasar

I want the website to give visual information to the visitors (line supervisors and managers) regarding their productivity, absenteeism, quality issues and a many more.

thanks

From that I gather that you want the visual information to be live, not just a bunch of static images or html. In other words, when you update the data, you want the users to see that change immediately on the site? That is where using a database comes in.

Do you have web development experience? These are the kinds of projects I do, but they can get rather complicated when you really go through everything that needs to be there.

If this is for internal users, could you just put a copy of the spreadsheet on a network file folder and share it to everyone?

Or another question, does your company have Sharepoint in use there?

[ellie]

You can't use google docs - Spreadsheets/Charts?

[quasar]

thanks to those who replied with my post...

i think i need to make a database out of the excel files. can you tell me how to do it?

web development??? i am starting to learn about PHP and HTML..

[Lil Chris]

Databases are a whole other beast from web development. You will probably want to contract that work out to a professional.

An easier way would be to copy your spreadshhets over into google docs, then give read only access to those you wish to see the spreadsheet. You can make it so you are the only one who makes changes, yet allow others to see your information, without being able to make any changes. It's not as clean and incorporated into your site, but it's free...

[quasar]

but i really need to develop a database..anyone here can give me an idea on how to do it? What are the necessary steps that i should do?

Thanks

[LostMyMap]

Originally Posted by quasar

but i really need to develop a database..anyone here can give me an idea on how to do it? What are the necessary steps that i should do?

Thanks

I still want to know some things about your environment. Is this something that is only to be visible within a business? As opposed to being on the Internet. Sounds like it might be. Does this organization have an internal network? Is it Windows based? If so, the quickest, easiest thing to do is to put a copy of the spreadsheet in a shared folder.

If you are pretty sure this needs to be in a database or web site, then the next question is, how important is it for you to get this done quickly, versus you taking time to learn something new? I'm all in favor of you being able to learn new things, but if you need to get this done quickly, you are probably better off bringing in someone who can do it for you.

If this project is just something that a few people will be using, and you want to learn something new, and you can get your hands on a copy of Microsoft Access, and you have time to learn something as you get this project done, that would be a possible good starting point for you. I have known countless people over the years that are basically non-technical but have managed to learn enough to build a simple Access application with some nice user forms and reports. There are tons of learning materials on line, and you can get pretty darned far without ever writing a line of code. It can be shared and used in a corporate environment by your other users, as long as you don't get too complex.

The reason I know this is because those homemade Access databases often take on a life of their own, get bigger and more complex, then they call me in to take the application to the next level.

There are lots of ways you could go with this, but I'd need to see answers to the questions to know what to recommend next.

[Michael Chui]

Actually, try this:
Socrata | Making Data Social

You can import Excel files, and you can make charts.

[quasar]

@ LostMyMap,

I want it to be visible only within the business.. We do have a network it is windows based. My target to finish the database would be September of 2011 but this is just my target it can be move. I want to learn how to do it..

Can you give me some links on readings on how to do this?

Thanks a lot..

@Michael Chui...

I will check the link..Thanks