WooCommerce – Display Products Spreadsheet on the Frontend

woocommerce display products spreadshee on the frontend

If you’re a WP Sheet Editor user, you may have noticed the thousands of advantages it gives you by letting you completely manage your WooCommerce products from a spreadsheet. Now we want to join the team to make your life easier and show you how to display the products spreadsheet on the frontend.

You may want to do this in order to let your team manage your WooCommerce products from the frontend, or maybe because you’re a programmer and you’ve been asked to create a WooCommerce store in which users won’t have to get lost in wp-admin, but go straight to the job to modify the products.

Therefore, if you don’t have the products spreadsheet yet, you can get it here. Once you install and activate it, you need to install the WP Frontend Admin plugin, which allows you to see/edit any page on the frontend with just one click.

You can get it here:

Try plugin for free

You can try the premium plugin on your website for free for 7 days.


Once installed and activated, you need to follow these really simple steps.

1- Open the products spreadsheet

For this you need to go to Sheet Editor > Edit products. This will open the products spreadsheet.

Normally, it will display the spreadsheet in full screen mode. So you need to click on Exit to disable the full screen mode.

Now you need to click on View on the frontend in order to open the spreadsheet on the frontend.

2- Configure and publish the spreadsheet on the frontend

Our plugin will create a new page for you to see and edit the products spreadsheet on the frontend. However, you need to first add the title, slug, template and menu for that page.

Something really important is that you can hide all unnecessary elements. For this, click on Hide element and then click on the elements you want to hide. For example, you may hide the WP Sheet Editor logo, Screen Options, the Full screen mode is active message, etc.

Once you’ve finished configuring the page’s quick settings, you can publish the page by clicking on Save to publish the page.

4- See the products spreadsheet on the frontend

Once published, the page will require your users to log in in order to let them see and use the products spreadsheet on the frontend.

Now your users will be able to see and manage the products spreadsheet from the frontend.

How simple!

It’s that simple to see and edit the products spreadsheet on the frontend.

You can get the plugin here:

Try plugin for free

You can try the premium plugin on your website for free for 7 days.


important questions

1- Can I use other plugins to create web apps?

Yes. You can display any admin page on the frontend, and it works with all WordPress plugins.

2- Is the plugin compatible with page builders?

Yes. You can use it with other page builders such as Elementor, Visual Composer, Gutenberg, Divi, Beaver Builder, WP Page Builder, Page Builder by SiteOrigin, Oxygen, Live Composer, Brizy, and many others to create great sites.

3- What if I cannot see this page on the frontend after login?

If you can not view the page after log in, you need to use one of these roles: administrator, editor, author, contributor, shop_manager, wpseo_manager, wpseo_editor, shop_accountant, shop_worker, shop_vendor, lp_teacher, give_manager, give_accountant, give_worker, employer.

In case you don’t want to assign one of these roles, you can create a new user role with the User Role Editor plugin. This new user role needs the edit_posts capability.

4- How many elements can I hide?

You can hide all elements you want. It all depends on what you need.

Just be careful not to hide elements you might need in the future.

5- What if I want to revert the elements I’ve hidden?

You can revert that. Just click on Revert below the Hide element button.

6- Is this plugin compatible with other Sheet Editor spreadsheets?

Yes. You can display all Sheet Editor spreadsheets on the frontend.

Here are some examples:

  • WooCommerce Products Spreadsheet
  • Easy Digital Downloads Spreadsheet
  • WooCommerce Coupons Spreadsheet
  • Posts, Pages and Custom Post Types Spreadsheet
  • WordPress Users Spreadsheet
  • Categories, Tags, Product Attributes, Taxonomies Spreadsheet
  • Frontend Spreadsheets for Apps
  • Events Spreadsheets
  • WooCommerce Customers Spreadsheet

Leave a Reply

Your email address will not be published. Required fields are marked *