Support » Fixing WordPress » Populate webpage from excel

  • Hi,

    We have a list of all our plants in excel.

    Right now we are looking for a solution to show that content on our webpage.

    The excel file has certain columns like name, description, usage, …

    So basically we want to generate a webpage per row of content in excel.

    every row in excel is all the content of 1 plant.

    What is the most efficient way to do this?

    Kind regards,

    Robby

Viewing 2 replies - 1 through 2 (of 2 total)
  • I think the most efficient way to do this would be to move the Excel sheet content into a Google Sheet (and hereafter manage the data on Google Sheets), and then use the Google Sheets API to dynamically create individual pages for each row of content.

    I’m not sure how familiar you may be with PHP/HTML but what I have mentioned above would require custom development.

    Reading content from Google Sheets API: https://developers.google.com/sheets/api/samples/reading

    Moderator bcworkz

    (@bcworkz)

    Reading file content in order to display its content on a web page isn’t very performative. Serving data from a database is much faster and the entire point of using a CMS system like WordPress. There are plugins that will import Excel data into a database, but then the problem becomes how is the data then managed?

    While you could periodically re-import Excel data if it’s not updated all that often, ideally the data would be managed directly in the database through some sort of user interface, much like blog posts are currently managed in WP. While it’s always worth doing a plugin search for existing solutions, you would likely need such a scheme custom developed.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Populate webpage from excel’ is closed to new replies.