There are a number of advanced search plugins you could use. Most expect search criteria to exist as post meta. The trouble will be in importing spreadsheet data so that post meta is populated. There are spreadsheet import plugins, but I’m unsure if they’ll work that way.
If the data exists in its own table, it can still be searchable, but the search functionality may need to be custom developed. This would actually be more efficient than searching post meta.
If the data will still be maintained in a spreadsheet, it’ll need to be repeatedly imported into the site, replacing old data. It’d be better if the data could be maintained directly in the DB through a WP user interface.
I have sheet editor pro, wonder if this could be usable?
Do you have instructions for this sort of thing?
Thanks
Sorry, no. I’m not familiar with that plugin. Try looking at their website for links to documentation. A good plugin will have a support section where you can ask for further guidance.
If that is the plugin I think it is, isn’t it for creating embedded spreadsheet-like tables on your site? I don’t see how that will help you get data in an external file onto your website or let users search. But then I’ve never used it, so I may be off base.
