How can we help you today?

Go ahead and ask us anything.

See the KanBo newest version.

Export KanBo Board View to Excel

Last modified:

With this KanBo functionality, you can export a Board's content into a .csv file.

This will help you display it in a highly visual manner in Excel and use it i.e. for reporting.  

To export a Board, simply select the following button on the top pane. 

Image 11810

Now you can select Export view to file.

Image 11809


Now the download of the .csv file will start. Once it's done, you can import this .csv file to Excel.

This instruction's screenshots were made in Excel 2016, however the functionality will be very similar also in the older versions of Excel. See documentation provided by Microsoft regarding importing .csv files into Excel:

To import the Boards csv file to Excel, go to Excel and select Data and then, Get data.

Image 5582

Now select From File and in the next step, from Text/CSV.

Image 5583

Browse for your freshly downloaded file and select it.

Image 5584

In the windows which will appear, select Load button.

Image 9500

In a couple of seconds, your Board will be visible as an Excel table.

It will contain information about:

  1. Card ID, 
  2. Card name, 
  3. List name, 
  4. Status name,
  5. Status role (or list role, if statuses are disabled), 
  6. Responsible,
  7. Co-workers,
  8. Created by,
  9. Created date,
  10. Start date,
  11. Due Date,
  12. Late (YES/NO),
  13. Completed date,
  14. Completed by,
  15. Completed (YES/NO),
  16. Todo items,
  17. Labels,
  18. Card link

    Image 9499

    This article was helpful for 5 people. Is this article helpful for you?