I have an Excel database full of statistical data which I feel would be useful on a website – the data contains standardised measurements, dimensions, weights, prices, and much more – for a certain type of household item.
Due to the ease of use, I’d like to use WordPress to build my website.
Previously I have had a project like for TV Wall Brackets of all things, whereby I have built SOME of the site in WordPress, but when it comes to the “data” pages – I have then imported this data into a separate PHPMyAdmin database, and then used 2/3 dynamic standalone PHP pages (themed to match the WP style) to show off the content, populated straight from the database – making 500 or so pages with nice page re-writes and dynamic URLs etc.
Whilst I could a plugin like WP All Import in order to put this Excel data into WordPress on separate pages – I’m not looking to create a 500+ page website. Ideally, I want to know if there is a Plugin out there that can do this in WordPress?
ie: A page is created in WordPress, containing Shortcodes in Page Title, Custom Fields, Tags, Content Area – but where the data actually gets populated from a database?!
Thanks for your help on this.