Got a tip for us?
Let us know
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
Exporting Local Movie Inventory to Spreadsheet
- Thread starter Jashue
- Start date
- Sort by reaction score
I put my movie files in separate folder and name the folder based on movie title ("inception.mkv" in folder named, "Inception"). MS-DOS can search a drive and list folder names and output to a text file. Then copy/paste the list into a spreadsheet.
I’d avoid using an app since it could break or lose support. A spreadsheet is more flexible and future-proof. Store it on Cloud server, so you can access it from anywhere. Google “movie spreadsheets” for templates.
I’d avoid using an app since it could break or lose support. A spreadsheet is more flexible and future-proof. Store it on Cloud server, so you can access it from anywhere. Google “movie spreadsheets” for templates.
where is your library?
All my movies are on my Mac, if I use the list view, I can select any and all and paste into a spreadsheet ...
I have over 1,000 movies on 7 USB drives and use a media player to watch them. I installed Bootcamp and used DOS code to scan my drives and put folder names in a text file. After I got my large list, I pasted it in Excel and update the spreadsheet on the Cloud when I want to add/delete a movie. Also, organized it so that it lists the drive location and file format (HD, 4K, etc.), so I know what I have and where to find it.
I have done similar in the past. If the library is listed in the Mac TV app switch to list view and select all and paste into spreadsheet.