A friend of mine has created a list of books for his school library in MS Word. It is about 30 pages long.



It's a tab delimited list that currently has the author's name, the title of the book and a unique number for each book. The list is not used for keeping track of students who borrow the books.

I'm wondering what advantages there might be in converting the Word document to Excel?

I guess converting it to Excel would make it possible to sort each of the columns alphabetically but I wonder what other advantages there might be?

Thank you advance for your advice!!

Maybe filtering, Pivot Tables, Charting, and if you ever did use it for keeping track of who borrowed what, you can tally up the students names.

Of course, as is in my case, I know Excel much better than I do Word, so can't really speak for the advantages of keeping such a list in Word.

Thank you! Didn't think about filtering. Would be very useful for finding all the books by a certain author and so on... I'll suggest he tries converting it to Excel.

You are very welcome. Happy to help!