Bulk Import Sheet Builder for Meta Ads (Bulk Upload Template)

How to use the bulk upload template builder for Meta ads

This bulk upload template builder for Meta ads fills Ads Manager's import file from a plain sheet, using the columns and formats on Meta's Columns in the Import/Export Template page. Because Meta changes its template from time to time, the safest way is to load the template you downloaded yourself: the builder keeps its header row exactly and fills in your ads.

1. Write one ad per row. Campaign, ad set, ad name, primary text, headline and website URL are needed. Add any of: description, display link, call to action, URL parameters, image file name, objective, budget, countries, ages, gender and start time.
2. Download your template. In Ads Manager choose Download Excel template and load it as file 2. Without it, the builder uses the column names from Meta's help pages.
3. Set the defaults. Pick an objective and a country for rows that don't have one, your Facebook Page ID, and whether new items start paused.
4. Fix the red rows. Missing headlines, incomplete URLs, unknown countries and impossible age ranges are listed with the fix. Those ads stay out of the file until fixed.
5. Download the Excel file or copy. Both are formats Ads Manager imports.

What the builder fixes and checks

• Names to template columns: Primary text becomes Body, Headline becomes Title, Website URL becomes Link, and labels like "Shop now" become the CTA code SHOP_NOW.
• Formats: budgets without currency symbols and with two decimals, country names turned into ISO codes (Deutschland → DE), start times in Meta's MM/DD/YY HH:MM format, display links without https://, URL parameters without a leading question mark.
• One value per ad set: every row of an ad set gets the same budget, countries, ages and start time. If your sheet disagrees with itself, the first value wins and you see a warning.
• Old IDs: rows that still carry a campaign, ad set or ad ID are left out, because Meta says to delete existing ad IDs when you import new ads.

What to do next in Ads Manager

1. Open Ads Manager on a computer. Bulk import isn't available in the mobile app.
2. Start the import. Below the Campaigns, Ad sets and Ads tabs, choose More > Import ads in bulk. Upload the Excel file, or paste the copied text.
3. Add your images. Upload the image and video files in the same step. Their names must match the Image column exactly.
4. Read the summary. If Meta finds blocking errors, choose View errors in Excel, fix the rows and import again. Delete any row that still has an issue code before you re-import.
5. Review, then publish. Check one ad of each type in the preview, especially placements and the call to action.

Common Meta bulk import errors and fixes

Bulk import fails with a custom Excel sheet

Meta's troubleshooting page for custom sheets gives three fixes: include every template column, delete existing ad IDs, and try another file format. Use the downloaded template as file 2 so every column is there, let the builder drop old IDs, and if it still fails, save the file as Unicode text (.txt) and import that.

Ads were created in new ad sets

Without an Ad Set ID, Meta matches by ad set name and creates a new ad set when the name differs by even one character. Copy names from an export instead of typing them.

Ads imported but don't run

Meta says the campaign, ad set and ad statuses should match. A paused campaign with active ads stays off. The builder writes the same status at every level, and leaves it empty for ad sets with a future start time, as Meta advises.

Drafts full of errors after a re-import

When you fix an error file, delete the rows that have issue codes in column A. Deleting only the issue code column creates drafts that still carry the errors.

Features that don't survive export and import

Reservation campaigns, carousel ads with customized placements and ads with placement asset customization in several languages aren't supported in import files. A/B tests, offers and branded content partner Pages are removed. Build those in Ads Manager.

Learning phase restarts

Changing some fields through an import can restart the learning phase or send ads back to review.