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.

👀 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.

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.

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.

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 `view?usp=sharing`. The file must also be public and have edit permissions. For Dropbox URLs: the file must be public and the link must end in `?dl=0`

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
Facebook	To publish on Facebook
Twitter	To publish on Twitter
LinkedIn	To publish on LinkedIn
GBP	To publish on Google Business Profile
Instagram	To publish on Instagram
Pinterest	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

Was this article helpful?

Thank you!