How to schedule multiple posts at once with a CSV file
Use CSV import to batch schedule content from the calendar for one or more brands, or from autolists.
There is no hard limit on the number of posts, but larger files take longer to process. For best results, import up to 50 posts per file.
Use MP4 instead of MOV when possible. MOV files are converted to MP4 during import. Check all media requirements here.
To add media, use a public link that points directly to the image or video.
Save the CSV with UTF-8 encoding so emojis and special characters import correctly.
When importing, select the same date and time format used when creating the file.
If you have issues during import, see Common troubleshooting when importing CSV.
From the calendar
Download the template. You can find it by clicking Import CSV in the calendar options menu.
You can also fill it in with Google Sheets.
A new window opens where you can click Download template.
Fill in the template exactly as shown in the example. Do not delete or add columns. To review all available fields, click here.
The accepted languages for the template are English, Spanish, French, German, and Portuguese.
Use TRUE in the fields you want to include and FALSE in the fields you want to leave out. For example, if you only want to publish on Instagram, set the Instagram column to true and the rest to false.
Attach multimedia files
To add media, use a public link that points directly to an image or video:
Dropbox: the URL must be public and end with
?dl=0.Google Drive: the URL must be public and set with editor permissions. The link should end in
.jpg,.png, or.mp4for videos.
Remember to make the link public. For Google Drive, editor permission is required.
To generate a public Google Drive link, share the image or video with Anyone with the link.
Add emojis
To import emojis correctly, save the CSV with UTF-8 encoding. Google Sheets exports CSV files as UTF-8 by default. In Excel, save the file as CSV UTF-8 (Comma delimited), not as a standard CSV.
Once the file is ready, click Import CSV again and select CSV File to upload it.
A new window appears where you can review errors, preview posts, and import them.
A common error is the date and time format. Select the same format from the dropdown that you used when creating the file.
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. The CSV only needs two columns: one for the text and one for the image or video link. If you need more images, add one column per image, up to a maximum of 10. Check the number of images allowed by each social network here.
You can also download scheduled posts from the calendar or autolists as a CSV file.
Photo and video links in the CSV must end in .jpg, .png, or .mp4 and must be public.
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 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 |