How can I create a database of 1000 pages quickly

Avatar
  • updated
  • Answered

I'm trying to publish a database website, like IMDb or Metacritic. I have an Excel spreadsheet with field names "GameTitle", "Year", "Genre", "Score". There are many more columns. I then have a thousand records (e.g. "Witcher", "2015", "RPG", "80", etc.). 


Similar to IMDb/Metacritic, I'll need one "game page" template so that every game page is the same format, with the GameTitle as page heading and with all the related information about the title below. So, 1000 pages in the same template.


But all the data (1000 records * 12+ columns) is already on my Excel spreadsheet. What is the fastest way to get my database published? I'm hoping I can either get a plugin or another tool to help:

  1. Get a customisable template. If I edit the template later (e.g. change heading font), all 1000 pages get updated.
  2. Import the data quickly from my database to the page.
  3. Ideally, but not necessarily: if I update/delete a game record from the database, the game page should update/delete too. If I add a new game record, a new game page should appear. 

Had no luck browsing WP plugins, YouTube, and Google. Surely, what I seek already exists out there and I just need signposting?! Any advice and recommendations are appreciated. Thank you. 

Pinned replies
Avatar
Alyssa K
  • Answer
  • Answered

Hello, 

Thank you for your question about website design. Unfortunately, there is no single tool I'm aware of that will allow you to accomplish all of those tasks. The first step will likely involve importing your data into a MySQL database that can be used by a platform such as WordPress. Once that is done, you can customize page elements and themes in the WordPress dashboard to make the site look how you'd prefer. Since WordPress stores page data in the MySQL database, deleting an entry from the database will delete the page from the site. I recommend looking into plugins that can import Excel data into a WordPress plugin to get started. 

Best Regards, 

Alyssa K.

Avatar
Alyssa K
  • Answer
  • Answered

Hello, 

Thank you for your question about website design. Unfortunately, there is no single tool I'm aware of that will allow you to accomplish all of those tasks. The first step will likely involve importing your data into a MySQL database that can be used by a platform such as WordPress. Once that is done, you can customize page elements and themes in the WordPress dashboard to make the site look how you'd prefer. Since WordPress stores page data in the MySQL database, deleting an entry from the database will delete the page from the site. I recommend looking into plugins that can import Excel data into a WordPress plugin to get started. 

Best Regards, 

Alyssa K.