Time Saving Features in Adwords Editor: The Copy and Paste

By | 2017-08-08T08:35:44+00:00 June 17th, 2011|Categories: PPC|Tags: , , , |

Est. Reading Time: 2 minute

I remember back in the day, stumbling upon a neat little tool called “Adwords Editor“.  And it was like the sky broke open, angels sang, and the gods smiled down on me. Once I used it, all I could say was: WHAT. A. FIND. Unfortunately I made this find after having a co-worker do a tremendous and tedious account overhaul manually is Adwords, but let’s not talk about that.

Anyway… we all know how Adwords Editor saves us time creating, managing, and editing PPC accounts. But there are even more features once you get into the nitty-gritty of Editor that are worth being aware of. And today I’d like to talk about the most simple of these: copy & paste.

The Copy and Paste in Adwords Editor

Yup. Good ol’ copy and paste. So, we all know you can export all or parts of an account using the “Export” feature under “File”. But what if you want to manipulate something super specific, like ad copy and keyword destination URLs? Exporting this is difficult and even impossible in some circumstances. Well,  copy and paste to the rescue!

How to Use Copy and Paste in Adwords Editor

Simply Control + C or Shift + C (depending on whether you’re selecting choice data or all data in a group) and Control + V into Excel. All data, including headings, will be pasted. Now do your thing with edits. Save as CSV, making sure your headings match, and import into Editor. Review and approve edits. Done! Now wasn’t that easy?


This method has served me particularly well in making large, sweeping changes to ad copy. Give it a try and check back again for more tips on our beloved Adwords Editor!






About the Author:

Andrea Cole
With 13+ years of SEO, paid search and Google Analytics experience, Andrea is Beacon’s “chief digital strategist,” working directly with our Higher Education clients and large commercial accounts. Her in-depth review of Husson University’s website led to an overhaul of the keyword and content targets of 100+ pages within their degree and program content, significantly improving search visibility. Andrea earned a B.A. in Communication Studies from UNC Chapel Hill, is certified in Google Analytics and is invited annually to Google’s exclusive GA Summit. She recently served as an adjunct professor in Wake Forest University’s MSBA Program and led a conference seminar for improving site search and SEO in Higher Education. Andrea is also the author of The SEOptimist blog, which provides useful tips and informative articles on SEO, PPC and Web Marketing.