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
Step 1: Open the importer
On Posts, click Import Post, or go straight to the importer.
Step 2: Get the template
Under Columns, click Download template for a file with every column filled in as an example.
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).
Step 4: Set default accounts
Use Accounts for rows without any to pick the accounts for rows whose
accountscell is empty.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, orYYYY-MM-DD HH:mmread 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) orthread. Split thread parts with||or a line with only---, up to 25 parts.repeat: for exampleevery 2 weeks x4orweekly x6. The count is the total number of posts.caption_<network>: a caption for one network only, for examplecaption_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
accountscolumn 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.