Getting started

  1. When you purchased the plugin, you received an email with the download link and license key
  2. If you were using the free version of the plugin before, you need to uninstall the free version now
  3. Now go to your WordPress site (wp-admin) and open the plugins > add new page, and click on Upload
  4. Upload the premium zip
  5. Activate
  6. You will see a screen asking for a license, enter your license key
  7. Done. Now you should see the welcome page where you can set up the plugin and start using it

IMPORTANT: We stopped selling on CodeCanyon in 2017. This information applies to old customers using licenses from CodeCanyon. Customers who purchased after 2017 need to ignore this.

1- If you dont know your license code, please follow these steps to find the license

2- If you see a message saying that “the license could not be activated”. It can be for 2 reasons:

a) The license is valid for one domain. So if you already used the license on one site, you need to deactivate it in the first site to use it in a second site.

b) Our license server is not available, please try again later.

Deactive license in all sites:

How to use the spreadsheet

To create new rows, write the number of rows you want to create and then hit the “Add new” button.

To open the “Search” tool, click “Search” on the toolbar.

It contains fields to look for products by keyword, status, category, attribute, tag, date, product variations, and filters to do advanced searches.

To open this tool, click “Bulk Edit” on the toolbar.

It contains fields for you to search for the products to edit. It also contains the fields you’ll edit and the type of edit you’ll apply.

To locate specific cells in the spreadsheet, just write the word of the cell you want to locate in the “Locate cell” field and hit enter.

If you want to load 500 rows at once in the spreadsheet, then you need to go to advanced settings, and then to advanced.

Write 500 in the “How many posts do you want to display on the spreadsheet?”

Sheet Editor saves products in batches, so if you want to increase the number of products to save in each batch go to advanced settings > advanced > How many posts do you want to save per batch?, and write the number of products to save in each batch.

To reduce the time the plugin waits between batches, set the number in the “How long do you want to wait between batches? (in seconds)” field.

To show date columns as simple texts, you need to go to settings > Show cells as simple text.

To hide columns from the spreadsheet, you need to right click on the column you want to hide and click “Hide column”.

To display hidden columns in the spreadsheet, go to settings > Hide / Display / Sort columns.

Drag the disabled columns to the enabled columns.

To delete a column permanently, go to settings > Hide / Display / Sort columns.

Once there, hit the “X” in the column you want to delete permanently.

If you delete a column by error, you can restore it by clicking “Restore deleted columns”.

To create a new column, go to advanced settings > add columns for custom fields.

Once there, you’ll have to specify the values for the new column: name, key, type.

To edit images as plain text/URLs, you need to go to the cell you want to edit and double click it; it converts into a plain text field when you double click on it.

Then just paste the image URL.

To copy/paste images from one cell to another, just copy from one cell and then paste into another cell using CTRL + V.

To copy from excel, go to the spreadsheet in Excell and copy what you need from a specific cell, row, column, and then go to Sheet Editor and paste the info you’ve copied using CTRL + V.

To edit a product/post URL, go to the “Slug” column, and hit “Enable”.

Then, paste the URL in the “Slug” cell.

To disable the loading of rows on scroll, go to settings > Load more rows on scroll and leave it unchecked.

To copy values between columns, you have two options:

1. Do it on the spreadsheet: Simply select the content from column 1 and then paste it on column 2 using CTRL + V. Finally, click on Save to update the column content.

2. Do it with the Bulk Edit tool: If, for example, you want to add your product titles to the URL Slug, you just need to open the Bulk Edit tool and select these values:

  • What field do you want to edit: URL Slug
  • Select type of edit: Copy from other columns
  • Copy from this column: $post_title$ (Title)
  • Click on Execute now

Of course, this is an example, you decide from which columns and to which columns you’ll copy the content.

To delete everything in one column, you have two options: manual and bulk.

Manually, select the column by clicking the above part of it and then hit “Delete” in your keyboard.

To delete a whole column content, open the “Bulk Edit” tool.

Select the column you’ll edit in the “Field you want to edit” field and select the type of edit you’ll apply: “Clear value”.

To replace words or phrases in an entire column, go to “Bulk Edit” on the toolbar.

Select the column you’ll edit in the “Field you want to edit” field.

Then, select “Replace” as the type of edit you’ll apply.

Finally, write the new value and hit the Run search button.

To set new values on columns, go to the “Bulk Edit” tool.

Select the column you’ll edit. Then, select “Set value” as the type of edit you’ll apply and write the new value.

To prepend or append something to columns or rows, open the “Bulk Edit” tool.

Select the fields you’ll edit and select the type of edit you’ll apply: prepend or append.

