Free AI-Assisted

Gene-Safe CSV & TSV Table Editor

Clean and reshape genomics tables without Excel corrupting gene symbols—HGNC normalization, melt/pivot, safe XLSX export, and scripts. Built-in AI agent assistant support.

Open tool workspace

Need help with bioinfo analysis? See our bioinformatics services.

Key facts

Key facts about Gene-Safe CSV & TSV Table Editor
FactValue
InputCSV/TSV up to 50 MB; UTF-8; auto-detected comma, tab, or semicolon delimiter
Identifier protectionAuto-detects gene symbols and Ensembl IDs; locks type to text to prevent date conversion
HGNC normalizationEmbedded alias lookup table; one-click normalization of outdated symbols (e.g. MARCH1 → MARCHF1)
Operation sub-tabsFilter (multi-condition AND), Join (inner/left/outer), Reshape (melt wide→long, pivot long→wide), Profile
Export formatsClean CSV, TSV, safe Excel (.xlsx with string cell types), clipboard tab-separated text
Profile chartsVisual column distribution panel with exportable SVG and 300 dpi PNG charts
Script generationTranslates session transformation AST into Python (pandas), R (tidyverse), and CLI (csvtk) scripts
Execution & privacy100% client-side in browser; zero file upload to servers; no account required

What it does

When wet-lab researchers open CSV or TSV files in desktop spreadsheets, Excel silently converts gene names like SEPT2 or MARCH1 into calendar dates ("2-Sep", "1-Mar"). This irreversible auto-conversion has corrupted over 30% of published supplementary gene lists. Safe Table Bio eliminates identifier corruption by providing a browser-based table workspace that locks gene symbols and Ensembl IDs as text while giving non-coding scientists no-code tools to filter, join, reshape, and profile tables up to 50 MB.

Upload or drag-and-drop any CSV or TSV file, or click Load Example to explore a 20-row genomics dataset. The editor scans headers and values using pattern recognition, assigning protective type badges (🔒 Identifier, 📊 Numeric, 🔤 Text) so numeric coercion never occurs. When outdated gene symbols or synonyms appear in protected columns, an inline banner flags them with a one-click option to update to current HGNC approved nomenclature.

Within the single-page interface, four operation sub-tabs handle routine table cleaning: Filter applies multi-condition AND rules across numeric and text columns; Join combines two tables on shared keys with inner, left, or outer logic; Reshape melts wide count matrices into long format or pivots long tables with sum, mean, or first aggregations; and Profile visualizes missing values, distinct counts, numeric summary stats, and HGNC validity percentages with downloadable SVG and PNG charts. Every operation shows live row and column count deltas before you commit. Download results as plain CSV, TSV, or safe Excel (.xlsx) files with explicit string typing, or open History & Code to copy cumulative Python (pandas), R (tidyverse), or csvtk scripts.

Why researchers use it

  • Prevent Excel from converting gene symbols like SEPT2 and MARCH1 into dates
  • Normalize outdated HGNC gene aliases to current approved symbols automatically
  • Reshape wide expression matrices into long format without writing Python code
  • Join annotation files on shared gene columns with visible unmatched row previews
  • Export safe Excel workbooks with explicit text typing on identifier columns
  • Generate reproducible Python, R, and csvtk scripts from every visual edit

Best for

  • Cleaning supplementary gene tables before manuscript submission or repository upload
  • Melting wide RNA-seq or qPCR count matrices for ggplot2 or DESeq2 pipelines
  • Merging differential expression output with annotation files using HGNC symbols
  • Profiling missing data and column distributions before statistical modeling
  • Converting raw CSV files into safe Excel spreadsheets for non-coding collaborators

When to use this vs alternatives

Choose Safe Table Bio when you need a fast, zero-install browser workspace to clean single or paired tables under 50 MB with automatic HGNC symbol protection and script generation. Use Bio Table Matchmaker when merging two datasets requires detailed pre-join key diagnostics, Ensembl version stripping, or chromosome prefix harmonization. For comparing overlap between multiple gene lists using Venn or UpSet diagrams, use Smart List Overlap.

What makes it different

Generic spreadsheet applications lack gene-symbol protections, CLI tools require scripting fluency, and OpenRefine lacks genomics-specific symbol reconciliation. Safe Table Bio bridges GUI simplicity and bioinformatics safety by combining locked identifier types, HGNC alias mapping, live diff previews, and multi-language script export in one client-side tool.

Researchers switch from desktop spreadsheets and command-line scripts because Safe Table Bio removes the risk of silent gene-symbol corruption without forcing scientists to learn R or Python syntax. By providing instant HGNC normalization, live operation previews, and one-click script generation, it ensures wet-lab edits remain completely reproducible and pipeline-ready.

How to get started

  1. Open the workspace on the Table Editor tab and drag-and-drop a CSV or TSV file, or click Load Example.
  2. Inspect the data grid and column badges (🔒 Identifier, 📊 Numeric, 🔤 Text); adjust any manual column types or names using header dropdown menus.
  3. If outdated gene symbols are detected, click Normalize symbols on the HGNC banner to update them to current approved names.
  4. Select an operation sub-tab (Filter, Join, Reshape, or Profile), configure your parameters, and review the live diff preview.
  5. Click Apply filter, Apply join, or Apply reshape to commit the transformation to your session history.
  6. Click CSV, TSV, or XLSX (Safe) to download your cleaned data, or click Export Script to copy equivalent Python, R, or csvtk code.

Frequently asked questions

How does safe Excel export prevent gene symbol corruption?
Desktop Excel parses cell strings with aggressive date heuristics, converting symbols like MARCH1 or SEPT2 to dates upon opening. Safe Table Bio builds native .xlsx files where identifier columns are explicitly assigned string data types (t: "s"). When collaborators open the file in Excel, cell values remain plain text without date conversion.
Which gene symbols and alias databases are supported?
The tool ships with an embedded lookup table derived from official HGNC (HUGO Gene Nomenclature Committee) records. It scans identifier columns for historical symbols and aliases (such as MARCH1 or SEPT2) and offers one-click normalization to current approved symbols (MARCHF1, SEPTIN2). Only exact database matches are updated to prevent false-positive merges.
How does table reshaping (melt and pivot) work without coding?
The Reshape sub-tab provides no-code controls for wide-to-long and long-to-wide transformations. Melt keeps specified ID columns fixed while unpivoting remaining columns into variable and value rows. Pivot converts long observations into wide matrices by selecting index, pivot, and value columns with sum, mean, or first aggregations.
What happens if my table file exceeds 50 MB?
Browser memory limits safe client-side processing to files up to 50 MB. If you upload a larger file, the tool displays an inline warning recommending command-line tools. You can use the built-in script generator to construct an equivalent pandas, R, or csvtk script on a sample file, then execute it locally on multi-gigabyte datasets.
Can I use ChatGPT, Cursor, or another AI agent with Safe Table Bio?
Yes. The workspace features an in-browser assistant that reads your table schema and latest run output to help configure filters, reshapes, and joins. External AI agents can also execute table operations programmatically over API & MCP (/tools/developers) using the pepkio_safe-table-bio tool definition.

Client source code & registry

Open tool workspaceBack to tools

Last updated . Pepkio builds free lab calculators alongside bioinformatics CRO services.