wp-sheet-editor-logo-15px
  • AI
  • Google Sheets Sync
  • Plugins
    • Automations
    • WooCommerce Products Spreadsheet
    • Posts, Pages, and Custom Post Types Spreadsheet
    • Courses Spreadsheet
    • Media Library Spreadsheet
    • WordPress Users Spreadsheet
    • WooCommerce Coupons Spreadsheet
    • Comments and Reviews Spreadsheet
    • Categories, Tags, Product Attributes, Taxonomies Spreadsheet
    • WooCommerce Orders Spreadsheet
    • Universal Frontend Editor
    • Easy Digital Downloads Spreadsheet
    • GiveWP Spreadsheet
    • Events Spreadsheet
    • WooCommerce Customers Spreadsheet
    • Custom Database Tables Spreadsheet
    • All Plugins
  • Help
    • Guides and Tutorials
    • FAQ
    • Contact
    • Developers
  • Account
  • Toggle website search
Menu Close
  • AI
  • Google Sheets Sync
  • Plugins
    • Automations
    • WooCommerce Products Spreadsheet
    • Posts, Pages, and Custom Post Types Spreadsheet
    • Courses Spreadsheet
    • Media Library Spreadsheet
    • WordPress Users Spreadsheet
    • WooCommerce Coupons Spreadsheet
    • Comments and Reviews Spreadsheet
    • Categories, Tags, Product Attributes, Taxonomies Spreadsheet
    • WooCommerce Orders Spreadsheet
    • Universal Frontend Editor
    • Easy Digital Downloads Spreadsheet
    • GiveWP Spreadsheet
    • Events Spreadsheet
    • WooCommerce Customers Spreadsheet
    • Custom Database Tables Spreadsheet
    • All Plugins
  • Help
    • Guides and Tutorials
    • FAQ
    • Contact
    • Developers
  • Account
  • Toggle website search

FAQ

  1. Home>
  2. Help articles>
  3. FAQ>
  4. Page 6

Disable usage stats widget

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

To disable usage stats widget, go to settings > advanced settings > Customize Features> Disable usage stats widget?, and tick/untick the checkbox

Continue ReadingDisable usage stats widget

Suspend object cache invalidation

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

To suspend object cache invalidation, go to Settings > Advanced settings > Solution to weird errors > Suspend Object Cache invalidation?, and tick/untick the checkbox

Continue ReadingSuspend object cache invalidation

Disable or enable extension offerings

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

To disable extension offerings, go to Settings > Advanced Settings > Misc > Disable extension offerings? and tick/untick the checkbox

Continue ReadingDisable or enable extension offerings

How to set a different taxonomy separator

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

If you want to select a different taxonomy separator, go to Settings > Advanced settings > Solution to Weird Errors > Separator for taxonomy terms cells, and enter…

Continue ReadingHow to set a different taxonomy separator

How to load rows from a specific row number

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

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 > Misc…

Continue ReadingHow to load rows from a specific row number

How to enable/disable the fixing of the first 2 columns at the left side

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

To disable or enable the fixing of the first 2 columns at the left side of the spreadsheet, go to Settings > Advanced settings > Increase productivity >…

Continue ReadingHow to enable/disable the fixing of the first 2 columns at the left side

How to add values at the beginning or end of columns or rows

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

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…

Continue ReadingHow to add values at the beginning or end of columns or rows

How to set new values on columns

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

To set new values on columns, go to the “Bulk Edit” tool. Select the column you’ll edit >Choose “Set value” as the type of edit you’ll apply >…

Continue ReadingHow to set new values on columns

How to replace words or phrases in an entire column

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

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”…

Continue ReadingHow to replace words or phrases in an entire column

How to delete everything in one column

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

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”…

Continue ReadingHow to delete everything in one column

How to edit post or product URL

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

To edit a product/post URL, go to the “Slug” column, and hit “Enable”. Then, paste the URL in the “Slug” cell.   Note: If the products are not…

Continue ReadingHow to edit post or product URL

How to copy paste from Excel

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

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…

Continue ReadingHow to copy paste from Excel

How to copy paste images

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

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

Continue ReadingHow to copy paste images

How to edit images as plain text/URLs

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

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…

Continue ReadingHow to edit images as plain text/URLs

How to create a new column

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

For most cases, our spreadsheet will recognize all the columns in the spreadsheet immediately if you go to Settings > Scan DB. This action will show all the…

Continue ReadingHow to create a new column

How to save changes faster

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use 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 the spreadsheet and click on…

Continue ReadingHow to save changes faster

How to show cells as simple texts

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

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

Continue ReadingHow to show cells as simple texts

How to hide a column

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

To hide columns from the spreadsheet, you need to right-click on the column you want to hide and click “Hide column”. You can also use the Columns Manager…

Continue ReadingHow to hide a column

How to display a new column in the spreadsheet

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

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

Continue ReadingHow to display a new column in the spreadsheet

Can multiple users edit using the Sheet Editor without causing issues?

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

Yes, multiple users can make use of the spreadsheet at the same time, but they have to coordinate with each other to not edit the same items and…

Continue ReadingCan multiple users edit using the Sheet Editor without causing issues?

How can I translate the plugin?

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

The plugin can be translated to your language. You need to translate 2 .pot files with poedit (or any translation software). /lang/**.pot /modules/wp-sheet-editor/lang/**.pot = this file is shared…

Continue ReadingHow can I translate the plugin?

How to create new products

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

There are 2 main ways to create products or posts 1 - Create them through the live editor To create new rows, write the number of rows you…

Continue ReadingHow to create new products

How to open and use the “Search” tool

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

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…

Continue ReadingHow to open and use the “Search” tool

How to open and use the “Bulk edit” tool

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

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…

Continue ReadingHow to open and use the “Bulk edit” tool

How to locate cells in the spreadsheet

  • Post author:Jonathan Gomez
  • Post published:December 10, 2020
  • Post category:FAQ/How to use the spreadsheet

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.

Continue ReadingHow to locate cells in the spreadsheet
  • Go to the previous page
  • 1
  • …
  • 3
  • 4
  • 5
  • 6

Help

  • Guides and Tutorials
  • FAQ
  • Technical support
  • Request refund
  • My account

Product

  • AI
  • Google Sheets Sync
  • All Spreadsheets
  • Features
  • Testimonials and reviews
  • Changelog
  • Suggest new features

Company

  • Company
  • Contact Us
  • Development services
  • Affiliate Program
  • Sitemap
  • Privacy Policy of our Google Sheets Sync service
  • Privacy Policy of the Bulk AI API

Guides

  • Auto Update WooCommerce Stock Daily from Google Sheets
  • Bulk Reset WooCommerce Stock to 0 – NO CODE NEEDED
  • Auto Reset WooCommerce Stock from Google Sheets Weekly or Monthly
  • How to Auto Reset WooCommerce Stock Weekly or Monthly
  • WordPress: How to Bulk Edit Yoast SEO Canonical URLs
  • License
  • Privacy Policy
  • Cookies
  • Terms and Conditions
Copyright © 2016 - 2025 VegaCorp S.A. de C.V. All Rights Reserved. Sheet Editor® is a registered trademark.
Manage Cookie Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage {vendor_count} vendors Read more about these purposes
View preferences
{title} {title} {title}