Finally, write the value you’ll add and hit “Run Search.”

To disable or enable the fixing of the first 2 columns at the left side of the spreadsheet, go to settings > advanced settings > advanced > Fix first 2 columns at the left side?

Once there, you decide whether to activate it or not by selecting On / Off.

When you have 1000 posts, you might want to open the spreadsheet and start editing from post 200.

For that, go to settings > advanced settings > advanced > Initial rows offset, and enter the number.

If you want to select a different taxonomy separator, go to settings > advanced settings > advanced > Separator for taxonomy terms cells, and enter the separator in the field.

To disable extension offerings, go to settings > advanced settings > advanced > Disable extension offerings?, and select On / Off.

To suspend object cache invalidation, go to settings > advanced settings > advanced > Suspend object cache invalidation?, and select On / Off.

To disable usage stats widget, go to settings > advanced settings > advanced > Disable usage stats widget?, and select On / Off.

To disable cells lazy loading, go to settings > advanced settings > advanced > Disable cells lazy loading?, and select On / Off.

To disable post actions while saving, go to settings > advanced settings > advanced > Disable post actions while saving?, and select On / Off.

To import or export something on the spreadsheet, go to settings > advanced settings > Import / Export.

Once there, select the import options: “Import from file” or “Import from URL”.

Or select the export options: “Copy Data”, “Download Data File” or “Copy Export URL”.

Once you’ve finished, hit “Save changes”.

The default way uses a faster execution method, but it might not work in all the cases.

In such cases, go to “Bulk Edit” and check the “Use slower execution method” before executing the changes.

To add extensions to the plugin, open the “Extensions” tool by clicking “Extensions” on the toolbar.

To change dates in the spreadsheet you need to locate in the “Date” column and change the date using the calendar popup in the cells.

Common errors

If you are getting network errors (messages like “server not available”) when you are saving changes or executing bulk edits, it means your server is overloaded.

Possible solutions:

1- You need to save less posts per batch and increase the time between batches.

The spreadsheet saves the posts in batches, for example, 4 posts every 8 seconds. But if you are using a cheap server, this can overload the server.

So you can reduce the number to 2 posts every 10 seconds. You need to adjust the number of posts per batch and the time until it works.

2- WordPress has a heartbeat API, which pings the server every few seconds to check log in status. This overloads the server.

For example, you open the spreadsheet editor and use it for one hour, heartbeat has made about 100 requests to the server in that hour so when you start saving the server is already busy.

You can disable the heartbeat in our advanced settings (in the spreadsheet page > settings (top toolbar) > advanced settings > advanced).

3- Maybe you were saving and logged out and logged in again in another tab. This would invalidate the security tokens and you won´t be able to continue saving. This rarely happens though.

4- Try to save smaller batches manually

For example, edit 5 posts and save, then edit other posts and save. Don’t wait until you make too many changes to save because it will take longer.

5- Disable the post actions while saving

WP triggers the save_post hook everytime a post is updated in any context. Sometimes other plugins make mistakes and execute their metabox saving logic outside the post editor.

Their mistake may break our saving because we don’t pass their security checks as we’re not in the normal editor.

You can deactivate the “disable post actions while saving” option in the settings page (wp-admin > wp sheet editor > settings > advanced).

WooCommerce Products

You need to use the Add new row tool. When you add new rows to the spreadsheet, you’re in fact adding new products. Therefore, enter the number of new rows you want to add and then click on Add new.

Once created, select the product names, prices, images, etc., in the columns of the spreadsheet.

You can create hundreds of product variations quickly.

Just follow the step in this tutorial: WooCommerce – How to Create Product Variations Faster

This tutorial shows you how to convert hundreds of product variations into main WooCommerce products:

WooCommerce – How to Convert Variations into Products

You can display product variations on the spreadsheet.

Just click on Display variations and the spreadsheet will reload to show you the variations.

Learn how to remove duplicate product variations following the steps in this tutorial:

WooCommerce – How to Remove Duplicate Product Variations

To delete hundreds all product variations, follow the steps in this tutorial:

WooCommerce – Delete all Product Variations Quickly

You can copy variations from one product to 100 products. Learn how following the steps in this tutorial:

WooCommerce – Copy Variations from One Product to 100 Products with a few Clicks

Learn how to convert simple products to variable. Follow the steps in this tutorial:

WooCommerce – How to Convert Simple Products to Variable Products

Follow the steps in the following article to find product variations without images.

WooCommerce – Find Product Variations without Image

You can find products by modification date. Just follow the steps explained in this tutorial:

WooCommerce – How to Find Products Modified a Year Ago

