Turn Data in Google Sheets Into a Reader-Ready Public Table

To share data in Google Sheets with a public audience, build a reviewed table first—not just a link to your working spreadsheet. Keep the source data separate, make each row understandable, and check the exported file before publishing it.

This workflow takes a CSV or Excel file through Sheets to a public table readers can explore without editing your analysis.

1. Import the data without replacing your working file

On a computer:

1. Open Google Sheets and create a spreadsheet.
2. Choose File → Import and select your file.
3. Choose Create new spreadsheet, or Insert new sheets if you want the imported data inside an existing workbook.
4. For a CSV or other plain-text file, check the separator setting. Use Comma, Tab, or a custom separator when automatic detection does not match the file.
5. Complete the import.

Google Sheets supports CSV, TSV, XLSX and other formats, but the available import options depend on the file type. Avoid the replacement options unless overwriting existing content is intentional. Google’s import documentation lists the supported formats and options.

Before editing, compare the imported headers, row count and several records with the original. Pay particular attention to identifiers with leading zeros, dates and decimal values. A successful import is not proof that every value retained its intended meaning.

2. Give every row a clear meaning

Define what one row represents before cleaning or summarizing anything. For example: one library branch’s visits during one month.

Here is an illustrative structure, not real library data:

branch_id	branch_name	month	visits
LIB-001	Central	2026-09	1240
LIB-002	Riverside	2026-09	860
LIB-001	Central	2026-10	1315

Use one header row, one field per column and one record per row. In this example:

• branch_id identifies the branch; it is not a measurement.
• month uses a consistent YYYY-MM label.
• visits contains counts, not text such as “1,240 visits.”
• The combination of branch_id and month should identify one record.

Keep titles, explanatory paragraphs and totals outside the data rectangle. Record the source, coverage period, unit definitions, missing-value convention and any reuse restrictions in accompanying notes.

For a fuller review of inconsistent labels, duplicates and missing values, use the clean data sheets checklist.

3. Inspect with sorting and filtering

To sort, select the entire table, not just the column whose order you want to change. Then choose Data → Sort range → Advanced range sorting options, enable Data has header row, select the sort column and order, and click Sort. This follows Google’s range-sorting workflow while keeping each record’s fields together.

For inspection, select the table and choose Data → Create a filter. Review unexpected categories, blank values and unusually large or small counts. A filter view lets collaborators inspect different subsets without changing everyone’s view. Google explains filters and filter views.

Filtering is not redaction. Filters hide data; they do not remove it. Build a separate publication file containing only approved rows and columns. Do not rely on hidden tabs, hidden columns or filters to protect personal or confidential information. Google specifically warns that viewers can access hidden sheets by copying the spreadsheet.

4. Export a reviewed publication copy

Put the approved table in a separate spreadsheet containing only the table you intend to publish. Choose File → Download and select CSV for a flat table. Google documents the download workflow and confirms that Sheets can export CSV and Excel formats.

Check the downloaded file before uploading it:

• Does it contain only the intended headers and records?
• Do identifiers and dates still match the reviewed sheet?
• Are missing values distinguishable from genuine zeros?
• Do the record count and a key total match your publication copy?
• Are all private fields absent—not merely hidden?

For more export checks, see the CSV export guide.

5. Choose the public presentation

Use Google’s Publish to web option when you want a published version of the sheet. Choose File → Share → Publish to web, select the intended sheet and format, and click Publish. Source changes can automatically update the published version after a few minutes. For a fixed release, open Published content & settings and uncheck Automatically republish when changes are made. Account settings can restrict the audience or disable publishing. Google’s publishing guidance covers these controls and warns against publishing sensitive information.

Use TablePage when you want the reviewed file to become a separate interactive dataset page. TablePage accepts CSV, TSV, XLSX and XLS uploads and generates a public shareable page with a filterable table and charts, accessible without signup. Upload only data cleared for public release.

Treat that uploaded file as a dated snapshot; do not assume subsequent edits in Sheets will appear on the public page. Before distributing the link, check the displayed headers, representative records and any charts against the reviewed export. Include the data source, coverage period and snapshot date alongside the link so readers know exactly what they are exploring.