Automatically Generating Dynamic Web Pages from Excel Data.

[sozu]

I'm in search of a script or program that can automatically populate multiple .PHP or .HTML pages using data from an Excel spreadsheet. I have an extensive database from the Yellow Pages, organized by city-wise businesses. For instance, in Las Vegas, there are more than 1 million businesses. My Excel sheet contains information such as the business name, address, city, phone number, fax, email, and website.

My objective is to incorporate this data into individual pages based on the information in my Excel sheet. I also intend to dynamically generate page titles and descriptions from the Excel database. I plan to use the business name from the Excel sheet as a variable and insert it into the page title and content multiple times.

Is there a WordPress plugin available that serves this purpose, enabling the creation of a multitude of pages from an Excel sheet? Alternatively, should I consider using Laravel or a custom PHP program for this task?

 

[jamie3000]

If it were me I'd probably copy it into a mysql database table and then look at wordpress plugins to make the pages you want.

You could probably save it as a CSV then just use a mysql client to load it in if it's a simple spreadsheet.

There are a few mass page tools on the marketplace here, might be a good place to start.

 

[TMONEX]

I'm in search of a script or program that can automatically populate multiple .PHP or .HTML pages using data from an Excel spreadsheet. I have an extensive database from the Yellow Pages, organized by city-wise businesses. For instance, in Las Vegas, there are more than 1 million businesses. My Excel sheet contains information such as the business name, address, city, phone number, fax, email, and website.

My objective is to incorporate this data into individual pages based on the information in my Excel sheet. I also intend to dynamically generate page titles and descriptions from the Excel database. I plan to use the business name from the Excel sheet as a variable and insert it into the page title and content multiple times.

Is there a WordPress plugin available that serves this purpose, enabling the creation of a multitude of pages from an Excel sheet? Alternatively, should I consider using Laravel or a custom PHP program for this task?

If you post in WTB section it will be easier to respond to you with a solution.

 

[CloakBro]

You could achieve this with Python to create individual (static) pages for each row of your excel file. Or use PHP to read slug of the url and get the data from the row of the excel file and display it dynamically.