Excel to WordPress database

  • theod44

    (@theod44)


    6 years, 5 months ago

    Howdy developers,

    My company store product information on Excel sheets. I’m researching for a way to make these information available on the website. The products need to be searchable. Is this feasible? Would very much appreciate some pointers on how I can go about doing this.

    Thanks
    Theo.

    • This topic was modified 6 years, 5 months ago by theod44.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Joy

    (@joyously)

    6 years, 5 months ago

    There are several plugins for this: https://ww.wp.xz.cn/plugins/search/excel/

    Thread Starter theod44

    (@theod44)

    6 years, 5 months ago

    Thanks for the reply!

    What I need is more than presenting an Excel file as a post. I’m looking to create a small database with the existing hundreds Excel files so that I can manipulate and search the data.

    Thanks,
    Theo

    Joy

    (@joyously)

    6 years, 5 months ago

    Look again. There are plugins to go from CSV to WooCommerce and back. There are plugins to edit in place. There are plugins to export to CSV, edit and re-import.

    If you want your own free-form table of product data, that needs a different search keyword. Are you trying to merge your hundreds of files? Is there any standard format to these files? What would be the source of truth after putting it into a database? (the files or the database?) Are you trying to sell these products from your site?

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

The topic ‘Excel to WordPress database’ is closed to new replies.