{"id":14619,"date":"2021-08-09T16:28:55","date_gmt":"2021-08-09T20:28:55","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=14619"},"modified":"2024-08-09T13:55:19","modified_gmt":"2024-08-09T17:55:19","slug":"iri-data-masking-tools-for-excel","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/","title":{"rendered":"Which IRI Data Masking Tool is Best for Excel?"},"content":{"rendered":"

Abstract: Now that XLS and XLSX files are now also directly supported in IRI FieldShield by virtue of their new <\/i>\/PROCESS (format) support<\/i><\/a> in the CoSort 10.5 SortCL program, IRI Voracity data management platform and standalone data masking users have three different ways to \u201cshield\u201d sensitive data in their spreadsheets. This article was written to help you choose among them.<\/i>
\n<\/i><\/p>\n

Do you know the difference between<\/a> IRI FieldShield, DarkShield, and CellShield EE? All three of these IRI Data Protector Suite<\/a> products share common search methods (like pattern or dictionary matches) and individually or globally applicable data masking functions (like encryption, redaction, hashing, and pseudonymization).<\/p>\n

All three can thus produce identical, and potentially interchangeably reversible, ciphertext to preserve determinism and data integrity. They are also all supported components of the IRI Voracity<\/a> data management platform.<\/p>\n

Each can also find and mask Personally Identifiable \/ Protected Health Information (PII\/PHI), and other sensitive data in MS Excel sheets. But the tools differ in Excel operation and job configuration by design, so it\u2019s important to know which one(s) to use in which situation(s).<\/p>\n

\"\"<\/a><\/p>\n

FieldShield for Excel<\/b><\/h6>\n

IRI FieldShield<\/a> is designed to classify, search, and mask structured database and flat-file data. FieldShield uses the CoSort SortCL<\/a> data definition and manipulation program to define source and target layouts, and all mapping \/ masking transformations. SortCL uses 4GL job scripts<\/a> usually created and managed in the IRI Workbench<\/a> IDE, built on Eclipse.<\/p>\n

Searches for PII in Excel can be performed more or less globally through the Directory Data Class Search<\/a> wizard in IRI Workbench. These modules allow you to recursively search all XLS and XLSX files in and below your specified Windows drive\/folder.<\/p>\n

\"\"<\/a><\/p>\n

Only the top sheet in each file is scanned by default, but specific sheets and ranges can be added individually as additional file sources in the data class library editor. This dialog is also where the global masking functions\/rules can be defined, verified, or modified.<\/p>\n

\"\"<\/a><\/p>\n

At masking time, either globally-associated functions are applied as rules to many sheets at once in batch jobs built by the Data Class File Masking<\/a> wizard, or individual functions can be specified in one or more job scripts ad hoc (one per sheet). The real benefit of using FieldShield for masking data from\/to Excel sheets however is the inherent mapping ability SortCL imbues.<\/p>\n

By way of example, this FieldShield data masking script takes PII from a text tab separated file, writes an encrypted\/pseudonymized version to one .xlsx file, and an unmodified version to another .xlsx file. The encrypted passwords obscure encryption keys<\/a> in the job script.<\/p>\n

\/INFILE=transactions.txt\r\n\u00a0 \/FIELD=(credit_card,POSITION=1,SEPARATOR='\\t')\r\n\u00a0 \/FIELD=(driv_lic,POSITION=2,SEPARATOR='\\t')\r\n\u00a0 \/FIELD=(name,POSITION=3,SEPARATOR='\\t')\r\n\r\n\/REPORT # Voracity can also sort and\/or join, plus aggregate, convert, etc. below<\/i>\r\n\r\n\/OUTFILE=\u201d'Sheet1'!MMM1:MMO10;transactions_PII_encrypted.xlsx\u201d\r\n\u00a0 \/PROCESS=XLSX\r\n\u00a0 \/FIELD=(credit_card1=enc_fp_aes256_alphanum(credit_card,\"epass:Gg87jCTR15Jro4AGE44ENw==\"),POSITION=1,SEPARATOR='\\t',SDEF=\"=MMM\")\r\n\u00a0 \/FIELD=(driv_lic1=enc_fp_aes256_alphanum(driv_lic,\"epass:Gg87jCTR15Jro4AGE44ENw==\"),POSITION=2,SEPARATOR='\\t',SDEF=\"=MMN\")\r\n\u00a0 \/FIELD=(name,POSITION=3,SEPARATOR='\\t',SDEF=\"=MMO\",SET=C:\\IRI\\cosort100\\sets\\names\\names_first_last.set)\r\n\r\n\/OUTFILE=\u201d'Sheet1'!M1:O10;transactions_PII_unencrypted.xlsx\u201d\r\n\u00a0 \/PROCESS=XLSX\r\n\u00a0 \/FIELD=(credit_card,POSITION=1,SEPARATOR='\\t',SDEF=\"=M\")\r\n\u00a0 \/FIELD=(driv_lic,POSITION=2,SEPARATOR='\\t',SDEF=\"=N\")\r\n\u00a0 \/FIELD=(name,POSITION=3,SEPARATOR='\\t',SDEF=\"=O\")<\/pre>\n
IRI Workbench also automates the generation of the\u00a0 \/FIELD layouts as well as reusable Data Definition Format (DDF) files that specify the metadata of any source (and\/or target) sheet. SortCL requires statements in DDF metadata syntax to parse, mask, and map the input\/output values column-by-column.<\/p>\n
\"\"<\/a><\/p>\n
FieldShield jobs can be executed on the command line, in batch jobs, or scheduled from IRI Workbench or any automation tool. Because the SortCL syntax is capable of much more than masking, it\u2019s also a best choice for Voracity users looking to use sheet data in ETL processes, generate and populate (RowGen) test data into sheets, cleanse and report on data in Excel, etc.<\/p>\n
DarkShield for Excel<\/b><\/h6>\n
IRI DarkShield<\/a> is designed primarily for finding and masking data in semi-structured and unstructured text and EDI files, RDB C\/BLOB columns, NoSQL DB collections, images, and documents in PDF and MS Office formats — including XLS and XLSX-compatible files which may even have PII in charts and images in the sheets.<\/p>\n
\"\"<\/a><\/p>\n
DarkShield jobs can be specified in the Dark Data Search\/Masking Job wizard<\/a> in IRI Workbench\u2026 or through its RPC API for files<\/a>, which also supports Excel. The DarkShield API is indicated instead of Workbench when the number of PII annotations will exceed the capacity of Eclipse memory, or when XLS\/X searching\/masking jobs need to be called from a web service or program.<\/p>\n
The main reason to use DarkShield is for pure masking, but not mapping, of data in Excel, or when spreadsheets are among several different mixed sources to protect. Unlike FieldShield, DarkShield does not support simultaneous data transformations, but either DarkShield paradigm can find and mas<\/em>k sensitive data in Excel (and other formats) simultaneously<\/em>.<\/p>\n
In fact, among all three IRI masking products, DarkShield has the most search criteria for finding data in cells. Beyond column names and pattern and dictionary matches, the DarkShield API supports fuzzy matches to lookup values, Named Entity Recognition, and area bounding boxes. It is also the only tool that can find and mask PII embedded in spreadsheet charts and images.<\/p>\n
\"\"<\/a><\/p>\n
DarkShield is also a good choice for integrating spreadsheet masking into document management or DevOps (CI\/CD) pipelines because of the familiarity and flexibility of its OpenAPI. And through \u201cglue code\u201d written in any language, it also is possible to customize the operational connections and destinations for the masked sheets or data extracts you may need.<\/p>\n
It provides search results and job logs in a variety of internal formats and external tools as well.<\/p>\n
\"\"<\/a><\/p>\n
CellShield for Excel<\/b><\/h6>\n
IRI CellShield<\/a> was purpose-built for finding and masking data only in spreadsheets, and is the only IRI \u201cshield\u201d product that can work entirely in the Excel environment alone. CellShield is\u00a0 available in a low-cost Personal Edition (PE<\/a>) or professional multi-sheet Enterprise Edition (EE<\/a>).<\/p>\n
CellShield PE <\/i>is useful for manually searching and masking PII one sheet at a time. It features a point-and-click interface to the same encryption, redaction, and hashing functions supported in the other IRI shield products, except pseudonymization which is random and not deterministic.<\/p>\n
\"\"<\/a><\/p>\n
CellShield EE <\/i>was designed to consolidate searching and apply consistent masking operations to PII in multiple XLS and XLSX sheets. In addition to PE features, EE supports network-wide and data class-based searches from IRI Workbench (or pattern searches from the Excel UI), intra-cell searching and masking to handle values in text fields, and full-sheet masking.<\/p>\n
\"\"<\/a><\/p>\n
CellShield EE can also display search results in charts or by exporting its results.<\/p>\n
\"\"<\/a><\/p>\n
The same is true for its job audit trails. Logs can be sent to any location in the file system, through email, or directly into Datadog or Splunk indexes for further analytics and visualizations.<\/p>\n
Quick Decision Matrix<\/b><\/h6>\n
If you have sensitive data in Excel sheets and the above product details are insufficiently clear, consult this feature matrix comparing what is and is not supported in the IRI masking tools:<\/p>\n
\"\"<\/a><\/p>\n
If you still have questions about which Excel data masking tool would work best for your use case, or would like to see one or more demonstrated, please contact your IRI representative<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"
Abstract: Now that XLS and XLSX files are now also directly supported in IRI FieldShield by virtue of their new \/PROCESS (format) support in the CoSort 10.5 SortCL program, IRI Voracity data management platform and standalone data masking users have three different ways to \u201cshield\u201d sensitive data in their spreadsheets. This article was written to<\/p>\n
Read More<\/a><\/div>\n","protected":false},"author":3,"featured_media":14643,"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":[32,8],"tags":[1496,14,596,982,1388,520,1204,598,149,620,621],"class_list":["post-14619","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-intelligence","category-data-protection","tag-darkshield-rpc-api","tag-data-masking","tag-iri-cellshield","tag-iri-cellshield-enterprise-edition","tag-iri-darkshield","tag-iri-fieldshield","tag-iri-sortcl","tag-microsoft-excel","tag-pii","tag-xls","tag-xlsx"],"acf":[],"yoast_head":"\nWhich IRI Data Masking Tool is Best for Excel? - IRI<\/title>\n<meta name=\"description\" content=\"Do you need to mask PII, PHI or other sensitive data in Excel? Learn which Excel masking tool to use in this data masking tools comparison.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Which IRI Data Masking Tool is Best for Excel?\" \/>\n<meta property=\"og:description\" content=\"Do you need to mask PII, PHI or other sensitive data in Excel? Learn which Excel masking tool to use in this data masking tools comparison.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-09T20:28:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-09T17:55:19+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/08\/excel-iri-software-function-chart-thumbnail.png\" \/>\n\t<meta property=\"og:image:width\" content=\"449\" \/>\n\t<meta property=\"og:image:height\" content=\"207\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"David Friedland\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"David Friedland\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/\"},\"author\":{\"name\":\"David Friedland\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/cdb89f0c0a9c88810b8516d4b140734a\"},\"headline\":\"Which IRI Data Masking Tool is Best for Excel?\",\"datePublished\":\"2021-08-09T20:28:55+00:00\",\"dateModified\":\"2024-08-09T17:55:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/\"},\"wordCount\":1120,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/08\/excel-iri-software-function-chart-thumbnail.png\",\"keywords\":[\"DarkShield RPC API\",\"data masking\",\"IRI CellShield\",\"IRI CellShield Enterprise Edition\",\"IRI DarkShield\",\"IRI FieldShield\",\"IRI SortCL\",\"Microsoft Excel\",\"PII\",\"xls\",\"xlsx\"],\"articleSection\":[\"Business Intelligence (BI)\",\"Data Masking\/Protection\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/\",\"url\":\"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/\",\"name\":\"Which IRI Data Masking Tool is Best for Excel? - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/08\/excel-iri-software-function-chart-thumbnail.png\",\"datePublished\":\"2021-08-09T20:28:55+00:00\",\"dateModified\":\"2024-08-09T17:55:19+00:00\",\"description\":\"Do you need to mask PII, PHI or other sensitive data in Excel? Learn which Excel masking tool to use in this data masking tools comparison.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/08\/excel-iri-software-function-chart-thumbnail.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/08\/excel-iri-software-function-chart-thumbnail.png\",\"width\":449,\"height\":207},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Which IRI Data Masking Tool is Best for Excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.iri.com\/blog\/#website\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/www.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:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/cdb89f0c0a9c88810b8516d4b140734a\",\"name\":\"David Friedland\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/995ea08bc7d036da625671cb48a636eb?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/995ea08bc7d036da625671cb48a636eb?s=96&d=blank&r=g\",\"caption\":\"David Friedland\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/davidf\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Which IRI Data Masking Tool is Best for Excel? - IRI","description":"Do you need to mask PII, PHI or other sensitive data in Excel? Learn which Excel masking tool to use in this data masking tools comparison.","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:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/","og_locale":"en_US","og_type":"article","og_title":"Which IRI Data Masking Tool is Best for Excel?","og_description":"Do you need to mask PII, PHI or other sensitive data in Excel? Learn which Excel masking tool to use in this data masking tools comparison.","og_url":"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/","og_site_name":"IRI","article_published_time":"2021-08-09T20:28:55+00:00","article_modified_time":"2024-08-09T17:55:19+00:00","og_image":[{"width":449,"height":207,"url":"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/08\/excel-iri-software-function-chart-thumbnail.png","type":"image\/png"}],"author":"David Friedland","twitter_card":"summary_large_image","twitter_misc":{"Written by":"David Friedland","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/"},"author":{"name":"David Friedland","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/cdb89f0c0a9c88810b8516d4b140734a"},"headline":"Which IRI Data Masking Tool is Best for Excel?","datePublished":"2021-08-09T20:28:55+00:00","dateModified":"2024-08-09T17:55:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/"},"wordCount":1120,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/08\/excel-iri-software-function-chart-thumbnail.png","keywords":["DarkShield RPC API","data masking","IRI CellShield","IRI CellShield Enterprise Edition","IRI DarkShield","IRI FieldShield","IRI SortCL","Microsoft Excel","PII","xls","xlsx"],"articleSection":["Business Intelligence (BI)","Data Masking\/Protection"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/","url":"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/","name":"Which IRI Data Masking Tool is Best for Excel? - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/08\/excel-iri-software-function-chart-thumbnail.png","datePublished":"2021-08-09T20:28:55+00:00","dateModified":"2024-08-09T17:55:19+00:00","description":"Do you need to mask PII, PHI or other sensitive data in Excel? Learn which Excel masking tool to use in this data masking tools comparison.","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/08\/excel-iri-software-function-chart-thumbnail.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/08\/excel-iri-software-function-chart-thumbnail.png","width":449,"height":207},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-masking-tools-for-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Which IRI Data Masking Tool is Best for Excel?"}]},{"@type":"WebSite","@id":"https:\/\/www.iri.com\/blog\/#website","url":"https:\/\/www.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.iri.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/www.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/www.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:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/cdb89f0c0a9c88810b8516d4b140734a","name":"David Friedland","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/995ea08bc7d036da625671cb48a636eb?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/995ea08bc7d036da625671cb48a636eb?s=96&d=blank&r=g","caption":"David Friedland"},"url":"https:\/\/www.iri.com\/blog\/author\/davidf\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/08\/excel-iri-software-function-chart-thumbnail.png","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/14619"}],"collection":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=14619"}],"version-history":[{"count":8,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/14619\/revisions"}],"predecessor-version":[{"id":17881,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/14619\/revisions\/17881"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/14643"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=14619"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=14619"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=14619"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}