---
title: "HubSpot CSV Export"
description: "Export your public Brainfish knowledge base articles into a HubSpot Knowledge Base import-friendly CSV. The export produces a ZIP that contains one CSV (or multiple CSVs if you exceed HubSpot’s per-file limit), ready to import into HubSpot."
canonical_url: "https://help.brainfi.sh/articles/hubspot-csv-export-3w79b8X27Y"
md_url: "https://help.brainfi.sh/articles/hubspot-csv-export-3w79b8X27Y.md"
---
# HubSpot CSV Export

Export your **public** Brainfish knowledge base articles into a HubSpot Knowledge Base import-friendly CSV. The export produces a **ZIP** that contains one CSV (or multiple CSVs if you exceed HubSpot’s per-file limit), ready to import into HubSpot.

## Where to find it

1. In Brainfish, go to **Settings → Export**
2. Select the **HubSpot Export** tab

![](https://help.brainfi.sh/api/attachments.redirect?id=5b3f5029-c900-4f56-93eb-8b9c0c04acca " =2994x1506")

## What gets exported

* **Public articles only**: only articles with site visibility enabled are included
* Internal/private articles are excluded
* You’ll also see an informational count: **“All {X} articles will be included”** (based on your public article count)

## HubSpot CSV limitations (important)

HubSpot Knowledge Base CSV import has known limitations:

* **Tables**: HubSpot can’t import tables via CSV
  Content will be included, but table formatting will be lost
* **Max 400 articles per CSV file**
  If you have more than 400 public articles, Brainfish will split the export into multiple CSVs
* **Only 2 levels of hierarchy**
  HubSpot supports **Category** and **Subcategory** only
  Deeper nesting in Brainfish will be flattened

## What you will download (ZIP + CSVs)

The export always downloads as a **ZIP** file:

* **If you have ≤ 400 articles:**
  ZIP contains one CSV file (`brainfish-articles.csv`) plus an `images/` folder with any referenced attachments.
* **If you have > 400 articles:**
  ZIP contains multiple files:
  * `brainfish-articles-part-1.csv`, `brainfish-articles-part-2.csv`, … one CSV per 400-article slice.
  * A single shared `images/` folder for all parts.
  * Each CSV is independently importable into HubSpot.

## CSV columns included

The CSV is generated in a HubSpot-import-friendly shape and includes these columns:

| Column | Description |
|---|---|
| `Title` | The article's title in Brainfish. |
| `Subtitle` | Optional subtitle / summary. |
| `Content` | The article body, rendered as HTML (tables stripped — see limitations above). |
| `Slug` | URL slug, derived from the Brainfish URL ID. |
| `Category` | Top-level collection name. |
| `Subcategory` | Second-level folder (HubSpot only supports two levels — deeper nesting is flattened). |
| `Tags` | Comma-separated tags from Brainfish. |
| `Author` | The author email associated with the last published version. |
| `State` | Always `published` (private articles are excluded from the export). |
| `Created at` | ISO 8601 timestamp. |
| `Updated at` | ISO 8601 timestamp. |

> If your team needs additional columns for downstream automation, contact your account team — custom column mappings can be added on request.

## How to export from Brainfish

1. Go to **Settings → Export**
2. Click **HubSpot Export**
3. Click **Export**
4. Wait while the export runs
   You’ll see **“Export in progress”**
   You can leave the page and keep working
5. If notifications are enabled, you’ll get an email when it’s ready
6. When complete, the export will appear under **Recent exports**
7. Download the ZIP and extract it to access the CSV file(s)

## Import into HubSpot

1. In HubSpot, open **Knowledge Base import** (CSV import flow).
2. Upload the exported CSV:
   * If you exported ≤ 400 articles, upload the single CSV.
   * If you exported > 400 articles, upload each part-N CSV separately. HubSpot will dedupe by `Slug` if you re-import a part.
3. Review imported articles, especially:
   * Articles that contained tables (formatting may need manual cleanup).
   * Articles that were nested deeper than two levels (hierarchy may be flattened).

![](https://help.brainfi.sh/api/attachments.redirect?id=9a5d1d1b-ab50-43d2-be6e-3c6dec5b4f1d " =2804x1456")

Ref: [Hubspot Import knowledge base articles](https://knowledge.hubspot.com/knowledge-base/import-knowledge-base-articles)