Settings

Open in SheetsFree, with no account. What you type stays in this browser. Saves as Excel, OpenDocument or CSV.

Subject access request log open in Sheets, in the light themeSubject access request log open in Sheets, in the dark theme

What is in it

Each request with the day it arrived, the one-month deadline and the extended one, the day it was answered, and whether it is open, closed or overdue. The figures are examples to type over; the workbook runs wider than the columns shown here.

Subject access request log
The deadline is one calendar month from the day the request arrives, or from the day you receive the identification you asked for. It can be extended by two further months for a complex request, if you tell the person why within the first month.
RefRequested byReceivedDueExtended?Due if extendedAnsweredDays
SAR-001[Name]2026-09-01=IF(C5="","",EDATE(C5,1))No=IF(C5="","",EDATE(C5,3))=IF(G5="","",DAYS(G5,C5))

Worked out for you

These cells are formulas, so they follow whatever you type. Each is shown as written in its first row.

Due
=IF(C5="","",EDATE(C5,1))
Due if extended
=IF(C5="","",EDATE(C5,3))
Days
=IF(G5="","",DAYS(G5,C5))
Status
=IF(C5="","",IF(G5<>"","Answered",IF(TODAY()>IF(E5="Yes",F5,D5),"Overdue","Open")))

Filling it in

  • The deadline under the UK and EU GDPR is one calendar month from receiving the request, or from receiving any identification you asked for.
  • It can be extended by two further months if the request is complex or one of many from the same person, but you must tell them why within the first month.
  • Log the request on the day it arrives, whatever form it takes. A request does not have to mention the law, or be in writing, to count.

The next step

More templates

All 32 templates