anonym.legal

By · Last updated 2026-04-10

Tagasi BlogisseÕiguslik Tehnoloogia

Tabelarvutuse anoonumiseerimine GDPR ja CCPA jaoks

Exceli valemid viitavad kliendinimesid sisaldavatele lahtritele. Piiortabelid salvestavad tundlikke andmeid. Interneti-uhenduseta keskkond on noetav 67% valitsusasutustest.

April 10, 20268 min lugemist
Excel anonymizationspreadsheet GDPRpivot table redactioncell-level PII detectionformula preservation

Tabelarvutused ei ole dokumendid

Wordi fail on tekstivoog. Exceli fail on midagi muud. Lahtrid viitavad teistele lahtritele. Valemid toeoetavad vahemike peal. Piiortabelid grupivad nimedega andmed. Makrod liiguvad kogu toeoevihiku kaudu. Enamik redakteerimistooriistasid kaesitleb Excelit tekstidokumendina. See on vale mudel.

Siin on lihtne naeiete. Veerus A on klientide nimed. Veerus D on see valem: =VLOOKUP(A2, CustomerTable, 5, FALSE). See valem otsib kontonumbri nime jargi. Te asendate nime veerus A. Te ei uuenda valemit ega otsitabelit. Valem tagastab endiselt algse nime tegeliku saldo. Fail naeb puhas valja. See ei ole seda.

See on tavaline ettevoetuslikes Exceli failides. Andmed elavad seostes - mitte ainult lahtrites. Lahtrivaertuste asendamine ilma neid seoseid jaeligimaeta jaeettab isikuandmeid paljastunuks.

GDPR artikkel 28 ja vaelisjaagamine

GDPR artikkel 28 katab andmete jagamise toetlejatega. Kui saadate isikuandmeid konsultandile, tarnijale voei audiitorile, vajate tehnilisi kaitsemeetmeid.

Oeelge, et peate jagama 50 000-realise kliendiandmete faili analuesitarnijaga. PDF-i eksport eemalda valemid. Samuti rikkub see suurimad failid keeruka vormindusega. CSV eemalda valemid ja piiortabelid. Kumbki ei anna tarnijale kasutatavat andmestikku.

Ainus voimalus, mis toimib: anoenumiseerida natiivselt Exceli vormingus. Asendage tuvastuvad vaertused. Hoidke struktuuri alles. Tarnija saab toeotava faili. Te taeidate GDPR-i kaitsemeetme noetuse.

Interneti-uhenduseta keskkond

67% valitsuse ja kaitsetoeetluse RFP-dest viitavad interneti-uhenduseta keskkonna noetustele (DISA 2024). Kaitsetoeevoetjad kaesitlevad personali andmeid, logistikadokumente ja hankefalide Excelis. Nad ei saa kasutada pilvepohiseid toriistu. Andmed ei tohi kontrollitud voorgust lahkuda.

Desktopi rakendus lahendab selle. See toetleb Exceli faile kohalikul masinal. Toetluse ajal ei toimu voorkutset. Vaeljastatav fail ei lahku kunagi interneti-uhenduseta keskkonnast. Sisemised meeskonnad saavad jagada puhtaid faile kontrollitud voorgus.

See vaestab valitsuse lepingute vastavuse jaoks noetavat tehnilist profiili.

Kolm lahtritaseme intelligentsuse taset

Hea Exceli anoenumiseerimine toeoetab kolmel tasandil korraga.

Vaertuse tase: Leidke ja asendage isikuandmed uksikutes lahtrites. Nimed, e-postiaadressid, telefoninumbrid ja rahvuslikud isikutunnistused markeeeritakse kasutades sama tuvastamismootori nagu dokumentide toetlemisel.

Valemi tase: Leidke lahtrid, mille valemid viitavad isikuandmete lahtritele. Uuendage need viited nii, et nad osutaksid anoenumiseeritud vaertustele. Voei asendage valem tulemustega, et peatada valemipohine isikuandmete paljastumine.

Struktuuri tase: Tuhjeendage piiortabeli andmete vahemalud. Toetlege peidetud ridu ja veerge. Kaesitlege VBA makrokoodi, mis kasutab konkreetseid lahtri aadresse voei vaertusi.

