Meta Ads bulk upload: create many ads from one spreadsheet
Short answer On a computer, export one ad you built by hand in Meta Ads Manager as .xlsx. Copy its row once per new ad, clear the ID columns, and change the text, image name or audience. Choose Import ads in bulk and add the images. Ads arrive as drafts until you publish. Meta warns that too many ads hurt results.
Want help applying this to your business? Talk it through on a free 30-minute call.
Book a callHow to bulk upload ads to Meta, step by step
Start from an ad you already built, not a blank sheet. A Meta ad has three levels: the campaign (the goal), the ad set (audience, budget, schedule) and the ad (text, image, link). The import file holds all three, one row per ad. Meta's own fix for a failing import points the same way:
"If you're still having trouble, try creating the ad directly in Ads Manager. If it publishes successfully, export the ad and use the spreadsheet for any similar ads you want to create." (Meta Business Help: Troubleshoot bulk import issues when using an Excel template)
| Step | What you do in Ads Manager, on a computer |
|---|---|
| 1. Build one model ad | Set it up by hand. An unpublished draft can be exported too |
| 2. Export it | Tick its box, then Export, Export selected, Export as .xlsx |
| 3. Copy the row | Paste one copy per new ad |
| 4. Clear the IDs | Empty Ad ID on every new row. For a new ad set or campaign, empty its ID and give it a new name |
| 5. Change what differs | Ad name, text, headline, image file name, link, audience or budget |
| 6. Import | More (or Export & import), then Import ads in bulk. Add the file, images and videos |
| 7. Review and publish | Fix errors, tick the new drafts, click Publish |
The limits Meta lists:
- Computer only: the feature "is only available on your computer" (Meta Business Help: Import ads to Meta Ads Manager).
- File: about 2 MB.
- Images: one by one or in a zip file, each named exactly as in the Image column.
- Videos: up to 10 per import, 10 MB each.
- Caps: 50 ads per ad set; 5,000 ads per regular ad account. A Facebook Page that spent under US$100,000 in its highest month can have 250 ads running or in review, counted across every ad account using that Page, in the US and Canada alike.
Do you need bulk upload at all?
For a business running a few campaigns, usually not. Meta warns against volume itself:
"When an advertiser runs too many ads at once, each ad delivers less often. This means that fewer ads exit the learning phase, and more budget is spent before the delivery system can optimize performance." (Meta Business Help: About managing ad volume)
The learning phase is the stretch after a new ad set or big edit while Meta works out whom to show it to. It usually ends "after about 50 results in the week after the ad set's last significant edit" (Meta Business Help: About the learning phase). A small budget split across 20 ad sets may never get there.
Pick the lightest tool that does the job:
| You want to | Simplest way | Spreadsheet? |
|---|---|---|
| Try several photos or videos | One ad holding up to 10; Meta's flexible format picks what to show (Traffic, Engagement, Sales and App promotion goals) | No |
| Try several headlines or texts | Multiple text options in one ad | No |
| Compare two versions fairly | Meta's A/B test tool | No |
| Make a few copies of a campaign or ad set | Duplicate, then set Number of copies | No |
| Copy ads into another ad account | Export, clear the IDs, import | Yes |
| Make one change on dozens of ads (link, tracking tags, offer) | Export, edit, import | Yes |
| Launch many ads that each need their own link, area or budget | Export one, copy rows, import | Yes |
On testing, Meta says: "We do not recommend testing informally, such as by turning ad sets or campaigns on and off manually." Its A/B test shows each version to a separate group, "ensuring nobody sees both" (Meta Business Help: About A/B testing for Meta Ads). Set tests up after importing: an import removes them.
Filling in the spreadsheet
The column names don't match the labels in Ads Manager. The ones owners change most:
| In Ads Manager | Spreadsheet column | Format Meta asks for |
|---|---|---|
| Text (primary text) | Body | Plain text |
| Headline | Title | Plain text |
| Website URL | Link | A complete web address |
| Image | Image | The exact file name, such as spring-cleanup.jpg |
| Call to action | Call to Action | A code, such as LEARN_MORE or SIGN_UP |
| Tracking tags | URL Tags | key1=value1&key2=value2 |
| Country | Countries | Two-letter code: US or CA |
| Daily budget | Ad Set Daily Budget | A number like 20.00; no currency symbol needed |
Three rules cause most surprises:
- Names create new things. With no ID, Meta matches by name, and "If we can't find the ad set name, we'll create a new ad set ID with the specified name" (Meta Business Help: Columns in the import/export template). One typo can mean an extra ad set with its own budget.
- Statuses must agree. An active ad inside a paused ad set won't run.
- Text starting with +, -, = or @ gets a marker of two angle brackets in the export. Leave it; Meta removes it on import.
Importing, adding media, publishing
- On the Campaigns, Ad sets or Ads tab, click More, then Import ads in bulk (some accounts show Export & import instead).
- Choose your file, or paste the rows as text.
- Under Images, add the images or one zip file.
- For video, type each file name (such as clinic-tour.mp4) in the Video file name column, then upload the videos in the Videos section.
- Click Import. A summary lists warnings and blocking errors; View errors in Excel says what's wrong and how to fix it.
- Click Review and publish, tick the drafts and click Publish.
Imported ads stay drafts until step 6. Then, like any ad, Meta reviews them against its Advertising Standards before they run.
What an import strips out
Some settings don't survive the spreadsheet (Meta Business Help: Exporting and importing ads with unsupported features):
| Setting | What happens |
|---|---|
| A/B tests, ad set offers, branded content partner tags | Removed |
| Multiple text options for all placements | Extra options removed |
| Over 10 Advantage+ creative text options, or over 10 languages | First 10 kept |
| Reservation campaigns, carousels with customized placements | Drafts with errors that can't be published |
Meta flags these in issue-code columns on export and recommends deleting those rows before importing. It notes the lists change. If your model ad used multiple text options, add them back in Ads Manager afterward.
Why an import fails, and the fix
| Problem | Fix, from Meta's troubleshooting pages |
|---|---|
| New rows still carry ad IDs | Delete the IDs |
| Columns deleted, or a homemade sheet | Keep every column of Meta's template; compare with Download Excel template |
| Edits to live ads won't apply | Keep the ad IDs: you're editing, not creating |
| Errors you can't trace | Save the sheet as a Unicode .txt file and import that |
| Still failing | Build the ad by hand, export it, use that file as the model |
Editing live ads this way has a cost:
"Note: editing certain details of your campaign, ad set or ad may restart the learning phase or cause the ad review system to re-review your ad." (Meta Business Help: Edit ads in Meta Ads Manager using Excel)
What it costs, and the other routes
The import is part of Ads Manager; none of Meta's help pages for it mention a fee. You pay for the ads that run (what Meta ads cost).
- Meta's Ads AI connectors, announced in open beta on April 29, 2026, let an AI assistant "Create and edit ads, ad sets, and campaigns using natural language" (Meta for Business: Introducing Meta Ads AI Connectors). Developers can use Meta's Marketing API.
- Not Meta Ads Manager for Excel. Despite the name, Meta says that add-in "is for ad performance reports."
Example
Illustrative cases with invented numbers.
A house cleaner testing photos (US dollars)
She has six before-and-after photos, $20 a day and a Traffic campaign pointing to her booking page. She puts all six in one flexible ad. No import needed.
A physiotherapy clinic with three locations (Canadian dollars)
Each clinic has its own booking page. The owner builds and publishes the first location's ad set by hand, then exports it. She copies the row twice, changes the ad set name, area, link and budget (15.00), keeps the Campaign ID and clears the other IDs. One import adds two ad sets to the same campaign: C$45 a day in total.
FAQ
Can I bulk upload Meta ads from my phone?
No. Meta says the import "is only available on your computer."
Do imported ads go live right away?
No. They arrive as drafts. You click Review and publish, then Publish; Meta reviews them before they run.
How many ads can one import hold?
About 2 MB of spreadsheet and up to 10 videos. Meta's caps still apply: 50 ads per ad set, 250 live or in review per small Page.
Why can't I find Import ads in bulk?
Use a computer and look under More, or Export & import. New ad accounts may lack some features; Business Support Home shows yours.
Can I use a CSV file instead of Excel?
Yes. Ads Manager exports .csv, .xlsx or text, and Meta's troubleshooting pages refer to importing .xls and .csv files. Keep Meta's columns either way.
Different for you?
- You'd rather let Meta mix images and text for you: Meta Advantage+ for a local business.
- Your ads are about housing, jobs, credit or insurance: Meta special ad categories.
- You're still deciding what to run: Facebook ads for a local service business.
- You only boost posts today: boost post or Ads Manager.
- You'd rather have ads built, tested and trimmed for you: Paid Ads Agent.