Purchase notes are important. Lean how to add one to hundreds of products by following the steps in this tutorial:

WooCommerce – How to Add a Purchase Note to Products Quickly

Prices are indispensable. You can find all your products missing prices.

Please follow the steps in this tutorial: WooCommerce – How to Find Products Without Prices

You can edit product short descriptions in bulk. Just follow the steps in this tutorial:

WooCommerce – Bulk Edit Short Descriptions Quickly

To edit downloadable files, follow the steps in this tutorial:

WooCommerce – How to Bulk Edit Downloadable Files

To add a message to your product descriptions, just follow the steps in this tutorial:

WooCommerce – Add Message to Product Descriptions Globally

If you want to delete your product photo galleries, follow this tutorial:

WooCommerce – How to Delete Photo Galleries Quickly

You can find and edit products missing SEO title or description.

Just follow this tutorial: WooCommerce – How to Find Products Missing SEO Title or Description

You can convert simple products to variable products.

Follow the steps in this tutorial: WooCommerce – How to Convert Simple Products to Variable Products

You can quickly find products missing download files.

Just follow this tutorial: WooCommerce – Find Downloadable Products Missing Files Quickly

WooCommerce Coupons Spreadsheet

How can I open the Coupons Spreadsheet?

To open the Coupons Spreadsheet, please go to WP Sheet Editor > Edit Coupons.

How can I duplicate my coupons?

You can learn how to duplicate your coupons by following this tutorial:

How to Duplicate WooCommerce Coupons – Create Hundreds of Copies

How can I edit my coupon quantity restrictions?

The following tutorial shows you how to edit your coupon category restrictions:

How to Bulk Edit Coupon Quantity Restrictions – WooCommerce

How can I delete all my coupons?

Please follow this tutorial to learn how to delete your coupons:

How to Delete WooCommerce Coupons Quickly – Thousands at once

How can I bulk edit my coupons discount amounts?

To learn how to bulk edit your coupon discount amounts, please follow this tutorial:

How to Bulk Edit Discount Amounts – WooCommerce Coupons

How can I edit my coupons expiry dates?

Please follow this tutorial to learn how to extend your coupons expiry dates:

How to Extend or Restrict WooCommerce Coupons Expiration Date

How can I disable my coupons?

The following tutorial shows you how to quickly disable your coupons:

How to Disable All WooCommerce Coupons Quickly

How can I delete my unused coupons only?

You can quickly delete all unused coupons. Please follow the steps in this tutorial:

WooCommerce – How to Delete Unused Coupons Quickly

How can I exclude products from my coupons?

You can quickly exclude specific products from your coupons. Just follow the steps in this tutorial:

WooCommerce – How to Exclude Specific Products from All Coupons in Seconds

How can I set minimum amount on hundreds of coupons?

You can learn how to set minimum amount on your coupons by following this tutorial:

WooCommerce – Set Minimum Amount for Hundreds of Coupons in Seconds

How can I bulk enable individual use only on my coupons?

You can enable the Individual Use Only option on hundreds of products by following the steps in this tutorial:

How to Enable Individual Use Only for All WooCommerce Coupons

How can I exclude sale items from my coupons?

You can do it in five minutes or less. Just follow this quick tutorial:

WooCommerce – Exclude Sale Items from All Coupons in Five Minutes

Can I import coupons from Excel or Google Sheets?

Can I export my coupons to Excel or Google Sheets?

You can do it quickly. Just follow the steps in this tutorial:

How to Export WooCommerce Coupons to Excel or Google Sheets

How can I find my most used coupons?

You can learn how to find your most used coupons by following this tutorial:

WooCommerce – How to Find the Most Used Coupons

How can i delete all my expired coupons?

You can learn how to do it by following this tutorial:

WooCommerce – How to Delete All Expired Coupons Quickly

How can I restrict product categories from my coupons?

You can restrict product categories from your coupons by following this tutorial:

How to Bulk Edit Coupon Category Restrictions – WooCommerce

Easy Digital Downloads Spreadsheet

How do I open the spreadsheet?

You can quickly open the Easy Digital Downloads Spreadsheet plugin by going to WP Sheet Editor > Edit Downloads.

How can I create new products on the spreadsheet?

You can create new products on the spreadsheet. For this, use the Add new tool. Enter the number of rows (products) you’ll create and then hit Add new. After that you can proceed to edit the new product titles, categories, featured images, etc.

How can I locate a specific cell?

Just enter the cell content in the Locate Cell field and hit enter.

How can I bulk delete products?

You can delete hundreds of products. Just follow the steps in this tutorial:

Easy Digital Downloads – How to Delete Hundreds of Products in Seconds

