How to schedule posts in batch with a CSV file in Metricool
Updated 2 weeks ago
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.
Good to know
There’s no limit to the number of posts, but the larger the volume, the slower the processing. It’s recommended to import up to 50 posts per file.
It’s best to use MP4 formats instead of MOV to avoid possible issues. MOV files are automatically converted to MP4 during import. Check all the requirements here.
To add media content, use a public link that points directly to the image or video.
Make sure your CSV file is saved with UTF-8 encoding so emojis and special characters import correctly.
When importing, select in Metricool the same date and time format you used when creating the file.
If you have questions or notice any issues during the import, you can check the guide on Common troubleshooting when importing CSV into Metricool
From the Calendar
Download the template. You can find it by clicking on "Import CSV" within the calendar options menu.
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.
Remember to set the link to public. For Google Drive, Editor permission is required on the URL.
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.
Duration format for Video Cover Frame
If you use the Video Cover Frame field to select a specific frame as the video cover, you must indicate the time position of that frame. Metricool supports these formats:
Format | Example | Description |
|---|---|---|
Milliseconds | 151456 | Total time in milliseconds |
Seconds (decimal point) | 31.456 | 31 seconds and 456 milliseconds |
Seconds (decimal comma) | 31,456 | 31 seconds and 456 milliseconds |
Minutes:seconds (point) | 2:31.456 | 2 minutes, 31 seconds, and 456 milliseconds |
Minutes:seconds (comma) | 2:31,456 | 2 minutes, 31 seconds, and 456 milliseconds |
Readable format | 2min 31s 456ms | Explicit minutes, seconds, and milliseconds |
ISO 8601 | PT2M31.456S | ISO standard format for durations |
Where it applies: Instagram Reels, Pinterest, and TikTok.
When importing the CSV, select in the Duration format selector the same format you used in your file.
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
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 the video frame to use as a cover by specifying a time value (Instagram Reels, Pinterest, and TikTok). Make sure to select the same duration format when importing (e.g. 2:31.456). |
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, TRIAL_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 |