Yahoo! Search Marketing > Yahoo! Search Marketing Help > Sponsored Search > Managing Your Account

The Import subtab below the Campaigns tab allows you to upload a file to create, edit or delete multiple campaigns, ad groups, keywords and ads at once.* We also provide you with a downloadable template file in which to insert your selected campaign information. You can download the template in XML format in an Excel 2003 spreadsheet or you may download the template in CSV format. After you complete the template file, you can upload the information into your account.

Using bulk import allows you to:

• Save time editing the bids, URLs, ad text, and settings for your campaigns.
• Create entirely new campaigns from a file that you upload.
• Import your campaign information to a spreadsheet for reference and archival purposes. With the spreadsheet, you can:

• Update only the columns you select by choosing ‘update: yes’ or ‘update: no’ options from the top row.
• Select column options from cell dropdowns for columns with specific entry options (this feature is only available in the .XML format).
• View tool-tips displaying help text beside each cell in the header row with descriptions of the cell and possible value entries (this feature is only available in the .XML format).
• View an ‘in-sheet’ error message if your spreadsheet cannot be validated and requires change (this feature is only available in the .XML format).

View additional information about bulk importing your campaigns, including common errors, tips and tricks.

Large Downloads

Some programs supporting CSV formats may limit the amount of rows in your spreadsheet. If you have a large Yahoo! Search Marketing account, your template file may exceed this limit. In order to view your full account download you can:

• Use the latest import template in .XML format for Microsoft 2003 so the additional campaign information for each campaign past Microsoft Excel 2003’s 65,536 row limitation is automatically displayed onto multiple tabs at the bottom of your spreadsheet.
• Use a third party text editor, such as TextPad®, to view additional rows if you are using an older import template (see note below) or downloading your campaigns in .CSV format.

Instructions for placing an oversized bulksheet file onto multiple tabs follow:

Note: You must have Textpad®, a third-party text editor, installed to complete the process below. For more information and to download this program, visit http://www.textpad.com/download/index.html.

To place an oversized download file onto multiple tabs in your spreadsheet program:

1. Open a blank workbook.
2. Download the campaign(s) of your choice by clicking the “Download Campaign” button and saving the file(s) to your desktop.
3. Unzip/extract the saved file(s) to your desktop.
4. Right click the unzipped spreadsheet file and select “Textpad”.
5. Wait for the file to open up in Textpad® completely.
6. Press Ctrl+Q, L on your keyboard to turn on the line number feature in Textpad®.
7. Starting from the top of the file, scroll all the way down until you reach Row 50,000.
8. Press Ctrl+Shift+Home on your keyboard to select the first 50,000 rows of the file.
9. Press Ctrl+X to cut the rows, then paste them in the first tab of the blank workbook.
10. Repeat Steps 7 to 9 as needed, pasting no more than 50,000 rows on a new tab each time.
11. Save the file with a new name.

*The Import sub-link will only appear if the Import Campaign feature is supported by your account.

Note: Older template files may still be used to import your campaign data; however, newer template features and data columns will not display in older templates.

Import Campaign Spreadsheet

The columns that appear in the template file are explained in the chart below:

Next: Creating and Working with Campaigns – The Campaign Details Page