How to create ads with the Bulk Import feature using a blank template

Last updated: September 2024

The Bulk Import feature allows you to create ads by uploading a CSV or Excel file with your campaign, ad group, and ad data to TikTok Ads Manager. To create ads in bulk using a blank template, you will need to download a blank template and then enter the settings you want to use for your campaign, ad groups, and ads.

Below is an overview of the headers and fields included in the blank Excel and CSV (UTF-8) templates: Excel template - recommended file type

  • First row:

    • These are the headers and fields related to ad creation.

    • To pull up the formatting and input required for each column, hover your mouse over the red triangle to pull up a comment explaining them.

  • Second row:

    • This is where you will enter the data that relates to the column.

    • Some cells can be filled in with a drop-down menu, others require that input be typed in, and some require a specific numerical ID.

      • Note: You will need to export an existing ad to obtain a list of the reference IDs.

CSV Template - recommended file type for Chinese and Japanese languages

  • First row：

    • The columns in the first row will be in the language that is consistent with the current language selection on TikTok Ads Manager.

  • Second row：

    • A description of the input requirements for each column will be found in the second row.


  1. Go to Ads Manager.

  2. Go to the Campaign tab.

  3. Click Bulk Import & Export.

  4. Click Import Ads.

  5. Choose your type of template.

    1. Click the XLSX Template button to download an Excel template.

    2. Click the CSV Template (UTF-8) hyperlink to download a CSV.

    3. Template description：

      • File format: CSV UTF8 or Excel

      • Template function: Used to batch import ads to TikTok Ads Manager

      • File name: Blank templates use the following naming convention by default: BulkImportTemplate + account name + File download time

      • Language: It is consistent with the logic of the CSV template file

  6. Edit the ad information.

    1. Note: Leave the Campaign Id, Ad Group Id, and Ad Id fields blank. The system will add this information later.

  7. Save the Template file.

  8. Go to the Campaign tab.

  9. Click the Bulk Import & Export icon.

  10. Select Import.

  11. Go to the Campaign tab.

  12. Confirm ads are correct, and enable them.

If your spreadsheet fails to import correctly, you will receive a notification on the Import Ads pop-up. After you fix the errors, save your edits and then re-upload your file. Note: If any field does not comply with the required format, the entire file will fail to upload. To learn more, visit How to Create Ads Using a Reference File.