Automatically generating a Literature Matrix as an Excel Journal Database with Scholarcy

Last year, Stephen McQuilliam created an excellent video on creating an interactive Journal Database using Excel slicers: • Excel Journal Database
In this video, we look at implementing this Literature Matrix database an export from Scholarcy Library, so the initial work on creating the database is done for you. I hope this is useful for your literature reviews and critical analyses.

[@alanoodhamouri9278]

Thank you for refering for the original video!
this helped me to make my literature review catalog!

[@antonioliriololi]

A very good idea!

[@SherlyHasanKhan]

Very awesome

[@qusay6948]

Thank you.

[@PMF2022]

❤

[@nzrina80]

You cant really "sliced" with keywords as the keywords are exported in a paragraph not as word by word. Anybody know how to come over this issue?

[@scholarcy]

We could split the keywords into separate columns: keyword1, keyword2, keyword3, but this could soon get unwieldy. Unless we just show the top 5 keywords? Each in their own column. We could consider that

[@hazmanjazimin]

hello scholarcy can we add one reseach question and problem ?

[@AnandDatla]

Can you please share an excel template for producing a literature matrix?

[@scholarcy]

Hi Anand, Scholarcy generates the template automatically as part of the export, but if you want to create your own, the link to Stephen McQuilliam's tutorial is in the video description and also here: ua-cam.com/video/Y40Wy1guAiQ/v-deo.html

[@Maria-nz3mz]

can i make lit matrix in free version?

[@scholarcy]

Hi Maria, this is a Scholarcy Library feature, which is a paid product - we have a 14 day free trial