1. Sign in to your Google Ads account.
2. Select All campaigns from the navigation menu.
3. Select Keywords, Ads, Ad Group, Campaigns, or Product groups (depending on the type of edits you’d like to make).
4. Click the download icon .
5. Select a format for your spreadsheet.

1. Sign in to your Google Ads account.
2. Click the tools icon  in the top-right corner of your account.
3. Under “Bulk actions,” click Uploads.
4. Click the blue plus icon .
5. Click View templates.
6. Download your template as a CSV or Excel spreadsheet.

Add keywords, ads, ad groups, campaigns, or product groups

To add a keyword, ad or any other item, create a new row in your downloaded spreadsheet.

Next, enter the values you want for your new item, such as bid, budget or status. If you don't specify a the "status" column of a new item, the item will be enabled by default.  Refer to this list of supported items and corresponding values.

Remove keywords, ads, ad groups, campaigns, or product groups

To remove a keyword, ad or any other item:

1. In your downloaded spreadsheet, find the row that contains the item.
2. In the "Status"column for that row, enter Remove.
3. Upload your spreadsheet.

General rules for editing

• Don't modify or delete the header row, which contains column names.
• You don't have to note or signal your changes. When you're finished and you upload your spreadsheet, we'll compare the spreadsheet to your current options to pick out any changes you’ve made. You’ll also have the chance to preview any changes before you make them.
• Don’t worry about deleting extraneous columns or the total rows.
• Be sure to save your spreadsheet in one of our supported formats (.xls, .xlsx, .tsv, or .csv).

• Type the keyword in the Keyword column. Use square braces ([ ]) or quotes ("") around the keyword to specify exact or phrase match.
• Enter the ad group name in the Ad group column.
• You cannot edit the keyword or match type column for an existing keyword. When you change a keyword or match type, the old keyword is removed and a new one is created. The same is the case with bulk uploads. Therefore, if you want to edit a keyword or match type in an editable report, you will have to remove the current and create a new keyword with your desired changes.

You cannot edit the text for an existing ad. When you change an ad, the old ad is removed and a new ad is created. The same is the case with bulk uploads. Therefore, if you want to edit an ad offline in a spreadsheet, you have to remove the current ad and create a new ad with your desired changes.

Add an ad extension

To add a new ad extension:

• In the “Campaign” column, type the campaign where you want to add your extension.
• If you want to add the extension to an ad group, then also specify the ad group in the “Ad group” column.

• To add an app extension, you must specify:

  • Mobile OS: The operating system that your target customers are using. You can enter android or ios.

  • Package name: The unique ID of your app. For Android, the Package Name follows id= in the app’s Google Play URL:

    http://play.google.com/store/apps/details?id=com.example.appname

    For iOS apps, enter the App ID, which appears after id in the app’s iTunes URL:

    http://itunes.apple.com/us/app/example-app-name/id#########

  • App link text: Text that people will click on to get to your app. For example, you could use “Download app.”
  • Final URL: The URL displayed to your customers for your app. For example, this might be the URL of your app in the Google Play store.

• To add a call extension, you must specify:

  • Phone number: The number that will be called when a customer clicks your extension.
  • Country code: The country where your phone number is listed. For example, if your phone number is in the United States of America, you would put US.
  • Use forwarding number (optional): Whether you want to use a Google forwarding number with your ad. You can enter yes or no. The default is no.

• To add a review extension, you must specify:

  • Source name: The person or organization that provided the review.
  • Source URL: The URL where the person or organization printed your review.
  • Text: The text of your review.
  • Is exact quote (optional): Whether your text is exactly the words in the review. You can enter yes or no. The default is no.

• To add a sitelink extension, you must specify:

  • Sitelink text: The text that you want to appear as the clickable link in your sitelink.
  • Final URL: The URL where the link in your sitelink will lead.

  The Description fields are optional, but can make your ad more relevant to potential customers. If you choose to have descriptions, you must use both fields. Your description may be eligible to show below the sitelink.

  Learn more in the Sitelinks with additional detail section.

• To add callout extensions, you must specify:
  • Callout text: The text you want to appear as your callout

• To add structured snippet extensions, you must specify:
  • Structured snippet header: Header(s) chosen from this list of predefined headers, capitalizing the first letter of each header. NOTE: Only the headers on our list will be accepted.
  • Structured snippet values: The specific header-related details you’re highlighting.

  Optional specifications for all ad extensions

  In addition to the required columns in each report, you can use bulk uploads to identify device preference, start and end dates for your extension, and scheduling preferences. To specify these options, add a new column to your spreadsheet with the following names and information:

  • Start time: The date you want your extension to start showing. This should should use a mm/dd/yyyy format. For example, July 1, 2014 would be 07/01/2014.
  • End time: The date you want your extension to stop showing. This should should use a mm/dd/yyyy format. For example, July 1, 2014 would be 07/01/2014.
  • Device preference: The devices you want to show your extension on. You can specify all or mobile.
  • Scheduling: The days of the week and times you want your extension to be shown. You must use the format of Day, start time - end time. For example, if you wanted to schedule from 9 a.m. to 5 p.m. on Mondays, you would enter Monday, 09:00 AM - 05:00 PM. If you want to schedule for multiple days, separate your days with a semicolon. For example, you could schedule for both Monday and Tuesday using Monday, 09:00 AM - 05:00 PM; Tuesday, 09:00 AM - 05:00 PM.
   

  Remove an ad extension

  To remove an ad extension, enter Remove in the Action column of that ad extension’s row. This will remove the extension from the campaign or ad group (though the extension will still exist for use with other campaigns and ad groups). Deleting the row or removing the contents from the row will have no effect.

For detailed instructions, see information about bulk uploads in Shopping campaigns.

1. Sign in to your Google Ads account.
2. Select All campaigns from the navigation menu. 
3. Select Keywords, Ads, Ad Group, Campaigns, or Product groups (depending on the type of edits you’d like to make).
4. Click the three-dot icon . 
5. Click the Upload icon .
6. Choose the spreadsheet you want to upload.
7. Click Open.
8. Click Preview if you wish to preview the data before uploading.
9.  Click Apply.

Here's how to upload your spreadsheet:

1. In your AdWords account, click Bulk operations in the left navigation window.
2. Select Bulk uploads.
3. Click Choose file to locate your edited and saved spreadsheet.
4. Click Upload and preview.
5. When loaded, a preview of your changes will appear. At this point, you can see what your changes would look like, fix any errors in your spreadsheet then upload again, or ignore the errors and click Apply changes.

You can create multiple Google Ads or AdWords Express accounts from your manager account using bulk upload. Here's a CSV template.

Identifying errors

Fixing errors