Products SEO & GEO Agent Paid Ads Agent Website Agent Conversion Agent
How it works Pricing FAQ Blog Book a call

Meta Ads bulk upload: create many ads from one spreadsheet

Updated · 8 min read

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 call

How 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)
StepWhat you do in Ads Manager, on a computer
1. Build one model adSet it up by hand. An unpublished draft can be exported too
2. Export itTick its box, then Export, Export selected, Export as .xlsx
3. Copy the rowPaste one copy per new ad
4. Clear the IDsEmpty 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 differsAd name, text, headline, image file name, link, audience or budget
6. ImportMore (or Export & import), then Import ads in bulk. Add the file, images and videos
7. Review and publishFix 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 toSimplest waySpreadsheet?
Try several photos or videosOne 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 textsMultiple text options in one adNo
Compare two versions fairlyMeta's A/B test toolNo
Make a few copies of a campaign or ad setDuplicate, then set Number of copiesNo
Copy ads into another ad accountExport, clear the IDs, importYes
Make one change on dozens of ads (link, tracking tags, offer)Export, edit, importYes
Launch many ads that each need their own link, area or budgetExport one, copy rows, importYes

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 ManagerSpreadsheet columnFormat Meta asks for
Text (primary text)BodyPlain text
HeadlineTitlePlain text
Website URLLinkA complete web address
ImageImageThe exact file name, such as spring-cleanup.jpg
Call to actionCall to ActionA code, such as LEARN_MORE or SIGN_UP
Tracking tagsURL Tagskey1=value1&key2=value2
CountryCountriesTwo-letter code: US or CA
Daily budgetAd Set Daily BudgetA 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

  1. On the Campaigns, Ad sets or Ads tab, click More, then Import ads in bulk (some accounts show Export & import instead).
  2. Choose your file, or paste the rows as text.
  3. Under Images, add the images or one zip file.
  4. 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.
  5. Click Import. A summary lists warnings and blocking errors; View errors in Excel says what's wrong and how to fix it.
  6. 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):

SettingWhat happens
A/B tests, ad set offers, branded content partner tagsRemoved
Multiple text options for all placementsExtra options removed
Over 10 Advantage+ creative text options, or over 10 languagesFirst 10 kept
Reservation campaigns, carousels with customized placementsDrafts 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

ProblemFix, from Meta's troubleshooting pages
New rows still carry ad IDsDelete the IDs
Columns deleted, or a homemade sheetKeep every column of Meta's template; compare with Download Excel template
Edits to live ads won't applyKeep the ad IDs: you're editing, not creating
Errors you can't traceSave the sheet as a Unicode .txt file and import that
Still failingBuild 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?

Keep learning

NextAds in AI search: which AI answers show ads, and how to buy themWhich AI assistants sell ads today (Google AI Overviews, Copilot, ChatGPT), which sell none, and how to buy each from the US or Canada.

Ask us one question

One line is enough. We reply by email.

Sources

  1. Meta Business Help: How to bulk upload and import ads in Meta Ads Manager
  2. Meta Business Help: Import ads to Meta Ads Manager
  3. Meta Business Help: Create a new ad in Excel in Meta Ads Manager
  4. Meta Business Help: Export ads in Meta Ads Manager
  5. Meta Business Help: Download the import template for Meta Ads Manager
  6. Meta Business Help: Columns in the import/export template in Meta Ads Manager
  7. Meta Business Help: Differences between Ads Manager field names and spreadsheet column names
  8. Meta Business Help: Bulk import video ads in Meta Ads Manager
  9. Meta Business Help: Exporting and importing ads with unsupported features
  10. Meta Business Help: Troubleshoot bulk import issues when using an Excel template
  11. Meta Business Help: Troubleshoot bulk import issues when using a custom Excel sheet
  12. Meta Business Help: Troubleshoot issues when bulk importing updates to existing ads
  13. Meta Business Help: Edit ads in Meta Ads Manager using Excel
  14. Meta Business Help: Copy an ad from one account to another in Meta Ads Manager
  15. Meta Business Help: How to duplicate ad campaigns in Meta Ads Manager
  16. Meta Business Help: About managing ad volume
  17. Meta Business Help: About the learning phase for ad sets
  18. Meta Business Help: Ad limits per Page
  19. Meta Business Help: Campaign, ad set and ad limits per ad account
  20. Meta Business Help: About the flexible ad format
  21. Meta Business Help: About A/B testing for Meta Ads
  22. Meta Business Help: About Meta Ads Manager for Excel
  23. Meta for Business: Introducing Meta Ads AI Connectors (April 29, 2026)