How to schedule multiple posts at once with a CSV file
How to schedule from CSV
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 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.
💡 _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 English, Spanish, French, German and Portuguese.
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.
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. The Drive URL must end with .jpg or .png, or .mp4 for videos.
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.
The links to the videos or photos in the CSV file, must end in .jpg, .png, or .mp4 and must be public.