Import Posts from a CSV file

What You Will Learn

1. How to import posts in bulk from a CSV file
2. Post import format
3. Bonnes pratiques
4. Troubleshooting issues that may occur during import

---

Why This Helps

1. Saves time: Import multiple posts in seconds instead of pasting them one by one
2. Reduces human error: Use a single validated file rather than repeating manual steps
3. Maintain structure: Import labels, scheduled dates, times, and timezone metadata so posts are ready for review and scheduling

---

Bulk Import Posts Step-by-Step

The only prerequisite of this entire process is having a CSV file with atleast one post and a column header called contenu . Detailed information on the optional paramaters are given in the next section

1. Dans Your Posts Draft page, select Bulk Import

   

2. Either drag & drop your file, or select it from your file system (File must be a CSV file)

3. Ensure that all posts have been validated successfully

   

4. Select Import Posts

   

Note: You can only import upto 50 posts at a time

---

CSV Format Requirements

Required Column

content:

• It is the text of the post
• Required for every row
• If the cell is empty that row will fail validation

Optional Columns

• labels

  • Label of the post
  • Semicolon-separated list of labels
  • Exemple: Marketing;Growth

• scheduled_date

  • Represents the date the post is to be scheduled
  • Format: YYYY-MM-DD
  • Exemple: 2025-11-01

• scheduled_time

  • Represents the time the post is to be scheduled
  • Format: HH:MM using 24-hour clock
  • Exemple: 14:30

• timezone

  • Represents the timezone the post is to be scheduled

  • Your timezone offset from UTC

  • Common Examples:

    • New York (EST/EDT): UTC-5 or -5
    • London (GMT): UTC+0 or +0
    • Paris/Berlin (CET): UTC+1 or +1
    • Dubai/Pakistan: UTC+4 or +4
    • India: UTC+5 or +5
    • Singapore/China: UTC+8 or +8
    • Tokyo: UTC+9 or +9

---

Important CSV Formatting Tips

• Utiliser Excelou Google Sheets to create and export your CSV. They handle quoting and line breaks reliably.
• If the post content contains commas, wrap the content in double quotes: "This post, has commas" (Excel & Google sheets handle this automatically)
• You can only import a maximumde 50 posts at a time
• For multi-line posts, wrap in quotes and use actual line breaks inside the cell. When exported to CSV, the new lines will be preserved. (Excel & Google sheets handle this automatically)

---

Example CSV

content,labels,scheduled_date,scheduled_time,timezone  
"My first post about productivity tips",Productivity,,,  
"This post has commas, quotation marks, and special characters!",Marketing;Growth,2025-11-01,14:30,UTC+2  
"Multi-line post:  
  
This is line 1  
This is line 2  
  
End of post",Content,,,  
"Quick update without any special formatting",,,,,  
"Scheduled for Tokyo timezone",Business,2025-11-05,09:00,+9

---

Quick Checklist Before You Start

1. Does the column have a contenu header?
2. Are the day, time & timezone formats accurate?
3. Are labels separated by semicolons?
4. Ensure that your CSV file has no more than 50 posts
5. Test by importing one row before a multi-line import

---

Bonnes pratiques

• Keep your label list small and consistent. Prefer 6 to 12 labels for teams.
• For multi-line posts, test one row first to confirm formatting looks correct after import.
• Once the posts have been imported successfully, you are able to verify if they were imported accurately or not before saving them

---

Troubleshooting Tips

• Error about commas or broken rows: Open your CSV file in Excel or Google Sheets and re-save as CSV. Quoted cells with commas or line breaks are handled reliably by those tools.
• Blank content errors: Check for invisible characters or formulas. Use copy and paste as plain text into the cell.
• Timezone looks wrong after import: Open the draft and verify the day, time & timezone formats

Still Stuck? Export the first 5 rows that fail and paste them into a support ticket along with images that display your issue. This will help support better assist you.

---

Questions fréquentes

Q: How many posts can I import at once?

You can import a maximum of upto 50 posts at once.

Q: I am unable to locate the Bulk Import feature.

Le Bulk Import feature is in the Créer du contenu section on the right side of the Your Post Draftpage

Q: Why is my CSV import failing validation?

Common causes include:

1. Missing contenu in one or more rows
2. Incorrect date, time, or timezone format
3. Unquoted cells containing commas or line breaks
4. Incorrect column headers
5. More than 50 posts in one file

Try opening your file in Excelou Google Sheets, re-saving it as a CSV, and retrying the import.

Q: Can I import posts that include line breaks or commas?

Yes! You can include commas and multi-line text by enclosing the content in double quotes (e.g., "This post, includes commas"). Excelet Google Sheets automatically handle this when exporting your CSV.

Q: My timezone or scheduled time looks wrong after importing.

If your scheduled times look off, double-check the formatting in your CSV file:

• Le scheduled_date column should use YYYY-MM-DD
• Le scheduled_time column should use 24-hour time (e.g., 14:30)
• Le timezone column should include a valid UTC offset (e.g., +9 for Tokyo)

If the issue persists, try importing one line. If that doesn't work either then please contact support.