Importing and exporting with Microsoft Advertising Editor

Use Microsoft Advertising Editor to quickly:

  • Import data from other online advertising programs. Get Microsoft Advertising campaigns up and running quickly by importing accounts, campaigns, and ads from Google, Yahoo, or other platforms into Microsoft Advertising Editor.
  • Bulk-edit Microsoft Advertising data in a spreadsheet. If you prefer to edit data in a Microsoft Excel spreadsheet, export it as a comma-separated values (CSV) file, edit it in Excel, and then import the data into Microsoft Advertising Editor.
  • Base a new campaign on an existing one. To create a new campaign from an existing campaign, export the campaign, change the campaign name, edit the data, and then import the new campaign into Microsoft Advertising Editor. You can also do this with ad groups, but be sure to change the ad group name.
Notes
  • The file must be an Excel or CSV file and must be closed before you try to import it.
  • If you are importing location targets, see this article for information on how to find location IDs.
How do I import campaigns from Google Ads?expando image

Using your Google Ads account credentials and the Google API, Microsoft Advertising Editor can retrieve all of your Google Ads campaign data, letting you skip the spreadsheets.

Import Google Ads campaign data with your Google credentials

To import your Google Ads campaign data into Microsoft Advertising Editor, you have the option of using smart import, which requires three easy steps: Sign in to Google, choose your accounts, and start your import.

  1. In the toolbar, select Import > Import from Google Ads.
  2. If you haven't already, select Import from Google Ads campaign data directly from your Google account > Sign in to Google.
  3. Sign in to your Google account that has access to your campaigns and ad groups.
  4. After successfully signing in, select Continue.
  5. Under Choose accounts, choose one account. Note: Choose one account at a time for a seamless experience.
  6. If the account uses a different currency in Google Ads than what you want for Microsoft Advertising, select either Convert to my Microsoft Advertising currency upon import for automized currency conversion or Don’t convert. I’ll manually adjust my bids and budgets to convert the currency yourself.
  7. Select Next.
  8. In the Start your import window, name your import, set your schedule, and choose whether you want to receive email notifications.
  9. Select Start import or select Advanced import, if you would like to manage more options within the import process.
    1. If you opt for Advanced import, you may choose to Import all existing and new campaigns or Import specific campaigns and ad groups.
    2. Under Choose which items to import and the options to set for them, there are more advanced options, such as Campaign targets, UET tags, and Bids and budgets.
    3. Select Next and then you will be sent to the Set schedule window.
    4. Select Save or select the Run import now checkbox > Start import.
  10. Once the import process is complete, you will see the Import summary, where you can select Synced items and Skipped items within Microsoft Advertising Editor or you can select Download errors to a spreadsheet to see the same data on a spreadsheet.
Things to note:
  • Unmatched columns will not be imported.
  • You can optionally edit destination URLs and choose to share identical sets of ad extensions between campaigns.
How do I update my Google Ads import settings?expando image

You can determine default import settings in Microsoft Advertising Editor to upload your Google Ads campaign data directly to Microsoft Advertising , with no additional work from you.

For Windows:

  1. Select Tools in the menu bar > Options.
  2. Select the Defaults tab.
  3. Choose the Google import setting that you want to use.
  4. Select OK.

For Mac:

  1. Select Microsoft Advertising Editor in the menu bar > Preferences.
  2. Select the Defaults tab.
  3. Choose the Google import setting that you want to use.
  4. Select OK.
How do I import campaigns from a file?expando image

There are three ways to import campaign data with a file:

  • Create a new file using a Microsoft Advertising template.
  • Export data from Microsoft Advertising Editor, make changes, and import the file back in to Microsoft Advertising Editor.
  • Export data from Google Ads, make changes, and import file back in to Microsoft Advertising Editor.

Campaign data can be imported in .csv, .txt, .tsv, .xls, or .xlsx files.

Create a new file using a Microsoft Advertising template and import the file back

  1. Download the template from Microsoft Advertising. The template contains examples for your reference. Replace the data in the template with your campaign data.
  2. Select File and thenSave as.
  3. Type a name for the import template. Use quotation marks around the name and include .csv at the end. For example, "YourFileName.csv". The quotation marks will not appear in your final file name but are used to prevent Excel from adding ".txt".
  4. Select Unicode Text, and then click Save.
  5. Click Import from the toolbar and select Import from a file.
  6. Select the previously saved file and click OK.
  7. Use the drop-down lists to adjust any Microsoft Advertising column headings to match those in your import file, then click Next.
  8. Review the default settings and click Next.
  9. Review the Import summary to see what entities were newly added, updated or couldn't be imported (skipped).
  10. If you want to review the details of the campaigns and make changes, click the link next to Download the details.
