-
Learn the Basics
-
- Spaces
- Space Types
- Creating Spaces
- Adding Users to Spaces
- Space Activity Stream
- Following Spaces
- Space Details
- Space Dates
- General Space Settings
- Duplicating Spaces
- Renaming Spaces
- Changing the Space Color and Icon
- Leaving Spaces
- Removing Users from Spaces
- Moving Spaces between Workspaces
- Moving Spaces between Different KanBo Environments
- Closing and Reopening Spaces
- Deleting Spaces
-
Visualize Work
-
Collaborate
-
Level Up Your Work
-
Resource Management
-
Work Securely
-
Integrations
-
- Microsoft Teams Integration
- Notifying KanBo Users in Microsoft Teams
- Opening KanBo in Microsoft Teams
- Sharing Microsoft Teams Messages and Posts as Notes in Cards
- Adding KanBo Tabs in Teams Channels
- Integrating Workspaces with Microsoft Teams
- Integrating Spaces with Microsoft Teams
- KanBo Link Unfurling
-
- Importing Microsoft Planner Plans into KanBo
- Exporting KanBo Space Views to Excel
- Visitors in Microsoft 365 Environments
- Adding KanBo Modern Web Part to SharePoint Site
- Autodesk BIM Integration
- ServiceNow Integration
- Zapier Integration
- KanBo and Nintex Integration
- UiPath Integration
- Azure Logic Apps Integration
- Power Automate Triggers and Actions in KanBo
- Advanced KanBo Actions in Power Automate
- Creating Document Folders in Document Libraries Created by KanBo with Power Automate
- Creating KanBo Space Attached to Subfolder Created by Power Automate
-
Exporting KanBo Space Views to Excel
In this article:
Overview
You can export the current space view to a CSV file and then open it in Microsoft Excel. The space will appear as a table containing card details. This space can easily be printed when presented this way.
Example: KanBo space imported to Excel. Each line is another card.
We can narrow down the number of exported cards using the filter settings. For example, we can select cards with a specific user. Only visible cards will be exported.
The Excel table will contain information about:
- Card ID
- Card name
- Status name
- Status type
- Responsible person
- Contributors
- Checklist items
- Custom fields (Lists, Labels)
- Start date
- Due date
- Late (YES/NO)
- Completed (YES/NO)
- Completion date
- Completed by
- Creation date
- Created by
- Card link
If you need to export a card from another space as well, add it to the space as a mirror card.
Exporting space views to CSV files
Pay attention to the space view filtering settings. Only information about the cards visible in the current view will be exported.
To export a space view:
- Open the space.
- On the space top bar, select
More. - In ACTIONS select
More actions >
Export space view as CSV file.
Importing CSV files to Excel
Opening a CSV file directly in Excel may cause issues with data display. See how to import the data correctly.
To import a CSV file with KanBo space to Excel:
- Open Excel, and select Blank workbook.
- On the top bar, go to Data.
- Select Get data > From file > From Text/CSV.
- Browse for the downloaded CSV file, and the select Import.
- An overview window with the space data will appear. Select Load.
Was this article helpful?
Please, contact us if you have any additional questions.
