Skip to main content
Importing feedback

Create posts in your Canny boards by uploading a CSV (spreadsheet file)

Jacques Reulet avatar
Written by Jacques Reulet
Updated over a year ago

Do you have a backlog of ideas already in a spreadsheet? 

This feature is ideal for newcomers to Canny or for new teams within your company looking to leverage Canny.


How it works

Firstly, make sure to prepare your CSV file. We support importing Post title, description, status, and tags. For instance:

  • Title: Dark Theme

  • Details: Enable an option for a dark theme on the app. Users should be able to toggle at will. This will reduce eye strain and lessen battery consumption on mobile screens.

  • Status: Under Review

  • Tags: Q2, Low priority
    [add as many tags as you like, just make sure they're comma-separated]

  • Category: Look & Feel

Only one field is required: Title. If you're moving from a different tool, you can usually export your data. If a CSV export isn't an option, you should be able to convert it by using something similar to this JSON to CSV converter. For importing tags, use comma-separated values (e.g. tag1, tag2, tag3).


Please note:

  • Any statuses not matching current statuses will create new statuses (for users on the Growth plan and above).

  • Posts with no status default to Open.

  • If a post on the spreadsheet has the same title, the existing post will be overridden with new values.

  • Posts via this method are attributed to the uploading admin.

  • Posts can also be created (and attributed to users) via the API. User votes can be assigned via API after post creation.


Step-by-step

1. Head to the Boards tab in your Canny Settings, and select the "Import Data" tab.

2. Upload your CSV file.

3. Align your info with the data in each column. 

  • Make sure you toggle "First row is the header" if you have a header row so that row isn't imported as a separate post.

  • The "Skip" option will simply ignore that column. Only Title, Details, Status, Tags, and Categories will be imported.

4. Click "Import"! 

Our team of highly skilled robots will handle the rest.🦾

Happy importing! Feel free to reach out with any questions. By the way, feel free to check out the Canny API for further automated options!


Related Articles:

Did this answer your question?