User Tools

Site Tools


linux:extract-metadata

Extract Metadata

Exiftool - while initially used to extract and manipulate EXIF data of image files - can be used to extract meta data for a large amount of files including MS Office xlsx/docx/etc, Openoffice files, videos, audio files etc.

Current list of supported file types: https://www.sno.phy.queensu.ca/~phil/exiftool/#supported

To use, just install it

sudo apt-get install exiftool

then point it to a file, e.g.:

exiftool SmallCap\ Funds\ 2019-10-15.xlsm

Output is as following:

ExifTool Version Number         : 10.80
File Name                       : SmallCap Funds 2019-10-15.xlsm
Directory                       : .
File Size                       : 962 kB
File Modification Date/Time     : 2019:10:15 16:30:37+01:00
File Access Date/Time           : 2019:10:16 18:59:32+01:00
File Inode Change Date/Time     : 2019:10:16 18:59:27+01:00
File Permissions                : rw-------
File Type                       : XLSM
File Type Extension             : xlsm
MIME Type                       : application/vnd.ms-excel.sheet.macroEnabled
Zip Required Version            : 20
Zip Bit Flag                    : 0x0006
Zip Compression                 : Deflated
Zip Modify Date                 : 1980:01:01 00:00:00
Zip CRC                         : 0x828075c7
Zip Compressed Size             : 831
Zip Uncompressed Size           : 9690
Zip File Name                   : [Content_Types].xml
Application                     : Microsoft Excel
Doc Security                    : None
Scale Crop                      : No
Heading Pairs                   : Worksheets, 14, Named Ranges, 4
Titles Of Parts                 : SMCO, AIM VCT, AIM IHT, Quartet Fund, SMCO Top 20, AIM VCT Top 20, AIM IHT Top 20, SMCO weights, AIM VCT Weights, AIM IHT Weights, SMCO Liquidity, AIM VCT Liquidity, AIM IHT Liquidity, Sectors list, DIST_RU_COL, 'Quartet Fund'!Print_Area, SMCO!Print_Area, 'SMCO Top 20'!Print_Area
Company                         : SICO
Links Up To Date                : No
Shared Doc                      : No
Hyperlinks Changed              : No
App Version                     : 14.0300
Creator                         : PC department
Description                     : Last saved:...15/10/2019 16:28:00
Last Modified By                : Fidessa
Last Printed                    : 2019:03:07 08:59:16Z
Create Date                     : 2000:04:27 14:51:41Z
Modify Date                     : 2019:10:15 15:28:01Z
linux/extract-metadata.txt · Last modified: 2023/05/29 11:55 by 127.0.0.1