How can I create a database of 1000 pages quickly
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:
- Get a customisable template. If I edit the template later (e.g. change heading font), all 1000 pages get updated.
- Import the data quickly from my database to the page.
- 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.