Exporting your feedback into a CSV

Makers can use this handy API endpoint to export all your feedback, components, features, and subfeatures in seconds. This is useful if you want to migrate your data from one Workspace to another due to a company acquisition or if you want to report on your data outside of Productboard.

In this article:

• Exporting all feedback
• Exporting all feedback with associated features
• Stripping HTML from exported feedback
• Troubleshooting

Exporting all feedback

When exporting feedback the following data will be exported: 

• id: The feedback id number.
• created_at: The date the feedback was created.
• note_title: The feedback's title.
• note_text: The text/body of the feedback.
• state: Whether the feedback is processed, unprocessed, or archived. 
• creator_name: The name of the person who created the feedback.
• creator_email: The creator of the feedback's email address.
• owner_name: The member of your product team who is responsible for the area of the product that the feedback is about.
• owner_email: The email address of the feedback owner. 
• user_name: The name of the user the feedback is from.
• user_email: The email address of the user the feedback is from.
• company_name: The name of the company the user is from who provided the feedback.
• company_domain: The domain of the company the feedback is from, e.g., productboard.com 
• source_id: The id number of the source of the feedback, such as third-party integrations like Zendesk, Intercom, and Slack.
• source_url: The URL of the source of the feedback, such as third-party integrations like Zendesk, Intercom, and Slack.
• tags: The tags associated with the feedback.
• uuid: The feedback UUID.
• last_updated_at: The date the feedback was updated the last time.
• company_uuid: The UUID of the company the feedback is from.

To export all feedback:

1. Make sure you're signed in to your Productboard workspace.

2. Paste this URL into your browser:

   https://[your_workspace].productboard.com/api/notes/export

   Note: To locate your workspace name, see the article How can I find my workspace name?

3. Insert your workspace's name into the URL. (When you're logged into Productboard, this will be at the beginning of the URL, before "productboard.com".)
4. Press enter, then wait. You will receive an email with the csv export in a few minutes.
5. Open the email and click the link inside it. A new webpage will open.
6. Click Download on the new page to download a CSV containing your exported feedback.

Limitations

Exports include all feedback, but only the content (description field) of some types of feedback is included in the export:

• The content of the feedback is included for all feedback that is created in Productboard, the Portal, or via the Chrome extension or email.
  
• The content of the feedback is not included for feedback that is created via third-party applications such as Zendesk, Slack, and Intercom. For this feedback, all data is exported except for the content. (The note_text field is left blank.)
  

Exporting all feedback with associated features

If you want to maintain a record of the features associated with certain feedback, use this export option. This API endpoint will provide you with the same information as the one above and will also include the following: 

• feature_name: The name of the feature the feedback is assigned to. 
• feature_id: The id number of the feature.
• parent_feature_id: The parent feature id number if the feedback is assigned to a subfeature. 

To export all feedback with associated features:

1. Make sure you're signed in to your Productboard workspace.

2. Paste this URL into your browser:

   https://[your_workspace].productboard.com/api/notes/export?export_type=with_features

3. Insert your workspace's name into the URL. (When you're logged into Productboard, this will be at the beginning of the URL, before "productboard.com".)
4. Press enter, then wait. You will receive an email with the csv export in a few minutes.
5. Open the email and click the link inside it. A new webpage will open.
6. Click Download on the new page to download a CSV containing your exported feedback and features. 

Stripping HTML from exported feedback

By default, the description fields of exported feedback includes HTML formatting.

However it is possible to export feedback without the HTML formatting. 

To export without HTML, append the following parameter to the export URL:

&strip_html=true

So the final URL you enter in your browser might look like this:

https://[yourworkspace].productboard.com/api/notes/export?export_type=with_features&strip_html=true

Troubleshooting

When exporting features and feedback into a CSV, Excel will sometimes misformat special characters. In order to resolve this, the CSV needs to be imported to Excel in a specific manner.

In Excel:

1. Go to the Data tab.
2. Select in the database icon, Get Data...
3. Select from text/ CSV, then pick the CSV export file.
4. There will be a preview of the imported file. There’s nothing to change here but click on the Load button.
5. Then the CSV is perfectly imported.

See also:

• Exporting your features into a CSV
• How can I find my workspace name?