If you're using a custom Excel sheet (an Excel spreadsheet that's not the Ads Manager Excel template), you'll want to make sure that it has the same columns as the Ads Manager Excel template and that you've removed any existing ad IDs from the custom spreadsheet.

To compare your custom Excel sheet to the Ads Manager Excel template:

1. In Ads Manager, click Export & import and select Download template.
2. Compare your custom Excel spreadsheet with the exported Ads Manager Excel template.
• All the columns in the exported Ads Manager Excel template should be in your custom Excel spreadsheet.
• If there are existing ad IDs in your custom Excel spreadsheet, delete them.
3. Save your custom Excel spreadsheet as a Unicode .txt file.
4. Click Export & import and select Import ads in bulk to import your custom Excel spreadsheet back to Ads Manager.

Learn more about using bulk import in Ads Manager.

Troubleshooting

Here are some tips to help you import changes in Ads Manager:

• Best practices for importing in Ads Manager
• Troubleshooting issues with bulk importing new ads using a custom Excel spreadsheet
• Troubleshooting issues with bulk importing new ads into the Ads Manager Excel template

If you're having trouble importing the Ads Manager Excel template into Ads Manager:

• Make sure that all the ad IDs are deleted in your Ads Manager Excel template
• Make sure that you haven't deleted any of the columns from the original Excel template.
• Save the spreadsheet as Unicode .txt file and upload it back to Ads Manager
• If you're still having trouble, try creating the ad directly in the Ads Manager interface. If it publishes successfully, export the ad and use the spreadsheet for any similar ads that you want to create.

Learn more about using bulk import in Ads Manager.

Troubleshooting

Here are some tips to help you import changes in Ads Manager:

• Best practices for importing in Ads Manager
• Troubleshooting issues with bulk importing new ads using a custom Excel spreadsheet
• Troubleshooting issues with bulk importing new ads into the Ads Manager Excel template

If you can't bulk import updates to your existing ads in Ads Manager:

• Make sure that all the columns from the original Ads Manager Excel template are there
• Make sure that you don't delete the ad IDs, as you're editing ads and not creating new ones.
• Save the Excel file as a Unicode .txt file.
• Click Export & import in Ads Manager and select Import ads in bulk to import your Excel template back to Ads Manager.

If you still can't import updates to your existing ads in Ads Manager, file a task by clicking Help on the top right-hand side of Ads Manager and select Report a problem. In the task, include your account ID, .xls or .csv file that you're trying to import (not a .txt file) and, if possible, a video screencast.

Learn more about using bulk import in Ads Manager.

Troubleshooting

Here are some tips to help you import changes in Ads Manager:

• Best practices for importing in Ads Manager
• Troubleshooting issues with bulk import updates to existing ads

The format for "{field}" can't be "{value}". "{field}" must be all numbers after the prefix "{prefix}". Please use the correct "{field}" format and try again.

Why did this happen?

This error occurs when you put a string in an ID field that's not an ID format.

How do I fix it?

When you input a string in an ID field, the ID should be in the following format: "cg:12345", where "cg:" is the prefix and "12345" is the actual ID.

You've entered two different values for "{field}" in rows {first_row} and {second_row}, but they should be the same. Please make sure that they match and try again.

Why did this happen?

This error occurs when the value of two cells that belong to the same ad object do not match.

How do I fix it?

When you enter two rows that represent the same ad object, make sure that they match and have identical data.

You've entered "{value}", which doesn't work for "{field}". Please use one of the following and try again: {values_list}.

Why did this happen?

This error occurs when you have entered a value that doesn't belong in a specific field. For example, if you enter random text in the "Objective" column, instead of the appropriate value from a certain list.

How do I fix it?

When you enter a value in a specific field, make sure that it is the correct value pulled from that particular list.

You must add either a name or ID for your "{object_type}" before you can complete your upload. Please add a name or ID and try again.

Why did this happen?

This error occurs when an ad object does not have an ID or name specified as an identifier in your spreadsheet.

How do I fix it?

When importing a campaign/ad set/ad in Excel, make sure that you include an ID/name as an identifier.

The "{secondary_field}" can't be generated because you're missing the "{required_field}" column. Please add the "{required_field}" column and try again.

Why did this happen?

This error occurs when a required field is missing data. For example, the "Body" column can only be imported when the "Creative Type" column is imported, but the spreadsheet is missing the "Creative Type" column, thus causing an error.

How do I fix it?

When importing a campaign/ad set/ad in Excel, make sure that all required fields have the correct data.

The "{secondary_field}" can't be generated because the "{required_field}" is incorrectly formatted. Please add the "{required_field}" and try again.

Why did this happen?

This error occurs when a required field has incorrect data. For example, the "Body" column will only be imported when the "Creative Type" column is imported, but the "Creative Type" column has an invalid value, thus causing an error.

How do I fix it?

When importing a campaign/ad set/ad in Excel, make sure that all required fields have the correct data.

The ID "{object_id}" doesn't belong to the ad account that you're importing into. You can either remove the row from the spreadsheet and try your upload again, or import it into the correct ad account.

Why did this happen?

This error occurs when the ID that you've provided in your spreadsheet represents an ad object from another ad account.

How do I fix it?

When importing a campaign/ad set/ad in Excel, make sure that the IDs represent the ad objects of your ad account only. There should not be any IDs for other accounts.

The ID "{object_id}" can't be found in your ad account. Please make sure that the ID is correct or remove it and try again.

Why did this happen?

This error occurs when the ID you've provided in your spreadsheet doesn't represent the ad object.

How do I fix it?

When importing a campaign/ad set/ad in Excel, make sure that the IDs are correct and represent the ad objects of your ad account only. They should not be incorrect IDs or IDs for other accounts.

The header label "{header}" doesn't match any column in Power Editor, and any data in that column will be ignored during import. Please correct the header label or remove the column and try again. You can also export the existing ads in your account to see the current available columns.

Why did this happen?

This error occurs when the header label in your spreadsheet is not a valid header.

How do I fix it?

When importing a campaign/ad set/ad in Excel, correct the header label or remove the column. You can also export the latest version to see the current available columns. In the future, make sure that the header label matches the appropriate columns in Ads Manager.