Specifying Delimiter

---

Specifying Delimiter Between Columns

Import a whole table from your spreadsheet here

       Small text Medium text Large text

Creating Look-Ups

---

Creating Automatic Look-Ups for a Column

Import a single column from your spreadsheet here

       Small text Medium text Large text

Converting Dates

---

Date Conversion Format in a Column

Import a single column from your spreadsheet here

       Small text Medium text Large text

Combining Series

---

Combining Columns of 0 to 1 Series or White Space

Import a whole table from your spreadsheet here

       Small text Medium text Large text

Clearing White Space

---

Clearing White Space in a Column

Import a single column from your spreadsheet here

       Small text Medium text Large text

Quick Diagnosis

---

Diagnose Quickly the Main Parameters in a Column

Import a single column from your spreadsheet here

       Small text Medium text Large text

Interpreting Social Security Numbers

---

Interpreting Information in Swedish Social Security Numbers

Import a single column from your spreadsheet here

       Small text Medium text Large text

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