Skip to main content

GDPR Gap Assessment template

It's hard to believe I'm still talking to companies who are only now getting started on GDPR compliance. In fact, Cisco's 2019 Data Privacy Benchmark Study found that only 59% of the 3,206 organizations they surveyed felt they were largely compliant. Nine percent had not even started their compliance work:
Cisco 2019 Data Privacy Compliance Benchmark Study diagram
There are other companies who are thinking to entering the EU market and they are starting down the path of understanding what is required from a GDPR perspective.

If I were starting my GDPR compliance journey, the first thing I would do is a gap assessment. There are many outstanding gap assessment tools available, including:

One thing I dislike about these tools is they think of an organization as a single entity: What gaps does the ORGANIZATION have? That's great for providing status to the board or senior management, but not great if you are trying to work with individual departments on compliance.

To that end, I've updated a spreadsheet I used for performing a gap assessment in my organization
The spreadsheet has tabs for different parts of the organization like HR, Sales & Marketing, Product Development and others. Each tab has a set of GDPR compliance questions for different processes in the organization. For example, there's a set of questions around data collected for recruiting and for managing employees. 

Now I have a tab in a spreadsheet that I can use when I talk with Human Resources, and another tab when talking to Product Development.

The assessment tabs roll-up into a Executive Summary tab which gives an overview of the total compliance effort.

The spreadsheet can be easily adapted to other organizations. Feel free to edit, change, steal, share, or use this GDPR Gap Assessment spreadsheet for inspiration.


  1. Fabulous resource Mike, thank you so much for sharing.

    1. Thanks Audrey! Hope it makes your job easier!

  2. Thank you Mike. The template will be extremely helpful. Do you also have a template on the GAP Analysis report?

  3. This is a great template, thank you! Do you have anything similar for CCPA, CDPA, or PIPEDA?

  4. Hi Chelsea! I've been wanting to create similar templates but haven't had time. I'll let you know if I do!


  5. Many thax. awesome tool !


Post a Comment

Popular posts from this blog

Calculating the severity of a data breach

While at the 2019 IAPP Privacy. Security. Risk. conference, I was introduced to the European Union Agency for Network and Information Security (ENISA)'s " Recommendations for a methodology of the assessment of severity of personal data breaches " in Liisa M. Thomas's Data Breach Bootcamp. The methodology allows you to calculate the severity of a data breach from the perspective of a data subject: what's the personal harm? The methodology systematizes and standardizes the calculation “estimation of the magnitude of potential impact on the individuals derived from the data breach”. By answering a few questions about the breach, the methodology produces a severity score: Low : Individuals either will not be affected or may encounter a few inconveniences, which they will overcome without any problem (time spent re-entering information, annoyances, irritations, etc.). Medium : Individuals may encounter significant inconveniences, which they will be able to ove

Italian translation of Data Protection Impact Assessment

I am very happy to announce that Glauco Rampogna has translated my Data Protection Impact Assessment into Italian! He proactively volunteered to do this, following my philosophy of trying to make things easier for others. Both Glauco and I hope you find this translation helpful in your GDPR compliance efforts! Excel: Data Protection Impact Assessment template - Italian ODS:  Data Protection Impact Assessment template - Italian See How to Perform a Data Protection Impact Assessment for English versions of the template and for examples of data mappings. About Glauco: He's an ISO/IEC 27001 Lead Auditor and Data Protection Officer, and works in public sector as System Administrator. If you have questions, you may contact him at .