Spreadsheet search facility

  • Andyjay2012

    (@andyjay2012)


    2 weeks, 3 days ago

    Hi all
    I’m looking for a solution whereby I can upload a single spreadsheet containing eight columns and be able to search and display the results using a search facility that can search on a ‘first’ word, contain conditional logical operators (AND, OR, NOT) option and a second ‘optional’ word search.
    Is this something a plugin can acheive or does it require hand coding?
    Many thanks in adance
    Andy

Viewing 2 replies - 1 through 2 (of 2 total)
  • Marta Fernandez

    (@marferblanco)

    2 weeks, 3 days ago

    Hello @andyjay2012

    Yes, this can be achieved with a plugin, no need to build everything from scratch.

    You have a few options depending on complexity:

    • Simple solution: Import your spreadsheet (CSV) into WordPress using a plugin like WP All Import, then display/search it with a table plugin like TablePress + its search/filter extensions.
    • More advanced search (AND / OR / NOT): Use a plugin like Search & Filter Pro or FacetWP. These allow conditional logic and more flexible queries once your data is imported as custom posts or a custom database.
    • Best approach (recommended):
      1. Import your spreadsheet as a custom post type (each row = one entry)
      2. Store columns as custom fields
      3. Use a filtering/search plugin (FacetWP or similar)

    No custom coding is strictly required unless you need very specific UI or performance optimization.

    Thread Starter Andyjay2012

    (@andyjay2012)

    2 weeks, 3 days ago

    Thank you Marta Fernandez

    Great response and I will look into your suggestion and get back.
    Thanks Again
    Andy

Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

Tags