{"id":14603,"date":"2021-08-09T12:15:47","date_gmt":"2021-08-09T16:15:47","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=14603"},"modified":"2021-08-09T12:29:18","modified_gmt":"2021-08-09T16:29:18","slug":"discovering-spreadsheet-metadata","status":"publish","type":"post","link":"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/","title":{"rendered":"Discovering Spreadsheet Metadata in IRI Workbench"},"content":{"rendered":"<p>Abstract: <i>Getting the correct metadata in a simple way is an important part of building structured data processing, protection, presentation, and prototyping jobs in IRI software. <\/i><a href=\"https:\/\/www.iri.com\/products\/cosort\/sortcl\"><i>SortCL<\/i><\/a><i>, the underlying data manipulation engine behind most IRI products, can now transform, migrate, consolidate, mask, and cleanse &#8212; among other functions &#8212; data in Excel spreadsheets, and <\/i><a href=\"https:\/\/www.iri.com\/products\/workbench\/discover-data\"><i>IRI Workbench<\/i><\/a><i> offers an intuitive interface for building out this metadata and the jobs that use it.<\/i><\/p>\n<p>The <a href=\"http:\/\/www.iri.com\/blog\/etl\/xls2ddf-metadata-conversion-utility\/\">previous article<\/a> covered the creation of Data Definition Format (<a href=\"https:\/\/www.iri.com\/products\/cosort\/sortcl-metadata\">DDF<\/a>) metadata files for IRI <a href=\"https:\/\/www.iri.com\/products\/cosort\/sortcl\">SortCL<\/a>-compatible applications from spreadsheet data layouts via the <b><i>xls2ddf<\/i><\/b> conversion utility. That same metadata can also be generated in <a href=\"https:\/\/www.iri.com\/products\/workbench\">IRI Workbench<\/a> more graphically through the <a href=\"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-metadata-discovery-wizard\/\"><i>Discover Metadata<\/i><\/a> wizard, which will also display a preview of data in any connected sheet.<\/p>\n<p>This wizard can also run within new job wizards launched from the IRI Workbench top toolbar menus for Voracity, CoSort, NextForm, FieldShield, and RowGen during their Data Source (or Target) specification phase. The metadata discovered therein can immediately populate the \/INFILE (or \/OUTFILE) section in the ultimate job script, or be saved to a .DDF file for re-use in other SortCL-compatible applications.<\/p>\n<p>When selecting an Excel file from the <i>Browse \u2026<\/i> feature in the Discover Metadata wizard, the file extension (XLS or XLSX) will dictate the \/PROCESS format specified in the SortCL job script automatically. There are then a few options regarding the layout of the workbook itself to choose from.<\/p>\n<p>Following are images and descriptions demonstrating the use of the Discover Metadata wizard on a spreadsheet (in either .xls or .xlsx format). Our example uses this spreadsheet data:<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2021\/08\/wpreadsheet-metadata-WBView.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14606 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2021\/08\/wpreadsheet-metadata-WBView.png\" alt=\"\" width=\"550\" height=\"584\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/wpreadsheet-metadata-WBView.png 685w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/wpreadsheet-metadata-WBView-283x300.png 283w\" sizes=\"(max-width: 550px) 100vw, 550px\" \/><\/a><\/p>\n<p>Displayed below is the first page of the wizard: Data Source Identification. Here, the file is selected, format is determined, and options can be set such as sheet name, whether the sheet includes a header, and whether the data is oriented with each column representing a new record, rather than a new field.<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-data-source.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14607 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-data-source.png\" alt=\"\" width=\"650\" height=\"457\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-data-source.png 993w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-data-source-300x211.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-data-source-768x540.png 768w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/a><\/p>\n<p>There should be a list of all the sheets in the workbook to choose from in the wizard. Only one sheet of the file can be selected per \/INFILE section of the ultimate SortCL-compatible job script. If multiple sheets in the workbook must be processed, then multiple \/INFILE sections must be specified.<\/p>\n<p>Additionally, there are checkboxes to indicate whether the sheet includes a header row (or column) and whether the data is vertically arranged (i.e., rows should be processed vertically rather than horizontally). If the option to indicate the sheet includes a header is selected, the field names will be taken from that header row; otherwise, field names are produced generically (FIELD1, FIELD2, etc.).<\/p>\n<p>All these options must be specified in the \/(IN\/OUT)FILE line. When the spreadsheet file has been selected through one of the IRI Workbench wizards, all of the options specified during the wizard will be put into the \/(IN\/OUT)FILE line.<\/p>\n<p>Note that the DDF file generated by the Discover Metadata wizard will have a file line with all that information included in a commented-out line near the top of the file. File line options can also be modified, created, or deleted by hand of course, or graphically through the <b><i>Edit Source Options<\/i><\/b> menu, accessible from the <b><i>Edit Sources<\/i><\/b> menu in the IRI context menu viewed by right clicking a SortCL script.<\/p>\n<p style=\"text-align: center;\"><a href=\"\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-data-veiwer.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14609 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-data-veiwer.png\" alt=\"\" width=\"650\" height=\"457\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-data-veiwer.png 993w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-data-veiwer-300x211.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-data-veiwer-768x540.png 768w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/a><i>Displayed in this image is the second page of the Discover Metadata wizard, which includes a preview of the data from the file and sheet selected on the previous page.<\/i><\/p>\n<p>&nbsp;<\/p>\n<p>In addition to discovering spreadsheet metadata, IRI Workbench can generate a <a href=\"https:\/\/www.iri.com\/blog\/vldb-operations\/data-classification-in-iri-workbench\/\">Data Class library<\/a> with files that can include XLS and XLSX file types. This feature is especially useful in configuring data masking jobs for PII in Excel sheets using IRI FieldShield or Voracity ETL scripts to protect that data directly.<span id='easy-footnote-1-14603' class='easy-footnote-margin-adjust'><\/span><span class='easy-footnote'><a href='https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/#easy-footnote-bottom-1-14603' title='Note that with this feature, IRI FieldShield becomes the third data masking product in Voracity, after CellShield EE and DarkShield, to directly mask data in Excel sources (and targets). The three tools are all front-ended in the same UI, IRI Workbench, leverage the same global data class definitions, and share the same core masking functions (encryption, redaction, pseudonymization, and hashing). By virtue of its SortCL framework, FieldShield can thus offer what the other shield tools do not: metadata compatibility and same-script data processing (beyond masking) for data in sheets (along with other structured data sources), including data integration (ETL), cleansing, migration, reporting.'><sup>1<\/sup><\/a><\/span><\/p>\n<p>This is done by traversing through the New Data Classification Source Wizard. Sensitive data, or specific data in general, can be searched for through values matching patterns (Java regular expressions), strings in set files (files with a set of values to match against), or in the case of DarkShield and CellShield EE, Named Entity Recognition *NER) models which use Natural Language Processing (NLP).<\/p>\n<p>The method and details of the search can be saved as a data class and given a name. Then, rules can be set up to determine what manipulations should be performed when a certain data class is matched with a high enough percentage (or user specified).<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-dataclasslib.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14608 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-dataclasslib-1024x674.png\" alt=\"\" width=\"651\" height=\"428\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-dataclasslib-1024x674.png 1024w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-dataclasslib-300x198.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-dataclasslib-768x506.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-dataclasslib.png 1075w\" sizes=\"(max-width: 651px) 100vw, 651px\" \/><\/a><\/p>\n<p>After setting up rules to protect the sensitive data in this file, the New Data Class File Masking Job wizard can be run from the FieldShield menu. This will take the rules and files in the data class library to generate a flow diagram, a batch script, and resulting SortCL scripts.<\/p>\n<p>In this example, rules were set to protect the three fields with format preserving encryption, in-place pseudonymization\/shuffle (using a set file of the existing data), and external pseudonymization (set file with data of the same category but likely not containing the same entries), respectively.<\/p>\n<p>Across the top of the IRI Workbench screenshot below are three different views of the same SortCL job transforming the data defined in DDF \/FIELD layouts. The data class library editor leveraging those layouts is shown bottom left, and the masked data results are shown in the Excel pane bottom right.<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-collage.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14610 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-collage-1024x555.png\" alt=\"\" width=\"649\" height=\"352\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-collage-1024x555.png 1024w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-collage-300x163.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-collage-768x416.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-collage.png 1600w\" sizes=\"(max-width: 649px) 100vw, 649px\" \/><\/a><\/p>\n<p>This concludes our series on IRI software support for XLS and XLSX spreadsheets in SortCL-compatible programs that process, protect, present and prototype structured data. To return to the first article, <a href=\"http:\/\/www.iri.com\/blog\/etl\/processing-spreadsheet-data\/\">click here<\/a>. For additional information, contact your IRI <a href=\"https:\/\/www.iri.com\/company\/contact\">representative<\/a>.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Abstract: Getting the correct metadata in a simple way is an important part of building structured data processing, protection, presentation, and prototyping jobs in IRI software. SortCL, the underlying data manipulation engine behind most IRI products, can now transform, migrate, consolidate, mask, and cleanse &#8212; among other functions &#8212; data in Excel spreadsheets, and IRI<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/\" title=\"Discovering Spreadsheet Metadata in IRI Workbench\">Read More<\/a><\/div>\n","protected":false},"author":119,"featured_media":14610,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[8,776,91,233],"tags":[1304,1090,14,644,546,520,553,526,1204,789,850,598,620,621],"class_list":["post-14603","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-protection","category-etl","category-iri-workbench","category-metadata-management","tag-data-class","tag-data-class-library","tag-data-masking","tag-excel-spreadsheet","tag-iri-cosort","tag-iri-fieldshield","tag-iri-nextform","tag-iri-rowgen","tag-iri-sortcl","tag-iri-voracity","tag-iri-workbench","tag-microsoft-excel","tag-xls","tag-xlsx"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Discovering Spreadsheet Metadata in IRI Workbench - IRI<\/title>\n<meta name=\"description\" content=\"Getting the correct metadata in a simple way is an important part of building structured data processing, protection, presentation, and prototyping\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Discovering Spreadsheet Metadata in IRI Workbench - IRI\" \/>\n<meta property=\"og:description\" content=\"Getting the correct metadata in a simple way is an important part of building structured data processing, protection, presentation, and prototyping\" \/>\n<meta property=\"og:url\" content=\"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-09T16:15:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-09T16:29:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-collage.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1600\" \/>\n\t<meta property=\"og:image:height\" content=\"867\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Devon Kozenieski\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Devon Kozenieski\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/\"},\"author\":{\"name\":\"Devon Kozenieski\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/de972c035aaeecfc40a3ae2ea5ff7ba1\"},\"headline\":\"Discovering Spreadsheet Metadata in IRI Workbench\",\"datePublished\":\"2021-08-09T16:15:47+00:00\",\"dateModified\":\"2021-08-09T16:29:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/\"},\"wordCount\":1035,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-collage.png\",\"keywords\":[\"data class\",\"data class library\",\"data masking\",\"Excel spreadsheet\",\"IRI CoSort\",\"IRI FieldShield\",\"IRI NextForm\",\"IRI RowGen\",\"IRI SortCL\",\"IRI Voracity\",\"IRI Workbench\",\"Microsoft Excel\",\"xls\",\"xlsx\"],\"articleSection\":[\"Data Masking\/Protection\",\"ETL\",\"IRI Workbench\",\"Metadata Management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/\",\"url\":\"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/\",\"name\":\"Discovering Spreadsheet Metadata in IRI Workbench - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-collage.png\",\"datePublished\":\"2021-08-09T16:15:47+00:00\",\"dateModified\":\"2021-08-09T16:29:18+00:00\",\"description\":\"Getting the correct metadata in a simple way is an important part of building structured data processing, protection, presentation, and prototyping\",\"breadcrumb\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/#primaryimage\",\"url\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-collage.png\",\"contentUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-collage.png\",\"width\":1600,\"height\":867},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/beta.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Discovering Spreadsheet Metadata in IRI Workbench\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#website\",\"url\":\"https:\/\/beta.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/beta.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/beta.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/de972c035aaeecfc40a3ae2ea5ff7ba1\",\"name\":\"Devon Kozenieski\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/19bf36cedac5d586ea168f58f96eb2f1?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/19bf36cedac5d586ea168f58f96eb2f1?s=96&d=blank&r=g\",\"caption\":\"Devon Kozenieski\"},\"url\":\"https:\/\/beta.iri.com\/blog\/author\/devonk\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Discovering Spreadsheet Metadata in IRI Workbench - IRI","description":"Getting the correct metadata in a simple way is an important part of building structured data processing, protection, presentation, and prototyping","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/","og_locale":"en_US","og_type":"article","og_title":"Discovering Spreadsheet Metadata in IRI Workbench - IRI","og_description":"Getting the correct metadata in a simple way is an important part of building structured data processing, protection, presentation, and prototyping","og_url":"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/","og_site_name":"IRI","article_published_time":"2021-08-09T16:15:47+00:00","article_modified_time":"2021-08-09T16:29:18+00:00","og_image":[{"width":1600,"height":867,"url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-collage.png","type":"image\/png"}],"author":"Devon Kozenieski","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Devon Kozenieski","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/#article","isPartOf":{"@id":"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/"},"author":{"name":"Devon Kozenieski","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/de972c035aaeecfc40a3ae2ea5ff7ba1"},"headline":"Discovering Spreadsheet Metadata in IRI Workbench","datePublished":"2021-08-09T16:15:47+00:00","dateModified":"2021-08-09T16:29:18+00:00","mainEntityOfPage":{"@id":"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/"},"wordCount":1035,"commentCount":0,"publisher":{"@id":"https:\/\/beta.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/#primaryimage"},"thumbnailUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-collage.png","keywords":["data class","data class library","data masking","Excel spreadsheet","IRI CoSort","IRI FieldShield","IRI NextForm","IRI RowGen","IRI SortCL","IRI Voracity","IRI Workbench","Microsoft Excel","xls","xlsx"],"articleSection":["Data Masking\/Protection","ETL","IRI Workbench","Metadata Management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/","url":"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/","name":"Discovering Spreadsheet Metadata in IRI Workbench - IRI","isPartOf":{"@id":"https:\/\/beta.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/#primaryimage"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/#primaryimage"},"thumbnailUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-collage.png","datePublished":"2021-08-09T16:15:47+00:00","dateModified":"2021-08-09T16:29:18+00:00","description":"Getting the correct metadata in a simple way is an important part of building structured data processing, protection, presentation, and prototyping","breadcrumb":{"@id":"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/#primaryimage","url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-collage.png","contentUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-collage.png","width":1600,"height":867},{"@type":"BreadcrumbList","@id":"https:\/\/beta.iri.com\/blog\/etl\/discovering-spreadsheet-metadata\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/beta.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Discovering Spreadsheet Metadata in IRI Workbench"}]},{"@type":"WebSite","@id":"https:\/\/beta.iri.com\/blog\/#website","url":"https:\/\/beta.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/beta.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/beta.iri.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/beta.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/beta.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/de972c035aaeecfc40a3ae2ea5ff7ba1","name":"Devon Kozenieski","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/19bf36cedac5d586ea168f58f96eb2f1?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/19bf36cedac5d586ea168f58f96eb2f1?s=96&d=blank&r=g","caption":"Devon Kozenieski"},"url":"https:\/\/beta.iri.com\/blog\/author\/devonk\/"}]}},"jetpack_featured_media_url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/08\/spreadsheet-metadata-collage.png","_links":{"self":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/14603"}],"collection":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/users\/119"}],"replies":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=14603"}],"version-history":[{"count":10,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/14603\/revisions"}],"predecessor-version":[{"id":14618,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/14603\/revisions\/14618"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/media\/14610"}],"wp:attachment":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=14603"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=14603"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=14603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}