Skip to main content

CSV Blog Importer in Blogs

The CSV Blog Importer lets you bulk import up to 60 blog posts at once into a blog site using a structured CSV or XLSX file, with validation, previews, and publishing controls.

Updated over 2 months ago

Who This Is For / When to Use

Use this feature if you need to:

  • Migrate blog content from another platform

  • Publish large volumes of blog posts quickly

  • Fix or update posts in bulk using spreadsheets

  • Onboard content across multiple blog sites efficiently

Overview of the CSV Blog Importer

The CSV Blog Importer allows you to upload blog posts using a CSV or XLSX file. Each row represents one blog post. During import, Kyrios validates fields, highlights errors, and lets you review posts before final publishing.

Supported behaviors:

  • Past publish date → Published

  • Future publish date → Scheduled

  • Blank publish date → Draft

Where to Find the CSV Blog Importer

  1. Go to Sites → Blogs

  2. Select a Blog Site

  3. Click New Post

  4. Select Import Blog Posts from CSV

Accessing CSV Imports Inside a Blog Site

Inside a blog site, you can switch between tabs:

  • Blog Posts

  • Imported Content

  • CSV Imports

The CSV Imports tab shows all past imports and their status.

Step 1: Download the Sample CSV File

Before uploading, download the sample file to ensure correct formatting.

  • Click Download Sample File

  • Available formats: CSV and XLSX

Step 2: Prepare Your CSV or XLSX File

Each row equals one blog post.

Key formatting rules:

  • Date format must follow one of the accepted formats shown in the importer

  • HTML content is supported

  • Categories must match existing category names exactly

  • Maximum: 60 blog posts per file

If a publish date is provided:

  • Past date → Published

  • Future date → Scheduled

If blank:

  • Saved as Draft

Step 3: Upload Your CSV File

Upload methods:

  • Drag and drop the file

  • Click to upload from your device

Maximum file size: 10MB

Step 4: Review Posts in Bulk Composer

After upload, Kyrios opens the Bulk Composer.

You can:

  • Preview individual posts

  • Edit titles, content, and metadata

  • See publish status for each post

Step 5: Identify and Fix Errors

If any posts have issues:

  • They appear under Blog Posts with Errors

  • Error count is shown clearly

  • Click a post to fix missing or invalid fields

Step 6: Confirm and Import Posts

Before finalizing, Kyrios shows a confirmation modal summarizing results.

Example:

  • X posts will be Published

  • X posts will be Draft

This action cannot be undone.

Click Import to proceed.

What Happens After Import

  • Published posts go live immediately

  • Scheduled posts publish automatically at the set date

  • Drafts remain unpublished and editable

  • All imported posts behave like normal blog posts and can be edited anytime

Common Issues and Fixes

Posts show errors after upload
Check for missing required fields or invalid date formats. Fix directly in the Bulk Composer.

Categories created unexpectedly
Category names must match existing categories exactly. Typos create new categories.

Posts imported as Draft unexpectedly
The publish date field was left blank.

Import button is disabled
At least one post must be error-free before importing.

FAQ

What file types are supported?

CSV and XLSX files are supported.

How many blog posts can I import at once?

You can import up to 60 blog posts per CSV or XLSX file.

What happens if I leave the publish date blank?

The blog post is saved as a Draft.

Can I edit blog posts after importing?

Yes. Imported posts can be edited like any other blog post.

What happens if my CSV file has errors?

Errors are highlighted during review. You must fix them before importing.

How do I ensure my CSV is formatted correctly?

Use the Sample CSV/XLSX file provided in the importer.

Can I re-import the same CSV file?

Yes. Keeping a backup of your CSV file is recommended for re-imports.

Will importing posts with past dates trigger notifications?

Posts with past dates are backdated and usually publish silently. If you have automations or RSS-based triggers, test with one post first to confirm behavior.

Did this answer your question?