“Table Tools”


On-line tools to speed up your manual spreadsheet work

A block arrow

1. Select a tool by clicking the tool name in the menu below, or hover for a quick-glance tutorial

A block arrow

2. Paste a section of a spreadsheet in the yellow text area below, or click "Import from clipboard"

A block arrow

3. Activate the tool you want by clicking one of the buttons marked ">" under the yellow text area

A block arrow

4. Copy the contents of the yellow text area below, or click "Export to clipboard"

Specifying Delimiter


Specifying Delimiter Between Columns

      

Creating Look-Ups


Creating Automatic Look-Ups for a Column

      

Converting Dates


Date Conversion Format in a Column

      

Combining Series


Combining Columns of 0 to 1 Series or White Space

      

Clearing White Space


Clearing White Space in a Column

      

Quick Diagnosis


Diagnose Quickly the Main Parameters in a Column

      

Interpreting Social Security Numbers


Interpreting Information in Swedish Social Security Numbers

      

Specifying Delimiter


Specifying Delimiter Between Columns


This tool specifies the delimiter between columns, and you can toggle between two commonly used delimiters:

  • tab sign
  • comma

Creating Look-Ups


Creating Automatic Look-Ups for a Column


This tool creates an automatic look-up for data in a column by:

  • counting the number of unique data instances
  • displaying and enumerating the unique data instances

You can choose between:

  • table format (with key numbers attached)
  • string format

You can also create a standardization for any column that automatically inserts the same enumeration as in the corresponding look-up.

Converting Dates


Date Conversion Format in a Column


This tool insures correct dating between two commonly used formats:

  • YYYY-MM-DD
  • MM/DD/YYYY

Combining Series


Combining Columns of 0 to 1 Series or White Space


This tool combines multiple columns of 0 to 1 series (or white space) in a single column.

The main function of this tool is to create a multiple-layer prioritization in which the figure '1' always has a higher priority than the figure '0'. In turn '0' has a higher priority than white space.

This tool also allows you to clear any rows that are incomplete.

Clearing White Space


Clearing White Space in a Column


This tool clears any positions in a column that holds no data (only white space).

Quick Diagnosis


Diagnose Quickly the Main Parameters in a Column


This tool gives you instant access to an array of common parameters:

  • number of positions in the column of data
  • number of positions that hold data (as opposed to white space)
  • number of unique data instances
  • column total
  • column mean value
  • column minimum
  • column maximum
  • column median

Interpreting Social Security Numbers


Interpreting Information in Swedish Social Security Numbers


This tool extracts 3 dependent attributes from Swedish social security numbers:

  • year of birth
  • date of birth
  • gender