Blog

Import your blog into HubSpot as a CSV file

Last updated: November 4, 2020

In Beta

Applies to:

Marketing Hub  Professional, Enterprise
CMS Hub  Professional, Enterprise

If your blog isn't compatible with the smart copy (beta) import feature, you can import your blog content into HubSpot using a CSV file. Based on this sample CSV file, gather the content for each of your existing blog posts. Then import this file to generate new blog posts in HubSpot that are populated with your existing blog content.

Please note: if you want access to the CSV file upload beta feature, reach out to your Customer Success Manager.

Before you get started

  • When you create your HubSpot account, there will be a new default blog in your account you can use to import your blog posts. You can create a new blog instead or customize the blog in your blog settings.
  • There's a sample CSV file available to format your blog content for your import.
  • Note that the following fields in your CSV import file are required:
    • URL
    • Title
    • SEO title
    • Author
    • Meta description
    • Publish date
    • Post body

Import your blog content in a CSV file

  • In your HubSpot account, click the settings icon settings in the main navigation bar.
  • In the left sidebar menu, navigate to Website > Blog.
  • In the upper right, click Import blog. This will bring you to the blog importer dashboard.
  • In the upper right, click Import new blog.
  • Select the CSV file upload option, then click Next.
  • Set up your import:
    • Which blog platform are you currently using: click the dropdown menu and select the platform the blog you're importing is currently hosted on.
    • HubSpot blog: click the dropdown menu and select the HubSpot blog you want to import your blog content into.
    • CSV file upload: click Select a file to upload the CSV file with your blog content.
  • In the lower right, click Copy blog posts.

Map the columns from your import file

Next, you'll map the columns of your CSV file to the corresponding properties in your new HubSpot blog.

Learn more about HubSpot blog properties below. To see an example of how to format your CSV file and the blog content you're importing, review the sample CSV import file.

  • URL (required): enter the URL of each blog post in this column.
  • Title (required): enter the title for each blog post in this column.
  • SEO title: if you want search engines to index a different title for your blog post than the one that appears to your readers, enter a custom SEO title in this column.
  • Author (required): enter the name of the author of each blog post in this column. You can customize your blog author description after your import is complete.
  • Featured image: the URL of the featured image for each blog post in this column. If you don't want to import any featured images for your blog posts, leave this column blank or omit it from your CSV file.
  • Categories/Tags: enter the categories or tags applied to each blog post in this column. To import multiple tags or categories, separate them with a comma as illustrated in the sample CSV import file. If you don't want to import the categories or tags of this blog post, leave this column blank or omit it from your CSV file.
  • Meta description (required): a brief summary of what your blog post is about. To automatically use the first 55 characters of your blog post as your meta description, click the Column Header From File dropdown menu and select Use default.
  • Publish date (required): enter the publish date of each blog post in this column. Please note at this time only the date format MM/DD/YYYY is accepted. After the import, you can customize your blog's date formats settings in your blog settings, which are in your account settings.
  • Post body (required): enter the source code of the main body of your blog post content, including tags and image URLs. For an example of how to format your blog post body, see the sample CSV import file.

map-blog-properties-from-a-csv-file

To map the blog content from your CSV file into your new blog posts in HubSpot:

  • Click the Column Header From File dropdown menu and select the corresponding HubSpot Blog Property. You'll see Preview Information with the value for the first row in your spreadsheet for that column.
  • Confirm your mapping for each blog property you want to import from your CSV file.
  • Then click Next in the lower right. The import process may take a few minutes to finish up.
  • Click return to the dashboard to see the status of your import.

Finish your import

  • To complete your import, click Review results
  • If there are any errors during the import process, you can review the details in the Errors tab.
  • Click Preview to see a simplified preview of your blog post content, image URLs, and a listing of the values the importer tool identified for that post.

    Please note: images from your blog post won't render in the blog post preview, you'll see the image URLs appear in the preview instead.

  • If any default values were applied to your blog post features, you'll see a note that reads: Default values used to complete mappings.
    • To review the default values, click Change default values.
    • In the sidebar panel, review the default values for any blog features that couldn't be mapped for every blog post. In the example below, there's a default value populating for the blog Author and blog Publish date.
    • Update the values in the text field to the desired values.
    • Click Save to apply these values to all blog posts without a value for this property.

review-default-values-for-blog-posts

  • All blog posts are selected for import by default. Deselect the checkbox on the left for any blog posts that you want to omit from your import.
  • After you've finalized your selection, click Import.
  • In the Import posts dialog box, select whether to import these blog posts as drafts or as live published posts. Then click Save.

Your blog import status will update to Import in progress status. Once the import is complete, the status will update to Import completed.

If there were any issues detected with your import, click the More dropdown menu and select View details.

Next steps: set up your blog in HubSpot

After you've imported your blog posts, finish setting up your blog in HubSpot: