How to deal with 700+ pdf files in one sheet
I have been tasked with creating a universally-accessible spreadsheet for our Safety Data Sheets using the online version of excel. There are well over 700 separate PDFs that I need to figure out how to either: a) incorporate into this excel sheet or b) create links to the PDFs.
The second option would be tricky though, because the links to the PDFs lead to a website that you need to be logged into. The purpose of this project is to circumvent this to access the Safety Data Sheet PDF faster, in the event of an emergency.
I tried converting one of the PDFs to a .xlsx file, but that just opens the desktop version of excel, which not everyone has access to. So now I am trying to figure out how to build this sheet in such a way that isn’t a jumbled mess, and gives quick and easy access to the staggering number of PDFs.
I really only have a slightly more than basic understanding of how this program works, so any advice would be much appreciated.
[link] [comments]
Want to read more?
Check out the full article on the original site