Download and Re-Upload A CSV (Excel) Adwords Campaign
For the longest time I loathed Google Adwords Editor for one main reason…
I would want to download a campaign to a CSV and edit it within excel (because that is soooo much easier than editing it in the actual editor). When I would go to upload the campaign, I would realize that the only way you can upload the campaign via the Adwords Editor is through the encrypted .AEA files.
For a long time I searched on how to make this work and saw that some people use macros and external programs to get this to work and well… I didn’t want to do that.
After thinking about how the adwords Editor works… I figured a way to do it fairly efficiently and with very little extra work.
Basically, because the adwords editor checks for incorrect values and such, you can utilize this for your advantage!!!
So, let’s go through the whole process…
Download a CSV campaign using the Adwords Editor
- First, you’ll need Adwords Editor.
- Next, right click on a campaign and click export to CSV.
- Edit campaign in excel.
Upload A CSV Campaign to Adwords using the Adwords Editor
- First Select ALL (Ctrl+A) and Copy (Ctrl+C)
- Go into Adwords Editor and click on the keywords tab. Click Make multiple changes -> Add / Update Multiple Keywords.
- Click my campaign information below includes column information…
- Paste the entire campaign into the box and hit ok.
- You’ll notice that Adwords Editor filters out the ads as incorrect formats. Sweet.
- Now, click the ad tab, add multiple ads and again paste the entire campaign.
- Now you’ll need to go through and if this is a new campaign (or renamed), you will need to set adgroup bids and enter the remaining campaign information on the tabs.
Editing campaigns in this format really saves me a lot of time and I hope that it can save you a lot of time too… 
