Google first introduced the edit by spreadsheet feature for Google Adwords back in 2009 in an attempt to make performing bulk changes to your campaigns easier. Since then however Google has  released bulk editing to help you make large-scale changes across your AdWords account, and keyword bulk uploads to help you add, edit and remove keywords at scale. Bulk editing and keyword bulk uploads cover all the capabilities of spreadsheet edit while being more powerful and scalable. In light of this, they are sunsetting the Google Adwords spreadsheet edit feature on May 30, 2013. If you are accustomed to using spreadsheet edit, then based on what you want to achieve, you can do one of two things:

  1. You can click the “Edit” drop down and choose the type of bulk edit you want to make.  Bulk edits on your keywords will allow you to:
    • Search and replace text in the keyword or destination URL
    • Append text to the keyword or destination URL
    • Set new bids, including increasing to first page or top of page CPC
    • Increase or decrease bids
    • Change keyword match types
    • Add/remove labels
  2. You can use keyword bulk uploads.  On the same page where you’ve always been able to download keyword reports, click the box that says “Editable.”  This will download a special, editable version of the keyword performance report that you can modify and then upload.

For more information about using these features in place of the spreadsheet edit feature, read the bulk edits article and the keyword bulk uploads article within the Google help center. These should help you get started.

Published by Michael Boguslavskiy

Michael Boguslavskiy is a full-stack developer & online presence consultant based out of New York City. He's been offering freelance marketing & development services for over a decade. He currently manages Rapid Purple - and online webmaster resources center; and Media Explode - a full service marketing agency.

Leave a comment

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