Make changes with bulk uploads

Using bulk uploads is an efficient way to make changes to the keywords, ads, ad groups, campaigns and product groups (for Shopping campaigns) in your Google Ads account. This feature saves you time by allowing you to download spreadsheets, make changes offline and then upload the updated spreadsheet back into your account where your new changes will be applied. In this way, you can take immediate bulk action on the problems and opportunities that you observe in your data. In this article, we’ll explain how to download, edit and upload a spreadsheet.


Amy is an online retailer who sells sporting equipment. She has thousands of keywords spread across dozens of ad groups. In the past, she used spreadsheets and a proprietary formula to make changes to her bids, which she entered manually into her Google Ads account. With bulk uploads, she can download a spreadsheet of her keywords, change her bids by applying her proprietary formula to the spreadsheet, then upload this same spreadsheet directly into her Google Ads account.

Once Amy has uploaded the edited spreadsheet, she can preview any changes, get details of possible errors and apply the changes when she’s ready – all in the same tab. She can even share her preview with colleagues if she wants a second opinion.

1. Download spreadsheets to edit

This step is recommended to ensure that your changes are uploaded correctly.

Download spreadsheet from account

  1. Sign in to your Google Ads account.
  2. Select All campaigns from the navigation menu.
  3. Select Keywords, Ads, Ad Group, CampaignsAudiences or Product groups (depending on the type of edits that you’d like to make).
  4. Click the download icon Download, and select More options at the bottom of the drop-down.
  5. Select a format for your spreadsheet.
  6. Under 'Include', tick the box for Editable columns for Bulk Upload.
  7. Click Download
Try it now

If you download a report, it won't include all of the fields you can edit.

Save your original downloaded spreadsheet

Once a bulk upload is submitted, there's no automated way to cancel or reverse your changes. Therefore, we recommend that you always save a copy of your original downloaded report in case you ever need to see what your settings were before you made changes.

2. Format spreadsheets

Edit spreadsheets (General rules)

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 that you want for your new item, such as bid, budget or status. If you don't specify the 'status' column of a new item, the item will be enabled by default. Refer to this list of supported items and corresponding values.


You can’t edit ads in your downloaded spreadsheet. To change an ad, delete it and create a new one in the spreadsheet with the edits that you want to make. 

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 that 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.
  • Make sure that you save your spreadsheet in one of our supported formats (.xls, .xlsx, .tsv or .csv).
Edit keyword spreadsheets
  • Type the keyword in the Keyword column. Use square brackets ([ ]) or quotation marks ("") around the keyword to specify exact or phrase match.
  • Enter the ad group name in the Ad group column.
  • You can't 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 applies to bulk uploads. Therefore, if you want to edit a keyword or match type in an editable report, you'll have to remove the current keyword and create a new keyword with your desired changes.
Edit ads spreadsheets

You can't 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 applies to 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.

Edit campaign spreadsheets

Certain columns can’t be edited because they’re only used while creating a campaign. Your spreadsheet can include these columns:


  • Campaign (required)
  • Campaign ID (required)
  • Campaign state 
  • Campaign type (can’t edit)
  • Campaign subtype (can’t edit)
  • Ad rotation
  • Start date 
  • End date

Bidding and budget

  • Bid strategy type 
  • Bid strategy
  • Budget
  • Target CPA
  • Target ROAS
  • Target impression share
  • Max. CPC bid limit for target impression share


  • Tracking template 
  • Custom parameter
Edit ad extension spreadsheets

Download ad extension template

  1. Sign in to your Google Ads account.
  2. Click the tools icon  in the top right-hand 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 an ad extension

To add a new ad extension:

  • In the “Campaign” column, type the name of the campaign into which 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:

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

    • App link text: Text that people will click 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 organisation that provided the review.
    • Source URL: The URL where the person or organisation 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 to which 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 that 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, capitalising the first letter of each header. NOTE: Only the headers on our list will be accepted.
    • Structured snippet values: The specific header-related details that 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 on which you want your extension to start showing. This should use a mm/dd/yyyy format. For example, 1 July 2014 would be 07/01/2014.
    • End time: The date on which you want your extension to stop showing. This should use a mm/dd/yyyy format. For example, 1 July 2014 would be 07/01/2014.
    • Device preference: The devices that you want to show your extension on. You can specify all or mobile.
    • Scheduling: The days of the week and times of day that you want your extension to be shown on. You must use the format of Day, start time – end time. For example, if you wanted to schedule from 9.00 a.m. to 5.00 p.m. on Mondays, you'd 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.

Edit product group spreadsheets

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

Edit bid strategy

You can assign existing portfolio bid strategies to your campaigns or edit standard bid strategies.
Assign portfolio bid strategy
  1. Go to the Campaigns page.
  2. Click the download icon Download, and select More optionsat the bottom of the drop-down.
  3. Under 'Include', tick the box forEditable columns for Bulk Upload, and click Download.
  4. Enter the portfolio bid strategy’s name in the 'Bid strategy' column.
    • Leave the 'Bid strategy type' column and other columns such as 'Target CPA' or 'Target ROAS' blank. If you see values in these columns, enter 'remove_value'. This information will be automatically added to your campaign based on the existing bid strategy.
    • If columns like 'Target CPA', 'Target ROAS' or 'Bid strategy type' don’t match with what you’ve set for your existing bid strategy, you’ll receive an upload error.

