Facebook Ads Bulk Upload: Methods, Templates and Mistakes

What bulk upload is

Bulk upload means creating or editing many ads from a spreadsheet instead of building each one in the Ads Manager screens. Meta's help page on importing ads in bulk says advertisers can bulk import ads into Ads Manager desktop by uploading an Excel spreadsheet with campaign, ad set and ad information. You can download a template for new ads or export your existing ads as a spreadsheet, and Ads Manager also lets you bulk import images.

Meta describes the feature as ideal for advertisers who manage many objects and run a large number of ads, and for those who prefer to edit ads in Excel. The main gain is that importing lets you fill the spreadsheet with the content you want to publish instead of creating and publishing each ad individually, for example to test several images with the same ad copy.

Meta's native bulk import and export

Ads Manager has two directions, and you will often use both:

• Import: upload a filled spreadsheet to create ads.
• Export: download existing campaigns, ad sets and ads as a spreadsheet. This is the easiest way to copy a setup that already works, edit a few cells and import it back.

Know the limits before you build a large file:

• File size: the import file has a limit of about 2MB.
• Unsupported features: Meta's page on exporting and importing ads with unsupported features says some features may not survive the round trip.
• Template columns: the blank import template does not completely match the columns you see in Ads Manager, and it has fewer columns than an export of existing ads, because new ads have not run yet.

Meta lists specific things that are removed when you export and import: A/B tests on campaigns, offers on ad sets, and tagged business partner Pages on branded content ads. Only the first 10 languages of a multi-language ad are kept, and Advantage+ catalog ads with more than one language keep only the default. If your account uses any of these, plan to re-apply them after the import.

The spreadsheet template, level by level

Instead of memorizing columns, learn the structure the columns follow. Meta's explanation of the advertising levels in Ads Manager shows that ad creation has three levels, and the template carries information for all three. Each row of your sheet describes one ad and the campaign and ad set it belongs to.

Two rules from Meta's documentation make the template easier to fill in. First, all ads in the same ad set share the same audience, placement, budget and schedule, so those cells must match on every row of an ad set. Second, a campaign should represent a single objective, so the objective cell must match on every row of a campaign.

The safest way to learn the exact columns is to download the blank template and an export of one working campaign, and compare them side by side. Because the template does not match the Ads Manager columns completely, trust the template's headers, not your memory of the screen.

Step-by-step upload

1. Plan the structure on paper. Decide how many campaigns, ad sets and ads you need, and the name of each (see the naming section below).
2. Download the template. Get the blank Excel template from Ads Manager, or export a similar campaign to start from a working example.
3. Fill one row per ad. Repeat campaign and ad set values on every row that shares them.
4. Prepare images. Ads Manager can also bulk import images, so gather them before you import.
5. Keep the file under about 2MB. Split a large launch across two files, grouped by campaign.
6. Import the file. Fix any errors Ads Manager reports before moving on.
7. Review the result. Open the imported campaigns and spot-check budgets, audiences, links and creative before you publish.

Start with a small test file of two or three ads. A mistake in a test file costs minutes, and a mistake in a 200-row file can cost a day.

Fix a partial upload

A partial upload is when some rows import and others do not, or when imported ads come in with errors. Work through these in order.

Rows missing or unsupported features

When you export ads that contain unsupported features and choose not to remove them, Meta adds three columns: Export and Import Issue Code, Export and Import Issue, and Export and Import Issue Details. Meta recommends deleting every row that has an issue code before you import, because those rows are the ads with unsupported features. If you delete only the issue code column and keep the rows, you create drafts with errors that cannot be published, or you remove unsupported features from your ads without being notified.

Ads that came in with errors

• Read the error on the draft and correct the matching cell in the sheet, not only in Ads Manager, so your file stays the source of truth.
• Check that values repeated across a campaign or ad set are identical on every row.
• Check whether the ad used a feature from the lists above, such as an offer or a partner tag, and re-apply it by hand.

File too large

If the import fails, check the file size against the 2MB limit and split it by campaign.

After any fix, re-import a small batch first, confirm it is clean, then do the rest.

When to use a bulk launcher instead

Native import is free of any tool fee and works well for repeatable, spreadsheet-friendly launches. A bulk launcher is worth considering when:

• You launch many ads often, and the weekly spreadsheet work adds up.
• Features you rely on do not survive Meta's export and import.
• You want naming and review built into the process rather than done by hand in a cell.

Madgicx's Ad Launcher launches ads in bulk, and Ads Manager 2.0 handles bulk actions on campaigns, ad sets and ads. A bulk launcher in beta builds many ads from a sheet or CSV, with naming templates and edits staged and reviewed before they reach Meta. It's in beta; contact our support team to get beta access.

For a comparison of the options, see our guides to platforms for bulk ad creation on Meta and bulk Facebook ad creation tools.

If you want to compare the native upload with a launcher on a real batch, try Madgicx free for 7 days.

Naming and a checklist for a clean upload

A spreadsheet makes naming easy, because you can build each name from cells. Use a fixed order that includes the objective, the audience, the offer or creative, and the date. For example, a name might read "Sales | Lookalike 1% | Spring offer | 2026-11". The exact scheme matters less than using the same one every time. Our glossary entry on naming conventions covers more.

Before you import, run through this checklist:

• Every campaign has one objective, repeated on all of its rows.
• Every ad set's audience, placements, budget and schedule match across its rows.
• Names follow your convention and contain no stray spaces or typos.
• Links open the right pages and carry your tags.
• Images are ready to import with the sheet.
• The file is under about 2MB.
• You removed rows with an issue code, if you exported from existing ads.
• You tested with a small file first.
• You have a plan to re-apply A/B tests, offers or partner tags if your ads used them.

FAQ