Bulk Edit Posts and Products in Spreadsheet

Description

A Spreadsheet created specially for WordPress. Edit posts in bulk using Spreadsheet.

It works with Gutenberg (new editor) and the Classic Editor

You can edit the post content using the Gutenberg editor right on the spreadsheet.
It also works with the Classic Editor.

Awesome things that you can do with WP Sheet Editor

  • View all your posts, pages, and woocommerce products in a spreadsheet
  • Edit posts in Spreadsheet (all core fields)
  • Edit pages in Spreadsheet (all core fields)
  • Create a lot of posts / products at once
  • Copy information between posts
  • Edit WooCommerce Products (Free version limited to title, status, regular price, sale price).
  • And more…

WP Sheet Editor is perfect for you if…

  • You are tired of opening several pages to edit your posts
  • You are tired of wasting time waiting for each post editor to load and save

Features

  • Spreadsheet where you can edit all the information of your posts, pages, and woocommerce products including post title, post content, post status, post excerpt, featured image, publish date, comment status, page parent, post categories, and post tags.
  • You can navigate in the spreadsheet with your keyboard
  • You can order the spreadsheet by any column.
  • You can edit hundreds of posts without reloading the page
  • It works on shared hosting (you can adjust the server consumption on the options page)
  • Developers can add custom columns to the spreadsheet using actions and filters.
  • VISUAL COMPOSER integration. Open the live or backend editor right on the spreadsheet.

Premium features

WooCommerce Spreadsheet:

Edit woocommerce products using the spreadsheet.
It works well with Variable Products, Attributes, Downloadable Products, and Variations.

Buy WooCommerce Spreadsheet Plugin
Money back guarantee. We´ll give you a refund if the plugin doesn´t work.

Edit all product fields, including:

  • sale price
  • regular price
  • gallery
  • short description
  • stock status
  • stock quantity
  • featured image
  • visibility
  • is virtual
  • is downloadable
  • attributes
  • categories
  • tags
  • sale price dates
  • purchase notes
  • enable reviews
  • Shipping class
  • Custom fields
  • And more.

Buy WooCommerce Spreadsheet Plugin
Money back guarantee. We´ll give you a refund if the plugin doesn´t work.

Replace formula:

Apply changes to ALL YOUR POSTS AT ONCE with just a few clicks.

You can do a lot of things, like:

  • Replace words or phrases
  • Add a message at the end/beginning of your posts
  • Change posts status
  • Add a message above or below all the images.
  • Add shortcodes at the beginning or ending of all the posts in a specific category
  • Change all references to old prices in your posts
  • Change all links in your posts
  • Mark all products in a specific category as “out of stock”
  • Add a category to ALL THE POSTS in a specific category
  • Change post status from draft to publish, or any other
  • Set the same featured image in ALL the posts in specific category.
  • Replace an existing value with the current date
  • Etc.

Buy Premium Version

Math formula:

For example:

  • Increase / decrease products prices by a 10%
  • Increase / decrease your products stock in a specific product category

Advanced Custom Fields integration

Edit your metaboxes in the spreadsheet.

Add custom columns to the spreadsheet and edit other plugin´s fields.

Buy Premium Version

Copy information between posts in bulk

Do you need to set the same categories to 20 posts? Instead of adding every category manually, just drag one cell and paste it into the 20 cells below. Yes, it´s that easy.

You can copy titles, excerpts, post dates, categories, tags, etc.

You can enable / disable columns on the spreadsheet.

You can rename columns on the spreadsheet

Edit custom post types

You can enable the spreadsheet on ANY custom post type.

For example, you can edit the descriptions or captions of your images (media attachments) to improve your SEO.

If you theme added a “Portfolio” post type, you can edit the items too.

Buy Premium Version

Screenshots

  • spreadsheet editor
  • settings page

Installation

Automatic installation

Automatic installation is the easiest option as WordPress handles the file transfers itself and you don’t need to leave your web browser. To do an automatic install log in to your WordPress dashboard, navigate to the Plugins menu and click Add New.

In the search field type WP Sheet Editor and click Search Plugins. Once you’ve found our plugin you can install it by simply clicking “Install Now”.

Manual installation

The manual installation method involves downloading our plugin and uploading it to your webserver via your favourite FTP application. The WordPress codex contains instructions on how to do this here.

FAQ

What kind of posts can I edit using the spreadsheet?

Only posts, pages, and woocommerce products with the free plugin.

WooCommerce Products include LIMITED support, you can edit only simple products and you can edit prices only.

The premium plugin allows you to edit ANY custom post types, including WooCommerce products with all their fields.

What post information can I edit using the spreadsheet?

You can edit all the information of your posts and pages, including post title, post content, post status, post excerpt, featured image, publish date, comment status, page parent, post categories, and post tags.

Can I edit WooCommerce products using the spreadsheet?

The free plugin includes limited support for WooCommerce Products, you can edit only simple products and you can edit prices only.

You need the premium version for editing all types of WooCommerce products and all product fields. Read more about the extension.

Can I edit easy digital downloads products using the spreadsheet?

You need the premium version for editing easy digital downloads products. Read more about the extension.

Can I edit custom post types using the spreadsheet?

The free plugin only allows to edit posts and pages.

But we have the premium version that allows you to edit any custom post type, for example, media attachments, posts , pages , courses , jobs , projects , or any other post type added by other plugins.

Read more about the extension.

Can I run formulas on the spreadsheet?