You can’t edit or create new portfolio bid strategies with the bulk upload spreadsheet.

Edit standard bid strategy

  1. Go to the Campaigns page.
  2. Click the download icon Download, and select More options at the bottom of the drop-down.
  3. Under 'Include', tick the box forEditable columns for Bulk Upload, and click Download.
  4. Edit the 'Bid strategy type' column with the type of bid strategy that you’d like.
  5. Edit any additional columns like 'Target CPA' or 'Target ROAS'.

Edit audiences

You can assign audiences that you’ve created to campaigns or ad groups.

Tip: It’s recommended to download Download an editable report for bulk upload from the Audiences page first.

If you have multiple audiences with the same name, you need to add an 'audience ID' column to differentiate them. You don’t need the 'audience ID' column if you’re editing an audience that’s already associated with a campaign or ad group.

You can edit your bid adjustment by entering a value in the 'bid adjustment' column. All other edits, such as audience name and targeting setting aren't supported.

If you’re adding an audience for the first time, it will use the 'smart default' targeting setting. This option will keep your current audience targeting settings. If you haven’t yet chosen a setting, your targeting will default to the following options based on your campaign type:

  • Observation for Search and Shopping campaigns.
  • Targeting is the default for Video and Display campaigns.

Supported audiences

  • Detailed demographics
  • Affinity
  • In-market
  • Remarketing
  • Similar audiences
  • Customer match

3. Upload spreadsheets and apply changes

Upload from Keywords, Ads, Ad group, Campaigns or Product groups page
  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 that you’d like to make).
  4. Click the 3-dot icon 3 dot icon
  5. Click the Upload icon Import.
  6. Choose the spreadsheet that you want to upload.
  7. Click Open.
  8. Click Preview if you wish to preview the data before uploading.
  9.  Click Apply.
Upload in the Bulk actions section

Here's how to upload your spreadsheet from the 'Bulk actions' section of your account:

  1. Sign in to your Google Ads account.
  2. Click the tools & settings icon .
  3. Under 'Bulk actions', select Uploads.
  4. Click the plus icon .
  5. Under 'Source', you can choose to Upload a file or connect to Google Sheets.
    1. Upload a file: Click Select a file from your computer and add your file.
    2. Google Sheets: Click Link an existing Google Sheet and select a spreadsheet from your Google Drive account.
  6. (Optional) To see any potential issues with uploading your file, click Preview.
  7. Click Apply.
View results of your upload

Once your file has been uploaded, you’ll see a new entry for that file at the top of the table in the Bulk operations section. Applied changes will have a Details link where you can view your past changes. For uploaded spreadsheets that you haven't applied, you can choose to Preview, Apply or Remove.

  • If you upload a spreadsheet with more than 1,000 rows and preview it, all of the rows will be uploaded but you’ll only see the first 1,000 rows in the preview. 
  • You can see all of your changes after you've applied them by downloading the results. 
  • You can only view details of files uploaded over the past 90 days.
  • Your spreadsheet must be 50 MB or less and have one million rows or less.
  • Uploads time out after two hours. If this happens, you’ll need to try again. However, you don’t need to re-upload the entire spreadsheet – only the parts that haven’t been completed.
Bulk create Google Ads accounts from your manager account

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

4. Fix common issues

Identify errors
  1. Click the tools & settings icon in the top right-hand corner of your account.
  2. Under 'Bulk actions', click All bulk actions.
  3. In the row with your report, click Download results to look at the errors within your account.
  4. In the "Results" column in the spreadsheet, you can find the issue with each row, then fix that issue.
  5. Save the file then upload it.

Fix errors

Error Solution
There are conflicting changes. Make sure that no one else is trying to edit your account and try again.
Items in your file don't meet editorial guidelines. Make sure all the items in your file follow Google Ads Editorial guidelines.
Your file is missing a header row. The first row of an uploaded file must be used for headers.
Note: When you download the file from Google Ads, headers are already present.
Column contains the wrong type of information. Please make sure that the information that you entered meets the requirements.
This row is missing a value. Please make sure that you enter a value for all required columns.
Your keywords contain characters that are not allowed. Remove any non-standard characters ( ! @ % , *) from your keywords.
One of the IDs does not exist. If you’re adding an element, remove the value from the ID column. If you’re making changes to an element, make sure that the ID is correct and that the entity hasn't been removed.
If you’re adding an element to an ad group or campaign, please make sure that the campaign or ad group has a valid ID.
To update your data set or feed, you'll need to include an 'Action' column. A column with the header "ACTION" is required for sitelinks and other feed changes via bulk uploads (possible values are "SET", "ADD" or "REMOVE").


Was this helpful?
How can we improve it?

Need more help?

Sign in for additional support options to quickly solve your issue