Create a CSV file for bulk import in Excel
This explains how to create a CSV file for Bulk import using a spreadsheet application such as Excel.
Create a CSV file for text-only Posts
- Open the downloaded sample file or create a new file by selecting [File] > [New] in a spreadsheet application such as Excel.
- In column A, enter the desired Post date and time in "YYYY/MM/DD HH:MM" format. The Post date and time can be specified up to one year and six months in advance.
- In column B, enter the Post content. Line breaks within cells will also be reflected in the Post.
- Repeat steps 2 and 3 for the number of Posts you want to schedule.
- Export the CSV file by selecting [File] > [Save As].
- From [File Type], select [CSV UTF-8 (Comma delimited)]. For details on how to Save, please refer to How to Save in UTF-8 or Shift_JIS.
- Enter the file name and Save.
Create a CSV file for Bulk import of Posts with Media
With a single CSV file, you can Add Posts with Media and text-only Posts, either as scheduled Posts or to Drafts, all at once.
To Bulk import Posts with Media, you must first upload images and videos to the [Media Library]. For information on how to upload, please refer to Uploading Media (Images and Videos) to the Media Library.
- Open the downloaded sample file or create a new file by selecting [File] > [New] in a spreadsheet application such as Excel.
- Create the CSV file according to the format described in Details of Input Fields below.
- Export the CSV file by selecting [File] > [Save As].
- From [File Type], select [CSV UTF-8 (Comma delimited)]. For details on how to Save, please refer to How to Save in UTF-8 or Shift_JIS.
- Enter the file name and Save.
Details of Input Fields
| Item Name | Example Input | Required/Optional | Notes |
| Post Date and Time | 2025/08/21 10:00 | Required | Enter the date and time in "YYYY/MM/DD HH:MM" format. The Post date and time can be specified up to one year and six months in advance. |
| Post Content | This is a sample Post. | Required | Line breaks within cells will also be reflected in the Post. |
| Media 1 | 20250821_01.jpg | Optional | Enter the file name of the Media uploaded to SocialDog's [Media Library]. Be sure to include the file extension (.jpg/.png) in the file name. |
| Media 2 | 20250821_02.jpg | Optional | Up to 20 Media items can be specified per Post (maximum 4 for X (Twitter), maximum 10 for Instagram and Facebook). Enter only the necessary Media header rows. |
| Media 3 | Optional | If left blank, it will be a text-only Post. | |
| Media 4 | 20250821_04.jpg | Optional | |
| Media 5 | 20250821_05.jpg | Optional | |
| Media 6 | 20250821_06.jpg | Optional | |
| Media 7 | 20250821_07.jpg | Optional | |
| Media 8 | 20250821_08.jpg | Optional | |
| Media 9 | 20250821_09.jpg | Optional | |
| Media 10 | 20250821_10.jpg | Optional |
For information on how to obtain Media file names, please refer to Uploading Media (Images and Videos) to the Media Library.
How to set the date in the CSV file to the SocialDog compatible format
Perform the following operations to set the date format in the CSV file to the format compatible with SocialDog.
- Select the cells for which you want to Change the date settings, then click on "Format Cells".
- Enter "yyyy/mm/dd hh:mm" in the format field, then click OK.
How to Save in UTF-8 or Shift_JIS
- Select [File] > [Export] > [Change File Type] > [CSV (Comma delimited)], then click [Save As].
- If emojis are included, Change [File Type] to [CSV UTF-8 (Comma delimited) (*.csv)].
- Enter a desired file name and click [Save].
If emojis are included, select UTF-8.
About Line Breaks within Cells
When Editing directly in a text editor, line breaks must be enclosed in double quotes. When Editing in Excel, line breaks within cells are automatically converted during CSV export, so there is no need to enclose them in double quotes.
About Functions such as LEN
Functions are converted to text when written to a CSV file.
The registered Post content will be displayed on the confirmation screen after upload, so please be sure to review it before registration.