The CSV Blog Importer lets you import dozens of blog posts in minutes, with no manual copying or complex setup required. Whether you're moving from Blogger, Wix, WordPress, or any other platform that supports CSV exports, this guide walks you through every step: from preparing your spreadsheet to reviewing, scheduling, and publishing your posts.
Key Benefits
- Seamless Migration: Remove the need for tedious copy-and-paste when moving content from other platforms.
- Bulk Uploading: Import up to 60 posts in one file to accelerate onboarding.
- Smart Organisation: Automatically match or create authors and categories for cleaner imports.
- Flexible Scheduling: Automatically detect and apply publish dates from your CSV.
- Built-in SEO Preview: Review titles, meta descriptions, and social images before publishing.
How to Use the CSV Blog Importer
Access Blogs & Choose a Target Blog
Log in to your account and navigate to Sites > Blogs from the left menu. Create a new blog site by selecting Create Blog, or open an existing one by clicking its name.
Start a CSV Import
Next, click the New Post dropdown and select Import Blog Post from CSV.
Prepare & Upload the File
This will show options to download the sample CSV or XLSX template, or click Upload (or drag and drop) your prepared file.
Once you've uploaded your file, review the summary and formatting tips, then open any blog card to preview and edit your post as needed.
Set the publish date. Past dates publish immediately, future dates schedule automatically, and blank or invalid dates are saved as drafts.
Import & Confirm
Finally, click Import.
In the confirmation modal, review the summary (number of posts published or saved as drafts) and click Import to add the posts to your blog site.
The CSV Blog Importer takes the effort out of blog migration, so you can import, preview, and publish content without the hassle. Whether you're managing one site or many, it keeps things fast and accurate so you can get on with creating rather than copying.
✍Important Notes
- Automatic Validation: The platform scans your CSV headers on upload and flags any missing or misspelled fields.
- Required Fields: All required headers must be present, though cell values may remain blank.
- Error Detection: Inline error chips highlight issues such as missing images, invalid dates, or long meta descriptions.
- File Size: Keep your CSV under 25MB to avoid timeouts; split larger files into smaller batches.
- Time Zone Handling: The importer respects each account's time zone to ensure accurate publishing times.
Frequently Asked Questions
Q: What's the maximum number of posts I can import at once?
- Up to 60 posts per CSV or XLSX file.
Q: Does the importer download and host my images?
- Yes. Include full image URLs or accessible relative paths, and the platform will fetch and host them.
Q: What happens if I re-import a post with the same title?
- A new draft will be created since duplicates aren't automatically merged.
Q: Do drafts count toward the 60-post limit?
- Yes. All rows in your CSV count toward the cap, regardless of status.
Q: Can I undo an import?
- There's no one-click rollback, but you can manually delete, or bulk-delete imported posts.