Things to note:
  • Unmatched columns will not be imported.
  • You can optionally edit destination URLs and choose to share identical sets of ad extensions between campaigns.
  • For details on how to add location targets, see How do I add a location target?
Notes
  • Dynamic search ads are available in Albania, Andorra, Argentina, Aruba, Australia, Austria, Bahamas, Bangladesh, Belgium, Bolivia, Bosnia and Herzegovina, Brazil, Brunei, Bulgaria, Canada, Cayman Islands, Chile, Colombia, Costa Rica, Croatia, Cyprus, Czech Republic, Denmark, Dominica, Dominican Republic, Ecuador, El Salvador, Estonia, Fiji, Finland, France, French Guiana, French Polynesia, Germany, Greece, Guam, Guatemala, Guyana, Haiti, Honduras, Hungary, Iceland, India, Indonesia, Ireland, Italy, Latvia, Liechtenstein, Lithuania, Luxembourg, Malaysia, Maldives, Malta, Martinique, Mexico, Monaco, Mongolia, Montenegro, Montserrat, Nepal, Netherlands, New Caledonia, New Zealand, North Macedonia, Norway, Panama, Paraguay, Papua New Guinea, Peru, Philippines, Poland, Portugal, Puerto Rico, Romania, San Marino, Serbia, Singapore, Slovakia, Slovenia, South Africa, Spain, Sri Lanka, Sweden, Switzerland, Thailand, Trinidad and Tobago, Turkey, Vatican City, Vietnam, United Kingdom, United States, Uruguay, and Venezuela.
  • Microsoft Shopping Campaigns and product ads are available in Albania, Andorra, Argentina, Aruba, Australia, Austria, Bahamas, Bangladesh, Belgium, Bolivia, Bosnia and Herzegovina, Brazil, Brunei, Bulgaria, Canada, Cayman Islands, Chile, Colombia, Costa Rica, Croatia, Cyprus, Czech Republic, Denmark, Dominica, Dominican Republic, Ecuador, El Salvador, Estonia, Finland, Fiji, France, French Guiana, French Polynesia, Germany, Greece, Guam, Guatemala, Guyana, Haiti, Honduras, Hungary, Iceland, India, Ireland, Italy, Latvia, Liechtenstein, Lithuania, Luxembourg, Maldives, Malta, Martinique, Mexico, Monaco, Mongolia, Montenegro, Montserrat, Nepal, Netherlands, New Caledonia, North Macedonia, Norway, Panama, Papua New Guinea, Paraguay, Peru, Poland, Portugal, Puerto Rico, Romania, San Marino, Serbia, South Africa, Slovakia, Slovenia, Spain, Sri Lanka, Sweden, Switzerland, Trinidad and Tobago, Turkey, the United Kingdom, the United States, Uruguay, Vatican City, and Venezuela.
Export data from Microsoft Advertising Editor and import the file backexpando image
  1. Select the campaigns or ad groups from the tree view in the left pane that you want to edit and import back.
  2. Click Export from the toolbar and select Export selected campaigns and ad grous.
  3. After making necessary changes to the exported file, save the file.
  4. Click Import from the toolbar and select Import from a file.
  5. Select the previously saved file and click OK.
  6. Use the drop-down lists to adjust any Microsoft Advertising column headings to match those in your import file, then click Next.
  7. Review the Import summary to see what entities were newly added, updated or couldn't be imported (skipped).
  8. If you want to review the details of the campaigns and make changes, click the link next to Download the details.
Things to note:
  • Unmatched columns will not be imported.
  • You can optionally edit destination URLs and choose to share identical sets of ad extensions between campaigns.
Export data from Google Ads Editor and import the file backexpando image
  1. Sign in to your Google Ads Editor account.
  2. Select the campaign or ad group you want to export.
  3. Under the Account menu, select Export > Export the selected campaigns and ad groups.
  4. Save the CSV file.
  5. Make any necessary changes and save the file.
  6. In Microsoft Advertising Editor, select Import from the toolbar > Import from Google.
  7. Select the previously saved file > OK.
  8. Use the dropdown lists to adjust any Microsoft Advertising column headings to match those in your import file
  9. Select Next.
  10. Review the Import summary to see what entities were newly added, updated, or couldn't be imported (skipped).
  11. If you want to review the details of the campaigns and make changes, select the link next to Download the details.
Things to note:
  • Unmatched columns will not be imported.
  • You can optionally edit destination URLs and choose to share identical sets of ad extensions between campaigns.
How to preview my campaigns before posting them to Microsoft Advertisingexpando image

Let’s say you’re ready to import your Google Ads campaign data, but want to preview it before posting directly to Microsoft Advertising. You can do so by modifying your Google Ads import settings.

  1. From the top of the page, click Tools and select Options.
  2. Click Defaults.
  3. Under Google Ads import settings select Download locally.
  4. Click OK.

See more videos...