How can I bulk edit product descriptions?

This tutorial explains how you can edit hundreds of product descriptions quickly:

Easy Digital Downloads – How to Bulk Edit Product Descriptions

How can I edit my product categories in bulk?

Follow this tutorial to learn how to edit your product categories:

Easy Digital Downloads – How to Bulk Edit Product Categories

How can I bulk edit product prices?

You can edit your product prices in bulk. Just follow the steps in this tutorial:

Easy Digital Downloads – How to Bulk Edit Product Prices

How can I edit my product featured images massively?

Follow this tutorial to learn how to bulk edit your product featured images:

Easy Digital Downloads – Bulk Edit Featured Images

How can I delete my duplicate products?

You can quickly delete your duplicate products. Just follow this tutorial:

Easy Digital Downloads – How to Bulk Delete Duplicate Products

How can I edit my product variable prices?

Please follow this tutorial to figure out how:

Bulk Edit Variable Prices – Easy Digital Downloads

How can I edit my product files?

Learn how to change your product files by following this tutorial:

Bulk Edit Download Files – Easy Digital Downloads

How can I bulk edit bundles?

You can easily edit your bundles, just follow this tutorial:

Bulk Edit Bundles – Easy Digital Downloads

Posts, Pages, and Custom Post Types Spreadsheet

How can I delete duplicate posts or pages?

Please follow this tutorial to find out how:

WordPress – How to Delete Duplicate Posts or Pages in Seconds

How can I delete thousands of posts or pages?

Please follow this tutorial to learn how to do it:

WordPress – How to Delete Thousands of Posts and Pages

How can I convert my pages into full width?

The following tutorial explains to you how to change hundreds of page templates:

WordPress – Make Hundreds of Pages Full Width

How can I change post authors?

You can learn how to edit post authors by following this tutorial:

WordPress – How to Assign All Posts from One Author to Another

How can I change post dates?

You can change hundreds of post dates. Just follow this tutorial:

WordPress – How to Change Dates on Hundreds of Posts

How can I know which posts don't have any links in their content?

This tutorial shows you how to quickly find all posts without links in their content: WordPress – Search Posts WITHOUT any Links in the Content

How can I find all posts without images in content?

Here’s how you can find all your posts missing images in content: WordPress – Search Posts without Images in the Content

How can I find and edit posts with too short/long title?

This tutorial shows you how to find and edit posts with short or long titles: WordPress – Find and Edit Posts with Short or Very Long Titles

How can I find posts by content initial letter or character?

Learn how to find all posts by content initial letter or character by following this tutorial: WordPress – Find Post Content by Initial Letter or Character

How can I search posts by title's initial letter?

Here’s how you can search posts by title’s initial letter: WordPress – Search Posts where Title Begins with a Letter

How can I find my posts missing H2 or H3 headings in content?

Learn how to find posts missing H2 or H3 tags in content by following this tutorial: WordPress – Search Posts WITHOUT H2 or H3 Tags in the Content

How can I find all posts missing YouTube videos in content?

Here’s a tutorial to show you how to find all posts missing YouTube videos in content: WordPress – Search Posts without YouTube Videos in the Content

How can I find posts containing YouTube videos in content?

You can learn how to find posts with YouTube videos in content: WordPress – Search Posts that contain YouTube videos in the Content

How can I find and edit posts with long URLs?

How can I find all posts containing email addresses in content?

Follow this tutorial to learn how to do it: WordPress – Search Posts that Contain an Email Address

How can I edit Visual Composer element styles?

Learn how to edit element styles from Visual Composer by following this tutorial:

Visual Composer – How to Edit Element Styles in Hundreds of Posts or Pages at Once

How can I remove all featured images from posts?

Follow this tutorial to learn how to do it: WordPress – Remove All the Featured Images from Posts

How can I disable post comments in bulk?

Here’s a tutorial for you to learn how to do it: WordPress – Disable Post Comments by Keyword, Author, Category, or Tag

How can I edit last modified date in bulk?

You can learn how to do it by following this tutorial: WordPress Posts – How to Bulk Edit Last Modified Date

How can I edit Advanced Custom Fields?

Learn how to do it by following this tutorial: Bulk Edit Advanced Custom Fields in a Spreadsheet

How can I convert post into posts and vice-versa?

Here’s a tutorial to show you how you can do it: How to Convert Posts into Pages and Vice-versa

How can I find all posts or pages with empty content?

Here’s a tutorial for you to learn how to do it: How to Search Posts and Pages with Empty Content

How can I delete all empty posts and pages?

Follow this tutorial to learn how to do it: How to Delete all Empty Posts and Pages