Koik kolm taset peavad toeoetama koos. Vaertuste parandamine ilma valemeid parandamata jaeettab isikuandmeid paika. Valemite parandamine ilma vahemalud tuhjeendamata teeb sama.

See vaeljakutse hoemab iga failivormingut. Vaadake kuidas vormingute killustatus moetjutab isikuandmete tuvastamist laiema vaate jaoks.

Meeskondade jaoks, kes toeoetavad struktureeritud andmeid API tasemel, vaadake GDPR-i andmete minimeerimist reaalajas API-des.

Kui teie meeskond kaasab suuri DSAR-i ekspordifaile, vaadake GDPR DSAR-i pakktootlust skaalal vooogude mustritega, mis siin kehtivad.

Allikad

Seotud Artiklid

Õiguslik Tehnoloogia

Mixed Format E-Discovery: Compliance Gap

E-discovery productions and GDPR DSARs span PDFs, Word docs, Excel, and JSON exports. Using different tools for each format creates consistency gaps that.

Õiguslik Tehnoloogia

The PDF Redaction Trap: Data Exposed

The DOJ Epstein files, the Manafort case, and NSA leaks all share the same failure: cosmetic redaction that leaves underlying text extractable.

Õiguslik Tehnoloogia

Legal PII: Privilege Detection

Case reference numbers, bar admission numbers, court docket numbers, and client matter IDs are legally sensitive identifiers that standard PII tools miss.

Kas olete valmis oma andmeid kaitsma?

Alustage PII anonüümitamist 285+ üksustüübi abil 48 keeles.

Alusta Tasuta KatsetVaata Funktsioone

About this page

We update this page when our platform or the law changes.

Read our founder note for how we work.

Each change shows up in the timestamp at the top.

Related reading

We follow these rules

  • GDPR (EU 2016/679).
  • ISO/IEC 27001:2022.
  • NIS2 (EU 2022/2555).
  • HIPAA safe harbor under 45 CFR § 164.514(b)(2).

Our promise

We do not sell your data.

We do not train models on your text.

We store your files in Germany.

You can delete your account at any time.

You own your work.

Where we run

Our servers live in Falkenstein, Germany.

We use Hetzner. They hold ISO 27001 certification.

All data stays in the EU.

Backups run every day.

Need help?

Email support@anonym.legal.

We reply within one business day.

How we test

We run a full check suite on every release.

Each surface gets its own sweep script and report.

Human reviewers spot-check the output each week.

We track recall and precision on a labelled set.

Bad runs block the deploy.

What we never do

  • We never sell your information to third parties.
  • We never train models on what you upload.
  • We never keep your work after you delete it.
  • We never share keys with any outside firm.
  • We never run ads inside the product.

Plans in plain words

We sell credits, not seats.

One credit covers one short job.

Long jobs use a few credits each.

You can top up at any time.

Unused credits roll over each month.

Read the plans page for current rates.

Who built this

A small team of engineers and lawyers built this.

We ship from Europe and work in the open.

Our founder note spells out why we started.

Where to start

How the parts fit

A browser add-on cleans text inside Chrome.

A Word plug-in handles drafts in Office.

A small desktop tool works on whole folders.

An agent protocol link feeds large models safely.

All four share one core engine and one rule set.

Words from our team

We started this work after a lunch about cookies.

One friend kept getting odd ads on her phone.

We asked why a court file leaked through a draft.

We sketched the first build on a napkin that week.

By month three we had a tiny demo for a friend.

She used it on her first case the next day.

Common questions we hear

Can the tool read scanned PDFs? Yes, with OCR.

Does it work on long files? Yes, in small chunks.

Can I roll my own rule set? Yes, save it as a preset.

Does it run offline? The desktop build runs offline.

Do you keep my files? No, the cloud build wipes after each run.

Will it learn from my work? No, we never train on inputs.

A short tour of the workflow

Upload a file or paste a snippet of prose.

Pick the entities you want gone from the draft.

Choose a method: replace, mask, hash, encrypt, or redact.

Press run and watch the side panel show each hit.

Skim the result and tweak any rule that misfired.

Save the cleaned file or send it to a teammate.