After you've exported your Insights by visiting your chosen Insight page and selecting "Export" (here's a handy article on how to do that) a download of a .CSV file will be triggered - but what do you do with it?

.CSV Files can be quite intimidating if you're not familiar with them - sometimes it looks like a whole heap of confused data and you're not sure on how to understand it.

Here's some top tips on how you can understand your export reports and make sense of some of the data it shows you - we promise it's useful to know!

1. Remember - a .CSV is not technically an Excel file.

Sure, Excel is great! But sometimes it doesn't really understand the data that it's being shown. This is especially true if you're trying to simply open the .csv into Excel without using the proper processes. Sometimes it will just confuse you!

Try using the 'Import' function on Excel if you're a bit perplexed.

2. Understand who your most engaged Users are

Identifying your Learning champions is the best way to make sure that the message of your Learning and Development strategy is going to spread. This 'viral spread' of knowledge between your Users and employees is what is going to ensure that the information shared is always useful, accurate and valuable!

You can do this by reviewing your User Insights - let's have a look at how to do this below

3. Identify content creation opportunities

Reviewing your Channels is a great way of ensuring that all areas of your organisation get the love that they need!

Since Channels are a mandatory field when creating content, you'll be able to identify opportunities for certain less-engaged areas of the company than others and you'll be able to effectively identity the most keen knowledge-sharing ones!

4. Create your own Graphs to understand User Completion

We get it - some people don't like looking at sheets of swirling data (I'm a visual learner too!) and you can easily collate data on your Content Insights by clicking the right buttons in Excel.

Here's a very simple way to extract data into a visual Graph for you to share with your colleagues

You might also be interested in:

Did this answer your question?