Exporting & Backing Up Your Articles

Exporting your content can be super useful if you want to do some advanced filtering, run through content during meetings, or swap to a different platform.

At HelpDocs we take regular backups of all your data so you don't need to worry about data loss. That said if you need a copy of your data for any reason it's super easy to grab.

Downloading a CSV File

If you wanna grab a quick copy of all or some of your articles to use as a spreadsheet or import to another piece of software a CSV is the answer.

Exporting All Content to CSV

You have a few options when downloading to CSV:

• Include working copy
• Include body
• Include both
• Include neither (recommended)

1. Head to Settings > Migrations
2. Under Export & Backup click More next to CSV
3. Select your preferred options

By default the CSV will contain the following columns:

Export Selected Content to CSV

You also have the option to export some of your content to CSV. This is super useful when you only want to upload certain content somewhere else or run through a selected amount of content in meetings.

1. Head to Content (or click here)
2. Select which categories or individual articles you want to export using the checkboxes
3. To the top right click the Download button
4. Select which option you'd like to download
5. You're done ✨

CSV Download Options

You can choose to download your CSV file a few different ways by clicking the ▾ dropdown menu icon beside the Download CSV button.

Include Working Copy

Adds has_working_copy column and uses the working copy for text, body, and description fields. The CSV will contain the following columns:

Include Body

Includes the text and body fields. The CSV will contain the following columns:

Include Both

Has all the fields mentioned above ☝️

Include Neither

Includes only an excerpt field (the first 1000 characters of the article body) and no data about Working Copy.

Multilingual Columns

If you're running a multilingual Knowledge Base, your CSV export will also include columns for each secondary language. For example, with French as a secondary language, you'll see these additional columns:

These columns follow the same pattern for any other secondary languages you have enabled—just replace the language code accordingly (es for Spanish, de for German, etc.). This makes it super easy to manage and review all your translations in one place 🌍

Downloading a ZIP File

You can export your categories and articles to a .zip file and it'll sort them out into folders for you with metadata included as .yaml files.

1. Head to Settings > Migrations
2. Under Export & Backup click More next to ZIP
3. Click Download as ZIP

Exporting to Google Sheets

Creating a Google Sheet of your articles is just as simple.

1. Head to Settings > API Keys and create an API key
2. Create a new Google Sheet
3. In the top left cell, type =IMPORTDATA("https://api.helpdocs.io/v1/article?format=csv&key=your_api_key")
   Don't forget to replace your_api_key in the link above with the API key you just created.
4. Hit Return
5. Save your new sheet

Google will pull all your articles from the HelpDocs API and display them in your sheet.