How can I transfer blog posts from Wordpress to Webflow while keeping the published dates, or being able to change them manually in Webflow?

Published on
September 22, 2023

Transferring blog posts from Wordpress to Webflow while keeping the published dates, or being able to change them manually in Webflow can be done using the Webflow CMS and a CSV (comma-separated values) file. Here is a step-by-step guide to help you with the process:

  1. Export your Wordpress blog posts:
  • In your Wordpress dashboard, go to "Tools" and then "Export".
  • Choose to export the "Posts" and select the desired date range if needed.
  • Click on the "Download Export File" button to save the XML file to your computer.
  1. Convert your Wordpress export file to CSV:
  • You'll need to convert the XML file to a CSV file so that it can be imported into Webflow. There are several online tools available that can help you convert the file.
  1. Prepare the CSV file for import:
  • Open the CSV file in a spreadsheet editor like Microsoft Excel or Google Sheets.
  • Make sure your CSV file contains the following columns: "Title", "Slug" (URL-friendly version of the title), "Published", and "Body" (content of the blog post). You can add additional columns if needed, such as "Tags" or "Categories".
  • Ensure that the "Published" column includes the correct dates and times for each blog post. You can either keep the original dates or change them manually at this stage.
  1. Import the CSV file into Webflow CMS:
  • In your Webflow project, go to the CMS section.
  • Click on the "Import" button and choose the CSV file you prepared.
  • Map the CSV columns to the corresponding CMS fields in Webflow.
  • Click on the "Import" button to begin the import process.
  1. Check and update the published dates (if needed):
  • After importing the blog posts, you can manually change the published dates in the Webflow CMS editor.
  • Go to your blog posts collection in the CMS and select the blog post you want to update.
  • In the right-hand sidebar, under the "Options" tab, you can modify the published date and time.

By following these steps, you will be able to transfer your blog posts from Wordpress to Webflow while maintaining the original published dates or having the flexibility to change them manually in Webflow.

Additional Questions:

  1. How can I export my blog posts from Wordpress?
  2. What is a CSV file and how to convert XML to CSV?
  3. How do I import a CSV file into Webflow CMS?