Here's what I'd like to do. I would like to take data from a
microsoft excel spreadsheet and have it automatically get plugged into
my website template and create a new webpage. I want each row of
data/information on the spreadsheet to appear on a new webpage on my
website. 1 row of data = 1 new webpage.
I want each webpage it creates to have my website's template/colors,
borders, navigation links, etc.
So basically a spreadsheet row might have the following information:
Column A, Row 1: Dallas Use Cars, 200 Main St, Dallas TX, 90276
Column B, Row 1: 905-548-5588
Column C, Row 1:
www.dallasusedcars.com
Column D: Row 1: Used Cars Sales
I want a program that can automatically take thousands of these rows
and create webpages with that information on them. I will have much
more than 3 or 4 cells of data. I want to be able to specify where
the particular cell will go on the webpage (ie. Colum D cells creat
Title Tags).
So basically if I have 2000 rows of information, this program would
create 2000 unique webpages. Plugging in the data from specified
cells into a predesigned webpage template and creating a webpage.
I'm not too familar with MySQL or online databases, which is where I
suspect you may go with this. Ideally I'd be just fine if I could
create the webpages all locally on my PC, and simply upload them to my
webhost and be done with it. I'm not looking to manage this
information or update it every month, etc. Of course some sort of
sitemap or directory page would need to be created in the process, so
each page could be found.
Any thoughts anyone?
I am definately not a programmer, so I'd be happy to buy a software
program if it could do this - assuming its not too expensive.