Table of contents
Introduction
You can export your product’s suggestions, comments, and votes in CSV format, suitable for use with Excel and other applications. You might want to do this because:
- You want to analyse your data
- You want to move all data into another system
How to export suggestions
Select the ‘configure’ option from the dashboard for the product whose data you want to export.
Select ‘export’.
Choose from the three options – or choose all of them.
Each button starts a file download.
The files include suggestion IDs, comment IDs, and upvote IDs as appropriate. These can be used to connect the comments and upvotes to suggestions.
Tips for loading a CSV export into Excel
Suggestion descriptions may have multiple paragraphs, and this can lead to difficulties getting the data into Excel. How you can best do this depends on your computer’s operating system, the language your computer is running in, and your version of Excel.
Here are some tips to help smooth the process:
On Mac
Double-click on the CSV file, and it should be loaded into Excel with the correct formatting.
On Windows
Opening the CSV file directly into Windows may result in some formatting issues.
- Open the CSV file using Notepad or a similar text editor
- Select all the text and copy it into your computer’s clipboard. Use Ctrl+C or, from Notepad’s Edit menu, select Copy.
- Switch to Excel, and use Edit -> Paste