Import posts in bulk from a CSV

Schedule many posts at once from a CSV, TSV or published Google Sheet, check every row before import, and roll back the batch.

Import up to 5,000 rows at a time. Each valid row becomes one scheduled post.

Steps

  1. Step 1: Open the importer

    On Posts, click Import Post, or go straight to the importer.

  2. Step 2: Get the template

    Under Columns, click Download template for a file with every column filled in as an example.

  3. Step 3: Choose a source

    Click Upload a file and drop a .csv or .tsv (up to 10 MB), or click Google Sheets link and paste the link of a tab published as CSV (File → Share → Publish to web).

  4. Step 4: Set default accounts

    Use Accounts for rows without any to pick the accounts for rows whose accounts cell is empty.

  5. Step 5: Validate and import

    Click Validate file (or Validate sheet). Fix any rows with errors in your file and validate again; nothing imports while a row has errors. Then click Import to schedule the posts.

Columns

  • content: the post text.
  • schedule_at: ISO 8601, or YYYY-MM-DD HH:mm read in your brand time zone. It must be in the future.
  • accounts: account ids or network names, comma separated. A network name picks every connected account on it.
  • labels: tag names or ids, comma separated.
  • media_url: image or video URLs, or media library ids, comma separated.
  • content_type: post (the default) or thread. Split thread parts with || or a line with only ---, up to 25 parts.
  • repeat: for example every 2 weeks x4 or weekly x6. The count is the total number of posts.
  • caption_<network>: a caption for one network only, for example caption_twitter.

Common errors

  • schedule_at is required or is in the past: every row needs a future date and time.
  • At least one account is required: fill the accounts column or set Accounts for rows without any.
  • Unknown label: create the tag first, or fix its spelling.
  • No connected … accounts in this workspace: the row names a network with no account connected in this brand.

Tips

  • After the import, Roll back import deletes the whole batch until any of its posts publishes.
  • If your brand requires approval, the imported posts wait for review before anything publishes.
  • Export files from several other schedulers work as they are.

Still stuck?

Open a ticket and someone who builds the product answers in writing.

Signed in? Open a ticket from the dashboard.

Contact Us