Exporting file data into a spreadsheet

In the recent case of Willett v Redflex Traffic Systems Inc., the defendants stated that it had scanned and searched what is called “a high-level directory of the data”, and that it produced a spreadsheet of this directory.

cache_39627703a0b9This spreadsheet had 538,000 rows, and it includes the following information:

  • File name,
  • File Type,
  • File Size,
  • Creation date, and
  • Last Modified date.

It is not stated how this information was created. Certainly it could not be through the standard MS-DOS “CMD”, because that would not include both sets of dates.

cache_371053708e80Production of such information is easy using our file cataloger Filecats Standard. Not only will it produce that data in an Excel spreadsheet, but it also creates a hyperlink to the file and to the folder, so that both can be opened directly from the spreadsheet, and also includes last accessed date. Filecats Standard can also produce this with minimal expenditure.

The case doesn’t say whether the spreadsheet also included file path, but presumably it would have not. It also didn’t say whether attributes such as Read-Only and Hidden were also added. These are included as standard by our cataloging programmes.

For some reason, by the time of the hearing, the Defendants had not handed over this spreadsheet to the Plaintiffs, but were ordered to do so by the court.

cache_363599294682Whilst useful, this information might not go far enough. For example, it is notable that author information is not included in the list – this would have been a requirement had this case been held in the jurisdiction of England.

Such additional information easily can be generated by our file cataloguer and metadata extractor, Filecats Professional.

  • It can include the user name of the originator of a Word document, or who last saved an Excel spreadsheet.
  • For photographs, the camera make and model, resolution and GPS coordinates (if available) are also available.
  • For emails exported to MSG format, a host of data is easily available, such as sender, recipients, attachments and even the body of the text.
cache_35653927 cache_35653926 cache_35653925 cache_35653924 cache_35653923 cache_35653922 cache_35653921 cache_35653920 cache_35653919 cache_35653918 cache_35653917 cache_35653916 cache_35653915 cache_35653914 cache_35653913 cache_35653912 cache_35653911 cache_35653910 cache_35653909 cache_35653908 cache_35653907 cache_35653906 cache_35653905 cache_35653928

If you don’t have Excel, then why not try Filecats Explore and Filecats Metadata, which export the same information to a self-contained table?

Do you have a similar problem? Do you need to create a spreadsheet with details of your computer’s drives? If so, why not download Filecats Standard or Filecats Professional, and take it for a free 7-day trial. You can be one step closer to harnessing your files.

Other articles.

This website is intended to give general information and does not constitute legal advice. Should you require legal advice please consult a fully qualified and regulated legal advisor.

Leave a Reply

Your email address will not be published. Required fields are marked *