Bulk TikTok Ads from Spreadsheet

TikTok's Bulk Import feature lets you build entire campaign structures in a spreadsheet. No clicking through Ads Manager one ad at a time. Get the file right and you can push dozens of campaigns in a single upload.

What is TikTok Bulk Import?

Bulk Import is TikTok Ads Manager's native tool for creating and managing campaigns, ad groups, and ads from a single CSV or Excel file. Per TikTok's Ads Manager documentation, it supports four use cases: creating new ads, editing existing ads, copying campaigns with modified settings, and adding new creative to existing ad groups.

How bulk import saves time

Manual campaign creation is slow. Each campaign, ad group, and ad requires separate form submissions inside Ads Manager. Bulk Import collapses all of that into one file upload. For advertisers running 10, 20, or 50 ad variations, the time difference is significant.

Supported file formats and limits

TikTok accepts two formats: CSV (UTF-8 encoding) or Excel (2016 or later). Keep your file under 2MB. TikTok recommends no more than 500 rows per import for best results.

---

Preparing Your Spreadsheet

Get the structure right before you upload anything. A poorly formatted file fails on upload or throws row-level errors that are hard to trace.

Campaign, ad group, and ad structure

Your spreadsheet maps to TikTok's three-tier hierarchy: campaigns, ad groups, and ads. Each row represents one entity. Campaigns contain ad groups. Ad groups contain ads. Keep that parent-child relationship intact across rows.

Required vs. optional fields

Not every column is mandatory. TikTok's template marks required fields clearly. Campaigns need at minimum a name, objective, and budget. Ad groups need targeting settings and placement. Ads need creative assets and copy.

Optional fields can stay blank. Blank required fields will fail the import and flag the affected rows.

File format best practices

Use CSV UTF-8 specifically. Other encodings cause import failures. If you work in Excel, save as Excel 2016+ format. Never delete or rename a header in the template. TikTok's parser depends on exact column names. Any edit to a header breaks the file entirely.

---

Step-by-Step: Creating Your Bulk Import File

Two methods work. Pick the one that fits your situation.

Method 1: Using a reference file (existing campaign)

This is the faster path when you already have live campaigns.

1. Go to TikTok Ads Manager. Open an existing campaign.
2. Select the campaigns, ad groups, or ads you want to duplicate.
3. Export them using the Bulk Export option. TikTok generates a CSV with all your settings pre-populated.
4. Open the file. Duplicate the rows you want to replicate.
5. Edit the fields that need to change. New names, budgets, targeting, creative references.
6. Delete the Campaign ID, Ad Group ID, and Ad ID values from any rows you want created as new items. TikTok uses those IDs to decide whether it's updating an existing item or creating a new one. Empty ID fields signal "create new."
7. Save as CSV UTF-8.

Method 2: Using a blank template

Use this when you're building campaigns from scratch.

1. In TikTok Ads Manager, navigate to Bulk Import.
2. Download the blank template. The filename follows the pattern: BulkImportTemplate + your account name + download time.
3. Open the template. Do not touch the headers.
4. Fill in each required column row by row. One row per entity.
5. Leave optional columns blank if not needed.
6. Save as CSV UTF-8.

Formatting and validation tips

Check these before uploading:

• No merged cells anywhere in the file
• No formulas. Paste values only.
• Dates in the exact format TikTok specifies in the template column header
• Budget values as plain numbers, not formatted currency (no dollar signs or commas)
• Creative asset references must match filenames exactly if you're uploading video files separately

---

Uploading and Importing Your Campaigns

Once the file is ready, uploading takes under two minutes.

Navigate to Bulk Import in Ads Manager

Log into TikTok Ads Manager. Go to the Campaign tab. Find the Bulk Import option in the top-right toolbar area of the campaign list view.

Upload your file

Click Bulk Import. Select your CSV or Excel file. TikTok validates the file on upload. If validation fails, it surfaces which rows have errors. Fix those rows and re-upload.

Review and enable campaigns

After a successful import, your campaigns appear in the Campaign tab in draft or pending status. Review them before enabling. Check budgets, targeting, and creative assignments. Enable the campaigns that look correct.

---

Troubleshooting Common Import Errors

Most import failures trace back to three causes.

File format issues

TikTok only accepts CSV UTF-8 or Excel 2016+. Windows often saves CSV files in ANSI encoding by default. That causes import failures. Re-save explicitly as UTF-8 in your spreadsheet software. File size over 2MB also blocks the upload. Trim your file or split into multiple smaller imports.

Missing required fields

If a required field is blank, TikTok flags that row with an error. The message usually names the column. Check the template's field guide to confirm which fields are mandatory for campaigns vs. ad groups vs. ads. They differ by entity type.

ID validation errors

If you left Campaign IDs or Ad Group IDs in rows intended as new items, TikTok will try to update existing campaigns using those IDs. If the IDs don't exist in your account, the import fails. Remove the ID values from new-item rows completely.

---

Why Creative Quality Matters in Bulk Campaigns

Bulk Import solves the structural problem. The creative problem is separate and just as important.

Generating diverse creatives at scale

Running 50 ad variations with the same video produces diminishing returns fast. TikTok's algorithm rewards variety. Different hooks. Different visual treatments. Different durations.

Per TikTok's video ad specifications, in-feed video ads should use 9:16 vertical format at a minimum resolution of 540 × 960 px. Duration should fall between 5 and 60 seconds. MP4 and MOV are the primary supported formats, with a 500MB file size cap per video.

Scale means nothing if every ad looks the same.

How AI tools accelerate bulk ad prep

Generating 30 unique ad creatives by hand takes days. AI generation tools cut that to hours. The key is having assets already sized and formatted for TikTok's specs before you build your import file. That removes a full revision cycle from the workflow.

---

Speed Up Bulk Campaign Setup with Coinis

Generate campaign-ready assets and copy in minutes

Building a bulk import file assumes you have creatives ready. That's almost always the bottleneck.

Coinis Bulk Launcher runs 3 to 20 campaigns simultaneously, generating diverse AI creatives and on-brand copy for each. You set the parameters. Coinis handles the creative variation.

Coinis publishes directly to Meta today (Facebook and Instagram). TikTok direct publishing is on the roadmap. But you can use Coinis now to generate, iterate, and finalize all your creative assets before dropping them into your TikTok bulk import file.

The workflow looks like this:

1. Use the Coinis Image Ads or UGC Style workflow to generate 10, 20, or 30 creative variants from your product URL.
2. Use AI Copywriting to generate captions and headlines that fit TikTok's character limits.
3. Use Coinis Revise to Smart Resize creatives to 9:16 and refine copy.
4. Export the assets. Reference them in your TikTok bulk import spreadsheet.

Brand Profile powers the whole process. Coinis learns your brand voice and visual style once. Every creative it generates stays consistent across every ad in the batch.

Bulk campaigns move fast when the creative pipeline is ready before you open the spreadsheet.

Or let Coinis do it.

From a product URL to a live Meta campaign. AI-generated creatives. On-brand copy. Direct publish to Facebook and Instagram. Real performance reporting. All in one platform.

Start free. Upgrade when you're ready.

Start free →

15 AI tokens a month. No credit card.