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. |
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 | |
To publish on Twitter | |
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 |
Picture Url 1 (up to 10) | Add the public URL of your picture or video (e.g. https://picture-url.png) |
Alt text | Add alternative text for accessibility (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 (Instagram, LinkedIn and YouTube only) |
Video Cover Frame | Set a video frame (seconds) as cover (Instagram, Pinterest and TikTok only) |
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 |
YouTube Video Category | Set the video category (e.g. MUSIC, SPORTS, COMEDY, EDUCATION…) |
YouTube Video Tags | Add video tags as a comma-separated list (e.g. family, holidays) |
YouTube Playlist | Add the playlist ID 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 |
TikTok disable duet | Set if duet is allowed |
TikTok disable stitch | Set if stitch is allowed |
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. |
TikTok Your Brand (personal accounts only) | Set if promoting yourself or your business. Classified as Brand Organic. |
TikTok Auto Add Music (personal accounts only) | Allow TikTok to automatically add music to photos |
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 |
Brand name (Optional) | Add the exact brand name you want to schedule the post for |
Updated on: 20/11/2025
Thank you!