Table utilities / Table merge / join
Your data stays in your browser: files are read and processed on your device, never uploaded to any server, and cleared when you close the page. Free, no sign-in.
Joins two or three tables side by side on a key column (e.g. gene or sample name). A left join keeps every row of table A and fills keys missing elsewhere with the fill value; an inner join keeps keys present in all tables; a full outer join keeps every key.
By default keys ignore case and surrounding spaces; tick “Strip version suffixes” for Ensembl IDs such as ENSG….12.
Columns of other tables that clash with table A get a suffix (e.g. _B). When a key is repeated within a table, all combinations are produced by default (as in a database join); you can keep only the first row instead.
“Matching by table” lists unique keys, keys shared by all tables and unmatched keys for each table, which helps spot inconsistent naming.
Relational join semantics (inner / left / full outer) as in SQL and pandas merge.
Up to 300,000 rows per table.
Send us your data and research question and you will receive a written plan within 1 working day: analysis steps, parameter rationale, deliverables and timeline. Quoted per project.