How to Migrate 100 Blog Posts to Squarespace Without Losing Your Mind
Blog migration is one of those projects that looks straightforward until you actually start it. You've got a WordPress site with 87 posts, a Wix blog with 23 pieces of content, and a Medium account with another 40 articles. Your client wants everything consolidated into their new Squarespace site. Now what?
I've done this migration dance more times than I'd like to admit. What should take a weekend has turned into three weeks of manual data entry and broken metadata. Here's what I've learned about doing this properly, and how to avoid the pitfalls that'll cost you days.
The Painful Reality of Manual Blog Migration
Let's be honest: migrating 100 blog posts manually is not a viable approach. You're looking at copying the post title, pasting it into Squarespace, copying the post content, pasting it again, manually recreating any formatting, uploading featured images one at a time, writing new meta descriptions, setting URLs, configuring categories, and then checking for broken links.
For one post, that might take 5 minutes if you're efficient. For 100 posts, you're looking at 500 minutes of work. That's over 8 hours. And you'll make mistakes. Forgotten metadata, inconsistent URL structures, images that don't upload properly, content that loses formatting.
This is where most designers either give up or charge clients thousands in labour costs. There has to be a better way, and there is.
What Squarespace's Built-In Import Doesn't Tell You
Squarespace does offer an import tool. You can import from WordPress and a few other platforms. But it has serious limitations that nobody mentions until you're halfway through the process.
The built-in import works fine for basic blog posts, but it doesn't handle complex formatting consistently. If you've got custom code blocks, embedded videos, or advanced formatting in your original posts, those often get mangled in translation. It doesn't always preserve featured images correctly, especially if they're hosted on external servers. It won't touch categories or tags unless they're explicitly set up. And if your original blog used custom URLs that you want to maintain for SEO, good luck managing that through Squarespace's import.
The other issue is speed. Squarespace's import runs server-side, and if you've got any hiccup in the process, you're starting over. There's no resume option. You're hoping nothing goes wrong during the entire import.
The CSV Approach: Preparation Is Everything
The real solution is preparing your content properly before bringing it into Squarespace. The best way to move large amounts of blog content is through a structured CSV file. This gives you control over every field, lets you check your data before upload, and makes the process repeatable.
Here's what your CSV structure should look like:
title,content,author,category,tags,url,meta_description,featured_image_url,publish_date
"My First Post","<p>This is the content...</p>","John Smith","Technology","squarespace,migration","my-first-post","A 160-character meta description","https://example.com/image.jpg","2025-01-15"Each column represents a field in Squarespace. You'll need to export your original blog content into this format. If you're coming from WordPress, there are export plugins. Medium has export options. Wix has export functionality. Get all your content into this CSV format first.
This is where the real work happens. You're cleaning data, standardising URLs, writing proper meta descriptions, ensuring images are accessible, and checking for encoding issues. But once your CSV is clean, the actual import is quick and reliable.
Managing Images During Migration
Images are where most migrations break. If your original blog is hosted on a server that might go down, or if you've got broken image links, those problems follow you to Squarespace. Don't import broken images. Fix them first.
Download all the original images, rename them sensibly (don't use generic names like "image-1.jpg"), and rehost them somewhere accessible during migration. Some designers use a temporary S3 bucket, others use a folder on their own server. The key is having a permanent URL for each image that works during the import process.
For featured images in your CSV, reference the full URL of where each image is hosted. Squarespace will pull these during import. Once everything is imported and verified, you can replace external image URLs with Squarespace's native image storage if you want, but having them hosted externally initially keeps the migration flexible.
Preserving SEO During Migration
Blog migration is where you can destroy your organic traffic if you're not careful. Search engines have indexed your original blog posts at specific URLs. If you move them and don't set up proper redirects, you lose all that link equity.
Before you migrate anything, map your old URLs to new URLs. If a post lived at wordpress-site.com/blog/my-article-title and it's moving to squarespace-site.com/blog/my-article-title, that's straightforward. If you're changing URL structures (which you should do if your original site had dated URLs or messy structures), you need to plan this carefully.
Your CSV should include the exact URL slug you want for each post in Squarespace. Make these URLs lowercase, hyphenated, and descriptive. Once everything's imported, set up 301 redirects from old URLs to new ones. Squarespace has settings for this in the Custom Domain section.
Don't forget meta descriptions. This is one thing you can actually improve during migration. If your original posts had weak meta descriptions or none at all, now's the time to write proper ones for each piece of content. This improves CTR from search results immediately.
Handling Multiple Source Blogs
If you're consolidating content from multiple blogs into one Squarespace site, your CSV approach still works. You just need to prepare separate CSVs for each source, then merge them carefully, making sure you don't have duplicate posts and that your URL structure keeps things organized.
One approach is to use categories to distinguish which blog posts came from which source. You might have a "Tech Blog Archive" category for posts from your client's original tech blog, and a "Guest Articles" category for Medium pieces. This is transparent to your users and helps with internal linking and site structure.
A Faster Solution for Large Migrations
If you're dealing with 100+ blog posts, prepare your CSV correctly, and you're ready to use the Squarehead Blog Uploader. This tool is specifically designed for bulk blog imports into Squarespace. You give it your CSV, it handles the upload process, and it does it quickly and reliably without the limitations of Squarespace's built-in importer.
The Blog Uploader respects your CSV formatting, preserves metadata exactly as you've structured it, handles image URLs properly, and gives you real-time feedback on what's uploading and whether anything fails. If there's an issue with a specific post, you can fix it in your CSV and re-run just that post. No starting from scratch.
For a 100-post migration with proper CSV preparation, you're looking at a few hours of work total instead of weeks. That time difference is what makes migration projects profitable instead of painful.
Post-Migration Verification
Once everything's uploaded, don't assume it worked. Spot-check at least 10 per cent of your posts. Verify that content imported correctly, images are loading, URLs are what you expected, and meta descriptions are in place. Check that categories and tags have been applied properly.
Run a site crawl with Lighthouse or Screaming Frog to identify any broken links or missing images. If you've got redirects set up, test a few to make sure they're working.
Submit your new blog structure to Google Search Console and request re-indexing of the new URLs. Update internal links on your site to point to the new blog post URLs where relevant.
The Key to Painless Migration
Blog migration doesn't have to be a nightmare. The key is proper preparation. Spend your time getting the CSV right. Clean your data, verify your URLs, write good meta descriptions, and make sure images are accessible. Once that's done, the actual import process is straightforward and fast.
Get the preparation right and you'll move 100 blog posts into Squarespace cleanly, with proper SEO preserved and no broken links. Your client gets their consolidated blog running properly, and you've spent your time on planning rather than manual data entry.
Related Reading
If you found this useful, these might be worth your time too:
Tools That Help
Blog Uploader can help with the workflows discussed in this article.
Want to go deeper? The Squarehead Advanced Course covers these topics and more across 11 structured modules.
