You can download every idea in a collection as an Excel file (.xlsx), which also opens in Google Sheets and Numbers. The Export button is on the collection’s dashboard.
Who can do this: collection managers and Admins.
Export a collection
- Open the collection and select the Manage tab.
- Click Overview in the sidebar.
- Make sure the Dashboard tab is selected.
- Click Export at the top right.
The file downloads straight away. It is named after the collection and today’s date.
What the file contains
There is one row per idea, oldest first. The export includes every idea in the collection, including hidden ideas and ideas in hidden steps.
| Column | What it holds |
|---|---|
| Collection | The collection’s title |
| Step | The step the idea is in, or “Inbox” |
| Contributors | Names of the people who shared the idea |
| Emails | Their email addresses |
| Created | The date the idea was submitted |
| Title | The idea’s title |
| Content | The idea’s description |
| Views | How many times the idea has been opened |
| Reactions | Number of likes or votes |
After these come the answers to the submission form questions, one column per question:
- Text and number questions: the answer.
- Option questions: one column per option, with 1 if it was chosen and 0 if not.
- Scoring questions: one column per criterion, with the score.
What isn’t exported
- Comments
- Files and attachments
- Answers to step and Inbox questions, including answers kept from deleted steps and questions (only the submission form is exported)
- Assignees
Names and anonymity and the export
If the collection has Hide names or Save contributions anonymously turned on, the Contributors and Emails columns are left out completely. See Collection settings explained.
Good to know: The export can contain names, email addresses and hidden ideas. Store and share the file with care.
Common questions
Can I export several collections at once? No. Export each collection separately.
Can I export comments or step scores? Not in the spreadsheet. To keep one idea with its comments and step answers, open the idea, click ⋯ and choose Export as PDF. Pick what to include, then click Export PDF. Only collection managers and Admins see this option. Collection managers can also see scores in the Voting and Scoring views of each step. See Rating ideas and answering step questions.
Can I export survey answers? Yes, from the survey itself. See Survey results, results link, export and AI summaries.