Google Sheets

Free collaborative spreadsheet. 10 million cell limit. Real-time multi-user editing. The starting point for most data journalism.

Data & analysis

Adequate

https://docs.google.com/spreadsheets · Reviewed 2026-04-03 · Editorial assessment by Mike Schneider — not an independent security audit

What should journalists know about Google Sheets?

Half of data journalism starts in Google Sheets. Not because it is the most powerful tool — it is not — but because it is free, collaborative, and already open in every newsroom browser. 10 million cell limit. Real-time co-editing. 83 languages. Imports CSV, TSV, XLSX, ODS. Exports to PDF and Excel. Apps Script (JavaScript-based) lets you automate imports, transformations, and alerts. The Explore feature uses machine learning to answer natural language questions about your data and auto-generate charts. Since late 2025, Gemini AI is embedded in Sheets — it can generate formulas, build pivot tables, and suggest analysis patterns. Google Sheets is the gateway drug to data journalism. Reporters who would never open a command line will pivot, filter, and VLOOKUP their way through a public records dump. For datasets under a few hundred thousand rows, it handles the work. Once you hit millions of rows, complex joins, or statistical modeling, you graduate to Python, R, or a proper database. The security story is identical to Google Docs. Google is not zero-knowledge. Google encrypts data at rest (AES-256) and in transit (TLS), but Google employees and systems can access spreadsheet contents for service operation, abuse detection, and AI feature delivery. Gemini processes your data when AI features are active. In H1 2024, Google received over 82,000 government data requests globally, producing data in ~83% of U.S. subpoena cases. Spreadsheet contents require a warrant, but Google complies with valid warrants, court orders, and national security letters. Client-Side Encryption exists but requires Enterprise Plus ($25-35+/user/month) and a third-party key management service. That prices out every freelancer and most small newsrooms. For non-sensitive data work — public records, published datasets, election results, census data — Google Sheets is practical and well-built. For sensitive source-linked data, financial records under investigation, or anything that could become a legal target, do your analysis locally or in an encrypted environment.

Best for

Data cleaning and exploration for public records, FOIA responses, election data, census data. Collaborative dataset building across a reporting team. Quick pivot tables, charts, and analysis for deadline work. Teaching data journalism fundamentals — the learning curve is near zero.

Not for

Datasets over ~500K rows (performance degrades). Statistical modeling, regression analysis, or complex joins (use R or Python). Sensitive source-linked data, financial records under investigation, or any dataset that could become a legal target. Offline-only workflows — Sheets works offline via Chrome extension but with limited functionality. Anyone who needs zero-knowledge encryption on their data (use CryptPad or local tools).

Security & Privacy

Encryption in transit Yes

Data is scrambled while being sent to their servers

Encryption at rest Yes

Data is scrambled when stored on their servers

Data jurisdiction United States by default (Google Cloud). Workspace customers can select data region (US or EU) for primary data at rest. Enterprise Plus plans offer Client-Side Encryption where Google cannot decrypt content — requires a third-party key service (FlowCrypt, Virtru, Thales, or Futurex) and is only available on Enterprise Plus, Education Plus, Education Standard, and Frontline Plus plans.

Where servers are located — affects which governments can request your data

Security rating Adequate

Google encrypts data in transit (TLS) and at rest (AES-256) but is not zero-knowledge. Google accesses spreadsheet content for service operation, abuse scanning, and legal compliance. Gemini AI processes spreadsheet data when features are active — Google states Workspace customer data is not used for model training, but content is analyzed by AI systems for feature delivery. Google transparency report: 82,000+ government data requests in H1 2024 globally, producing data in ~83% of U.S. subpoena cases. Spreadsheet contents require a search warrant (not just a subpoena) to compel disclosure, but Google complies with valid warrants, court orders, and national security letters.

How to protect yourself:

Do not store sensitive source identities, confidential investigation data, or legally risky material in Google Sheets. Disable Gemini AI features in Workspace admin settings if you do not want data processed by Google's AI systems. Review sharing settings — 'anyone with the link' is a common misconfiguration that has exposed sensitive datasets. Enable Google Advanced Protection Program (free) for phishing-resistant login with passkeys or security keys. For sensitive data analysis, use LibreOffice Calc locally or CryptPad Sheets (zero-knowledge, E2E encrypted). If your newsroom uses Workspace Enterprise Plus, enable Client-Side Encryption with a third-party key service.

Strong infrastructure security: AES-256 at rest, TLS in transit, ISO 27001 and SOC 2/3 certified, FIPS 140-2 validated encryption modules. But Google is not zero-knowledge — they can access spreadsheet contents, and they comply with legal process (82,000+ government data requests in H1 2024 alone). Gemini AI processes spreadsheet data when features are active. Client-Side Encryption exists but is locked behind Enterprise Plus plans ($25-35+/user/month) and requires third-party key management. Adequate for public data, published datasets, and general newsroom data work. Not recommended for sensitive source-linked data, investigation financials, or legally risky datasets without Enterprise CSE.

Who Owns This

Owner Alphabet Inc. / Google LLC

Funding Publicly traded (NASDAQ: GOOGL). Market cap ~$2T.

Business model Free tier supported by Google ecosystem and data collection. Revenue from Google Workspace subscriptions ($7-35+/user/month) and enterprise services. Google's ad business benefits from ecosystem lock-in even when Sheets itself is free.

Known issues

Performance degrades noticeably past ~500K rows or heavy formula chains. 10 million cell hard limit — large datasets require splitting or migration to BigQuery. 'Anyone with the link' sharing misconfiguration has repeatedly exposed sensitive spreadsheets across newsrooms, government agencies, and NGOs. Gemini AI integration (rolled out across Workspace in 2024-2025) processes spreadsheet data for AI features; Google says Workspace data is not used for model training, but data is still analyzed by AI systems. No true zero-knowledge option outside Enterprise Plus plans. Import/export can lose formatting and formula compatibility with Excel for complex workbooks. Apps Script has execution time limits (6 minutes for consumer, 30 minutes for Workspace) that constrain automated data pipelines. Google Sheets launched in 2006 (originally Google Spreadsheets, rebranded 2012) — mature and stable, but feature development has slowed relative to competitors like Airtable and Notion databases.

Pricing

Free with Google account (15GB shared across Drive, Gmail, Photos). Google Workspace Business Starter: $7/user/month. Business Standard: $14/user/month. Business Plus: $18/user/month. Enterprise Plus: ~$25-35/user/month (required for Client-Side Encryption).

This is an editorial assessment based on publicly available information as of 2026-04-03, using our published methodology. Independent security review is pending. Security posture can change at any time. This is not a guarantee of safety.

Something wrong or outdated? Report it.