Skip to main content

Import Posts from a CSV file

Import multiple posts in one go from a CSV file that follows our format. Use Bulk Import to move faster when onboarding content, migrating drafts, or scheduling many posts at once.

Written by Anss
Updated over 2 weeks ago

What You Will Learn

  1. How to import posts in bulk from a CSV file

  2. Post import format

  3. Best Practices

  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 content. Detailed information on the optional paramaters are given in the next section

  1. In 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

    • Example: Marketing;Growth

  • scheduled_date

    • Represents the date the post is to be scheduled

    • Format: YYYY-MM-DD

    • Example: 2025-11-01

  • scheduled_time

    • Represents the time the post is to be scheduled

    • Format: HH:MM using 24-hour clock

    • Example: 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

  • Use Excel or 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 maximum of 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 content 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

Best Practices

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

Common Questions

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.

The Bulk Import feature is in the Create Content section on the right side of the Your Post Draft page

Q: Why is my CSV import failing validation?

Common causes include:

  1. Missing content 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 Excel or 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"). Excel and 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:

  • The scheduled_date column should use `YYYY-MM-DD`

  • The scheduled_time column should use 24-hour time (e.g., `14:30`)

  • The 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.

Related Articles
How to connect LiGo with ChatGPT (Custom GPT)
Complete Guide to Post Publishing
Did this answer your question?