Link to home
Create AccountLog in
Avatar of Bryant
BryantFlag for United States of America

asked on

Script for OneDrive to Excel


I have thousands of files in OneDrive and I would like to be able to capture the names of them as well at hyperlinks to the file in a spreadsheet. All of the files are sync'd to my local machine so it would be grabbing the name and setting a hyperlink for the location. Is that even possible? If that is not possible, the name column exported to CVS will have to work.

Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

Link to home
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Bryant


After reading your comments I went another route. What I ended up doing was sharing the folder in OneDrive to everyone in the office so they could search within OneDrive itself and not worry about a spreadsheet. The owner was worried about security at first, but after they saw other users would only be able to see what was shared they were fine.