What is OneTable?

Last updated: 2021-10-15

OneTable (pronounced /wʌnˈteɪbl/) is a multi-platform (Win/Mac) software for combining tabular tables (Excel, CSV, etc.). Unlike other softwares like Excel Power Query, or Altryx, OneTable is designed from the ground up to be able to deal with inconsistent table header structure and supports multi-level header table structure out of the box. It also supports multiple tables in one sheet. The core feature is Header Mapping, which can help you unify all your datasets like a breeze.

Get Started

...

Example 1: Single-level header

Single level header table is like a table below.

...
1st step: Select files and sheets
...
2nd step: Set up header
...
3rd step: Header Mapping
...

The above picture show the table headers are not consistently named. The third table has a column "Customer-ID", where others are called "CustomerID"

...

"Mapping Feature" provides users ability to unify the inconsistently named column names.


4th step: Select columns for ouput
...

Select the columns for output


5th step: Generate output
...

Output file formats can be Excel (xlsx) or CSV (utf8, utf8-sig)


Example 2: Multi-level header

Multi-level header means table like below that could has more than one row as the table header.

...
1st step: Select files and sheets
...
2nd step: Set up header
...
3rd step: Header Mapping
...

"Mapping Feature" provides users ability to unify the inconsistently named column names.


4th step: Select columns for ouput
...

Select the columns for output


5th step: Generate output
...

Output file formats can be Excel (xlsx) or CSV (utf8, utf8-sig)


Utilities

This section contains utility functions and general tips

Rename Column Names

There are three ways to rename columns

loading="lazy" ...

Inside "Mapping Tool", right click the cell and choose "rename" from the context menu, or double click the cell to rename it.

loading="lazy" ...

Use the rename icon after a cell is selected.

loading="lazy" ...

In essence, "Peg" is also a function of renaming column names.

Check sheet missing common word

The sheets that do not have the "common word" you have selected will show up here. You can use the combobox to click open it.

...

How to use "Mapping Tool"?

Mapping Tool is a powerful technology to allow you quickly unify the inconsistently named columns.

...

Table Manager

Table Manager allows users to quickly select and unselect the tables that they aim to combine.

...

FAQs

Is CSV file supported?

Supported input files: Excel files (.xlsx, xls, xlsm) and CSV with different encoding formats are supported.

Supported output files: Excel (.xlsx), CSV (utf-8), CSV (utf-8-sig)

Excel cannot show some unicode characters (like Chinese or Japanese) by directly opening a utf-8 encoded CSV file. You can use utf-8-sig encoding instead.

If you do not intend to show unicode characters in Excel, it is recommended to use utf-8 when generating large-size output file, as utf-8-sig will make the output file larger in size.

How to dissociate sheet(s) from file?

In sheet selection pane, right click to open the dissociate tools

...

Deselect the file(s) to dissociate from the specific sheet.

...