I have never used excel so forgive me if I'm misunderstanding what you are trying to achieve, but couldn't you use a combination of Scrivener's outline view, keywords, and collections to achieve this?
It's easy to add custom metadata to the outline for showing everything side by side, and if you use the index cards for summaries of findings it can auto-populate it anyway. The other way I can think of is to use a combination of keywords and collections to gather the items you need together, then view them in the outline, index cards or scrivenings, depending on how you choose to organise your information. Using subdocuments to hold key quotes or summaries of a pdf text is something I find very useful for being able to collect and see exactly what I want, and only that, at any given time.
I'm worried I'm not being clear about my meaning here, but I know I could also be missing the point as I'm not aware of excel's functions, so I'll stop rambling, but I can try to be clearer if it might be helpful.
It's easy to add custom metadata to the outline for showing everything side by side, and if you use the index cards for summaries of findings it can auto-populate it anyway. The other way I can think of is to use a combination of keywords and collections to gather the items you need together, then view them in the outline, index cards or scrivenings, depending on how you choose to organise your information. Using subdocuments to hold key quotes or summaries of a pdf text is something I find very useful for being able to collect and see exactly what I want, and only that, at any given time.
I'm worried I'm not being clear about my meaning here, but I know I could also be missing the point as I'm not aware of excel's functions, so I'll stop rambling, but I can try to be clearer if it might be helpful.