Can I convert pages into WooCommerce products?

Yes. You can do it. Just follow this tutorial: How to Convert Pages into WooCommerce Products

Media Library Spreadsheet

How can I open the Media Library Spreadsheet plugin

Just go to Sheet Editor > Edit Media

How can I edit my images' captions?

Here’s a tutorial for you to learn how to do that: WordPress – How to Bulk Edit Image Captions

How can I find images missing alt text or caption?

You can do it by following this tutorial: WordPress – Find Images Without Alt Text or Caption

How can I bulk delete images?

You can delete images by following the steps in this tutorial: WordPress – Delete Thousands of Images in Media Library

How can I delete all unattached images?

You can do it by following this tutorial: WordPress – Delete All Unattached Images from Media Library

How can I find images by file size?

You can quickly do it by following the steps in this tutorial: WordPress – Find Images by File Size in Media Library

How can I find images by extension?

Follow this tutorial to learn how to do it: WordPress – Find Gallery Files by Extension

Can I filter my images by caption, alt text or title?

Sure! Just follow the steps in this tutorial: WordPress – How to Search Images by Caption, Alt Text, or Title

Can I import alt texts from a CSV file?

Of course. Just follow this tutorial to see how to do it: How to Bulk Import Alt text for Images in the WordPress Media Library

Can I filter my images by specific year, day, month, etc?

You can do it easily by following this tutorial: WordPress – How to Search Images by Day, Week, Month, or Year

Can I set a default alt text for all my images?

Yes. You just need to follow this tutorial to learn how to Set Same Alt Text on all Images in the WordPress Media Library

How can I find all my images missing alt text?

You can follow this tutorial to learn how to do it: WordPress – Find All Images with Empty Alt Text in the Media Library

How can I find images missing captions?

You can quickly do it. Just follow the steps in this tutorial: WordPress – Find All Images with Empty Captions in the Media Library

How can I find all images with short alt text?

How can I remove hyphens or symbols from my images' alt text?

Can I find and delete broken images from my WP media library?

Can I filter my images by blog category?

Yes. You just need to follow this tutorial: WordPress – Search Images by Blog Category in the Media Library

How can I filter my images by product category or attribute?

How can I edit thousands of images' SEO alt text?

You need to follow this tutorial to learn How to Bulk Edit Image SEO Alt Text

How can I find files by format or extension?

You can do it by following the steps in this tutorial: WordPress – Search Files by Format or Extension in the Media Library

Can I filter all my images by Width and height?

Yes. You just need to follow these simple steps: WordPress – Find Images by Width and Height in Media Library

How can I find product images in my media library?

Can I filter my images by product color or size?

Can I set post title and categories as image alt text?

How can I set product categories, tags and attributes as image alt text?

It requires you to follow the steps in the following tutorial: WooCommerce – Set Product Categories, Tags and Attributes as Image Alt Text

Categories, Tags, Product Attributes, Taxonomies Spreadsheet

How can I open the spreadsheet?

To open the spreadsheet, just go to Sheet Editor > Edit categories, tags, categories, taxonomies

How can I upload images to my product categories?

You can do it by following this tutorial: WooCommerce – Upload Images to Hundreds of Product Categories

How can I edit my category descriptions in bulk?

How can I bulk delete hundreds of categories?

Can I convert categories into global attributes?

How can I convert categories into tags?

You need to follow this tutorial in order to do it: WooCommerce – How to Convert Tags into Categories and Vice-versa

How can I export/import categories from Excel or Google Sheets

Can I regenerate category URLs from their titles?

This tutorial shows you the steps you need to follow to do it: WordPress – Regenerate Category URLs from Titles

How can I bulk delete product categories?

Here’s a tutorial to show you how to do that: WooCommerce – How to Delete Categories in Bulk Quickly

How can I rename blog categories or tags in bulk?

You just need to follow this tutorial in order to do it: WordPress – Bulk Rename Blog Categories and Blog Tags

How can I delete WooCommerce categories, attributes or tags in bulk?

How can I create hundreds of sequential attributes?

You can do it by following this tutorial: WooCommerce – Create Hundreds of Sequential Attributes

Can I search categories by initial letter in title?

Yes. You need to follow this tutorial to find out how to do it: WordPress – Search Categories or Tags that Start with a Letter

Can I filter product attributes by initial letter?

Yes. You can filter all product attributes such as colors, sizes, etc., by initial letter.

Just follow the steps in this tutorial: WooCommerce – Search Product Attributes that Start With a Letter (Color, Sizes, etc.)

How can I filter all product attributes by initial or final number?

How can I filter all post categories by initial or final number?

Close Menu