How to delete a column permanently
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…
How to import/export the spreadsheet settings
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…
How to load 500 rows at once in the spreadsheet
If you want to load 500 rows at once in the spreadsheet, then you need to go to advanced settings, and then go to speed and performance. Note,…
How to copy values between columns
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…
How to disable the loading of rows on scroll
To disable the loading of rows on scroll, Go to settings > Load more rows on scroll and leave it unchecked.
How to remove the help messages on the spreadsheet columns?
Go to the spreadsheet > Settings > Advanced settings > Customize features > Remove help messages from the cells.
Why do the columns appear in different order?
By default, the columns are ordered based on the code execution of the related Sheet Editor module. We have the serialized columns module, ACF module, etc. That’s why…
How to change dates in the spreadsheet
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. This applies to…
How to add extensions
To add extensions to the plugin, open the “Extensions” tool by clicking “Extensions” on the toolbar.
Use slower execution method
The default way uses a faster execution method, but it might not work in all cases. In such cases, go to “Bulk Edit” and check the “Use slower…
Disable post actions while saving
To disable post actions while saving, go to Settings > Advanced settings > Solution to weird errors > Disable post actions while saving?, and tick/untick the checkbox
Disable cells lazy loading
To disable cells lazy loading, go to Settings > Advanced settings > Customize Features> Disable cells lazy loading?, and tick/untick the checkbox
Disable usage stats widget
To disable usage stats widget, go to settings > advanced settings > Customize Features> Disable usage stats widget?, and tick/untick the checkbox
Suspend object cache invalidation
To suspend object cache invalidation, go to Settings > Advanced settings > Solution to weird errors > Suspend Object Cache invalidation?, and tick/untick the checkbox
Disable or enable extension offerings
To disable extension offerings, go to Settings > Advanced Settings > Misc > Disable extension offerings? and tick/untick the checkbox
How to set a different taxonomy separator
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…
How to load rows from a specific row number
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…
How to enable/disable the fixing of the first 2 columns at the left side
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 >…
How to add values at the beginning or end of columns or rows
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…
How to set new values on columns
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 >…
How to replace words or phrases in an entire column
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”…
How to delete everything in one column
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”…
How to edit post or product URL
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…
How to copy paste from Excel
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…
How to copy paste images
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
How to edit images as plain text/URLs
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…
How to create a new column
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…