You need the premium version for running formulas to update all your posts at once. Read more about the extension.

Can I hide the spreadsheet columns that I dont need?

You need the premium version for this. Read more about the extension.

Can I rename the spreadsheet columns?

You need the premium version for this. Read more about the extension.

Can I add custom columns to the spreadsheet?

Yes. The plugin contains several actions and filters for developers. You can add custom columns , modify the spreadsheet behaviour , etc.

Can I use this plugin on cheap / shared servers?

Yes. You can set up the number of posts to save per batch and the waiting between batches. Tweaking those settings you can make it work with any server.

Reviews

June 10, 2019
Hablo de mi experiencia por el soporte del plugin: excelente. ¿Y por qué? Pues por varias razones de peso, ya que acudí a este soporte por un fallo que tenía en mi sitio. Al final descubrimos que el fallo venía por el tema que tenia instalado, pero el Sr. Jose Vega me atendió con mucha amabilidad y profesionalidad. Puedo decir abiertamente, que se esforzó mucho en darme soporte, porque quedamos vía email para compartirle la pantalla y mi configuración en remoto fallaba una y otra vez. Pero este señor estuvo probando muchas aplicaciones para darme respuesta en remoto y al final lo conseguimos por Skype. Estuvo conmigo mas de una hora y no solo solución el problema de compatibilidad en mi sitio (aunque no era suyo porque era de mi theme) sino que me dio varios consejos para ayudarme a usar este plugin. Por todo esto, solo tengo buenas palabras sinceras por este trabajo. Y lo recomiendo muchísimo, independientemente del nivel de programación que tenga cualquier usuario. Deberían aprender muchos otros de esta empresa.
May 29, 2019
Great support: i needed some help, and they asked me for a remote access to my Mac. In 10 minutes Mr Jose fixed the problem in my (old) computer.
May 28, 2019
I absolutely love this product - it's been a game changer for our business - allowing us to get our writers to create hundreds of pages of content in Google Sheets for us to upload. But best of all is the service and support. Every time I've had an issue, they've helped me out - whether by email or live chat or even screen sharing and going through issues. The small price to pay is worth the amazing product you get.
May 4, 2019
Thanks a lot for this very useful plugin and for the quick support too. You can easily change or update dozens or even hundreds of pages or blog posts in one run: Normally you have to open, edit, and save each page or blog post one after the other. This takes a lot of time, of course. There is also a chance that you leave out by mistake the one or the other page or blog post amongst hundreds of posts. But the wp sheet plugin provides a very convenient "content editor" window with some useful buttons. You can make your changes in this window and then simply click the forward or the backward button in order to run through all pages or blog posts. These buttons save your changes at the same time too. It works perfectly in the classic mode too (with the "Classic Editor" plugin from WP installed). So this is an extremely easy and time saving tool when you have to change or to update dozens or even hundreds of pages or blog posts. Great plugin - thumbs up and five stars.
Read all 38 reviews

Contributors & Developers

“Bulk Edit Posts and Products in Spreadsheet” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

—— V 2.12.0 – 2019-07-01 ——
NEW – CORE – Add “share” tool to faciliate user collaboration
NEW – CORE – Add the option to select the user roles who can access our spreadsheet.
NEW – CORE – Added option to deactivate the data prefetch
NEW – CORE – Allow to disable the meta data scan programmatically
NEW – CORE – allow to rename columns using contextual menu
NEW – CORE – Allow to rename columns using the columns visibility popup
NEW – MEDIA – Add column showing the parent post title as readonly
NEW – UNIVERSAL SHEET – EXPORT – Added option to add CSV compatibility with excel
NEW – UNIVERSAL SHEET – EXPORT – Added option to select all active columns
NEW – WC Products – Allow to edit custom fields on variation rows
CHANGE – CORE – When a toolbar is disabled, automatically stop rendering the related popup content
CHANGE – MEDIA – Remove the “add new” tool
CHANGE – USERS – If the current user can edit, the default query shouldn’t have the role__in query parameter, it should load all roles
CHANGE – WC Products – Import – Automatically map the “meta: ” columns
CHANGE – WC Products – Import – When there is an error, indicate the row that contains the error
FIX – CORE – Disable wpautop when using gutenberg because it breaks the block markup
FIX – FILTERS – Search by author doesn’t work (the author dropdown has wrong user ids)
FIX – FORMULAS – The column placeholders don’t work for columns that use the get_value callback
FIX – GLOBAL – Sometimes when we use the free plugin and activate the premium plugin, the license activation screen doesn’t appear and the user doesn’t know how to activate it
FIX – MEDIA – fix the preview column to show the thumbnail and large image on hover
FIX – UNIVERSAL SHEET – CSV reading – It doesn’t work when “fopen(): data:// wrapper” is disabled in the server
FIX – UNIVERSAL SHEET – Export – It fails when column headers count doesn’t match the column values count in a row
FIX – UNIVERSAL SHEET – EXPORT – It links directly to the CSV file which just displays the content instead of downloading it
FIX – UNIVERSAL SHEET – IMPORT – CSVs that contain &quot can’t be read
FIX – WC Products – Export – The columns coming from the WC CORE api are duplicated starting from batch 2
FIX – WC Products – Import – Optimize the auto mapping of columns to avoid using too much memory when we have too many columns
FIX – WC Products – Import – Sometimes we end up with ghost products created by WC Core, auto delete them
FIX – WC Products – Import – The “Import as meta” option in the columns mapping wasn’t working

See full changelog.