Consolidate user research & feedback stored in spreadsheets (or solutions like CRMs or survey tools that support CSV export) by importing them to your Insights board as new notes. From there you can spot trends and link user insights to related feature ideas.
When uploading your spreadsheet, you'll need to use certain Productboard-supported headers to help us understand your data.
In this article:
Import notes
- On any insights board, hover over the blue plus button and select Import notes.
- The importer includes CSV and Excel templates that will help Productboard read your data. Download the sample CSV or Excel template and paste the supported Productboard headers into the correct columns of your own data. Alternatively, treat the sample file as a template and paste your data into it beneath the correct column.
When you're ready, save your spreadsheet in either CSV (UTF-8 encoded) or XLSX format, then drag and drop it into the center of the importer page or browse for it using the Browse link.
The importer will allow you to review the notes you're about to import. If you're happy with them, click Import X notes to complete the import process.
Note: If your spreadsheet contains more than 5,000 notes, we recommend you split the upload into batches to maximize performance.
Data fields explained
When importing your user research/feedback as new notes, only the note_text field is required, but any additional data imported now will make Productboard more powerful for your team and save you time later. For example, importing the domains of your customer companies will allow Productboard to automatically display their logos. And importing customer emails will allow your colleagues to delight them with notifications when their requested features go live.
note_title
- Title of the note
- e.g. Phone call with Elon
note_text*
- User input contained within the note
- ⚠️ The only required data field when importing notes.
- e.g. I would send your product to Mars as an example of a great human achievement.
person_name
- Name of the user who provided this input
- Displayed in a note's user/company field
- e.g. Aaron Samuels
person_email
- Email of the user who provided this input
- This will help you notify users when a feature they've requested goes live.
- e.g. Aaron@apple.com
company_name
- Name of the company that provided this input
- Displayed in a note's user/company field
- e.g. Apple
company_domain
- Website domain (e.g. envoy.com) for auto-displaying company logo
- ⭐️ Allows Productboard to automatically display logos for these companies.
- e.g. apple.com
tags
- Tags to categorize notes on Insights board
- e.g. love,ui
owner_email
- Email of the colleague who collected the feedback
- ⚠️ Must be a member of your Productboard workspace with contributor, editor, or admin role.
- Your colleague will be assigned ownership over this note and will receive notifications for all subsequent updates.
- e.g. colleague@yourcompany.com
note_date
- Must be correctly formatted in as either YYYY-MM-DD or YYYY-MM-DD hh:mm:ss.
- If formatted incorrectly or left blank, will default to the current date.
Auto-import new notes from a spreadsheet on an ongoing basis
If you've got an existing Google sheet your team uses to track incoming feedback or survey results, you can use Zapier to send every new row into Productboard as a new note. This is best when you're looking to create new notes on an ongoing basis, rather than perform a one-time import.