How to schedule posts in batch with a CSV file in Metricool
How to schedule from CSV
With Metricool, you can batch schedule your content through a CSV file by accessing the planning . Import the CSV from the calendar for one or several brands at a time or from the autolists section.
From the Calendar
- Download the template. You can find it by clicking on "Import CSV" within the calendar options menu.
💡 You can also fill it from Google Sheets by downloading our Social Media Marketing Template. In this video tutorial, we explain all the details.
A new window will pop up where you will find the option "Download template".
- Fill in the template as shown in the example and don't delete or add columns. To check all the fields available click here.
The languages accepted to complete the template are those supported on the platform (except Japanese).
Fill "TRUE" in the fields you want to add and "FALSE" in the fields that should not be included. For example, if we want to publish only on Instagram, we will fill true in the Instagram column and false in the rest of the networks.
If the "Brand Name" column is left empty, the post will be added to the brand you are in. If you want the same post for several different brands you must create one row per brand.
Attach Multimedia Files
To add multimedia content, it must be through a publicly configured link that directly points to an image or video:
- Dropbox: The URL must not only be public but also end with
?dl=0. - Google Drive: The URL must be public and configured with Editor permissions and they must end in
view?usp=sharing.
As an example, to generate a public link in Google Drive you must share the image or video with the option "anyone with the link".
Add emojis 🙂 👍🏻
To correctly add emojis in your CSV, the file must be saved with UTF-8 encoding, which properly supports emojis and special characters.
👉 In Google Sheets, CSVs are exported as UTF-8 by default.
👉 In Excel, make sure to save the file as CSV UTF-8 (Comma delimited), not as a standard CSV.
- Once you have the CSV file with your posts ready, just follow the same steps: click again on "Import CSV" and click on "CSV File" to add it.
A new window will appear where you can check errors, preview the posts and import them.
⚠️ A common error is the format of the date and time. Select from the drop-down the same format you used when creating the file as shown in this example.
From Autolists
For autolists there is no template available because the CSV file must only contain two columns: One for the text and another for the link to the image or video. If you need to add more images, you can add a column for each image, up to a maximum of 10. Check the number of images allowed by social network here.
You can also download the scheduled posts from the Calendar or Autolists in a CSV file.
Annex: Available Fields in the Template
English only
Instructions |
|---|
Fill "TRUE" in the fields you want to add and "FALSE" in the fields that should not be included. This applies only to boolean fields. |
The languages accepted to complete the template are those supported on the platform (except Japanese). |
If you are adding images or videos, the URL must point directly to that image or video.For Google Drive URLs: they must end in |
FIELD | DESCRIPTION |
|---|---|
Text | Add the copy of the post |
Date | Set the date. Make sure to select the same format when importing (e.g. YYYY-MM-DD). |
Time | Set the time. Make sure to select the same format when importing (e.g. 00:00:00). |
Draft | Import the post as draft |
To publish on Facebook | |
Twitter/X | To publish on Twitter/X |
To publish on LinkedIn | |
GBP | To publish on Google Business Profile |
To publish on Instagram | |
To publish on Pinterest | |
TikTok | To publish on TikTok |
YouTube | To publish on YouTube |
Threads | To publish on Threads |
Bluesky | To publish on Bluesky |
Picture Url 1 (up to 10) | Add the public URL of your picture or video (e.g. https://picture-url.png) |
Alt text picture 1 (up to 10) | Add alternative text for each picture (only for supported platforms) |
Document title | Add a LinkedIn title (58 characters max). Only for LinkedIn documents (not image/video). |
Shortener | To shorten the link |
Video Thumbnail Url | Add a video thumbnail URL (Facebook posts and reels, Instagram reels, LinkedIn posts, TikTok business and YouTube videos) |
Video Cover Frame | Set a video frame (seconds) as cover (Instagram reels, Pinterest and TikTok) |
Twitter/X Can reply | Set who can reply: following, mentionedUsers, subscribers or verified. If empty, everyone can reply |
Twitter/X Type | Set the post type: POST or POLL |
Twitter/X Poll Duration minutes | Set the poll duration in minutes (max 10080). Only when Type is POLL |
Twitter/X Poll Option 1 (up to 4) | Add poll options. Option 1 and 2 are mandatory (max 25 characters each). Option 3 and 4 are optional. Only when Type is POLL |
Pinterest Board | Add the Pinterest board name |
Pinterest Pin Title | Add a Pinterest Pin title (100 characters max) |
Pinterest Pin Link | Add a Pinterest Pin link |
Pinterest Pin New Format | Set the pin to the new format |
Instagram Post Type | Set the Instagram content type: POST, REEL or STORY |
Instagram Show Reel On Feed | Enable this option (true) to include reel in your feed |
YouTube Video Title | Add a YouTube video title (100 characters max). For videos and shorts |
YouTube Video Type | Set the video type: VIDEO or SHORT |
YouTube Video Privacy | Set the YouTube privacy: PUBLIC, PRIVATE or UNLISTED |
YouTube video for kids | Set if the content is for kids (true/false) |
YouTube Video Category | Set the video category (e.g. MUSIC, SPORTS, EDUCATION…) |
YouTube Video Tags | Add video tags as a comma-separated list (e.g. family, holidays) |
YouTube Playlist | Add the exact playlist name (case-sensitive, symbols and emojis included) where the video should be added |
GBP Post Type | Set the post type: PUBLICATION or PHOTO |
Facebook Post Type | Set the Facebook post type: POST, REEL or STORY |
Facebook Title | Add the Facebook title. Only for Facebook video posts and reels (not stories) |
First Comment Text | Add a first comment text |
TikTok Title | Add a TikTok title (90 characters max). Only for TikTok images (not videos) |
TikTok disable comments | Set if comments are allowed (true/false) |
TikTok disable duet | Set if duet is allowed (true/false) |
TikTok disable stitch | Set if stitch is allowed (true/false) |
TikTok Post Privacy (personal accounts only) | Set privacy: PUBLIC_TO_EVERYONE, MUTUAL_FOLLOW_FRIENDS, SELF_ONLY or FOLLOWER_OF_CREATOR |
TikTok Branded Content (personal accounts only) | Set if promoting another brand. Classified as Branded Content (true/false) |
TikTok Your Brand (personal accounts only) | Set if promoting yourself or your business. Classified as Brand Organic (true/false) |
TikTok Auto Add Music (personal accounts only) | Allow TikTok to automatically add music to photos (true/false) |
TikTok Photo Cover Index | Set the cover image index for TikTok photo posts (default 0) |
TikTok musicId | Add the TikTok music ID |
TikTok music title | Add the TikTok music title |
TikTok music author | Add the TikTok music author |
TikTok music previewUrl | Add the TikTok music preview URL |
TikTok music thumbnailUrl | Add the TikTok music thumbnail URL |
TikTok music soundVolume | Set the music volume |
TikTok music originalVolume | Set the original video volume |
TikTok music startMillis | Set the music start time in milliseconds |
TikTok music endMillis | Set the music end time in milliseconds |
LinkedIn Type | Set the post type: POST or POLL |
LinkedIn Poll Question | Add the poll question (mandatory, max 140 characters). Only when Type is POLL |
LinkedIn Poll Option 1 (up to 4) | Add poll options. Option 1 and 2 are mandatory (max 30 characters each). Option 3 and 4 are optional. Only when Type is POLL |
LinkedIn Poll Duration | Set the poll duration: ONE_DAY, THREE_DAYS, SEVEN_DAYS or FOURTEEN_DAYS |
LinkedIn Show link preview | Enable to display a link preview (requires at least one link and max one image) |
LinkedIn Images as Carousel | Enable to publish images as a PDF carousel on LinkedIn |
Threads Reply Control | Set who can reply: EVERYONE, ACCOUNTS_YOU_FOLLOW, MENTIONED_ONLY or FOLLOWERS_ONLY |
Threads Is Spoiler | Set if the post contains spoiler content (true/false) |
Threads Post Type | Set the post type: POST or GHOST |
Brand name (Optional) | Add the exact brand name you want to schedule the post for |
Updated on: 17/02/2026
Thank you!