1. Select a tool by clicking the tool name in the menu below, or hover for a quick-glance tutorial
2. Paste a section of a spreadsheet in the yellow text area below, or click "Import from clipboard"
3. Activate the tool you want by clicking one of the buttons marked ">" under the yellow text area
4. Copy the contents of the yellow text area below, or click "Export to clipboard"
Import a whole table from your spreadsheet here
Import a single column from your spreadsheet here
This tool specifies the delimiter between columns, and you can toggle between two commonly used delimiters:
This tool creates an automatic look-up for data in a column by:
You can choose between:
You can also create a standardization for any column that automatically inserts the same enumeration as in the corresponding look-up.
This tool insures correct dating between two commonly used formats:
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.
This tool clears any positions in a column that holds no data (only white space).
This tool gives you instant access to an array of common parameters:
This tool extracts 3 dependent attributes from Swedish social security numbers:
Documentation for all tools is accessible through directing the mouse toward the tool name in the left-hand navigation pane in the production window.
Additional documentation can be accessed by clicking the link Documentation in the main navigation bar above.
Any questions about the website are answered by our web editor:
Ödeshög Health Care Centre
SE-599 31 ÖDESHÖG
Telephone: (+46) 10-104 87 16
“Table Tools” had its beginnings in a student assignment that was undertaken as part of an introductory course in Web Development, an introductory course at Luleå University of Technology (Sweden) in 2013.