For each CSV data set, press the Add button and add the CSV data in the text area. For Google Trends, the CSV data should follow these rules:
| Button | Description |
|---|---|
| 📄 New | Disregards all existing data and starts a new project. |
| 💾 Save | Saves the data to a file. |
| 📋 Copy | Copies the data to the clipboard. |
| ➕ Add... | Shows a dialog where new data can be added. |
| 🖌️ Format... | Shows a dialog where values can be formatted. |
| ☑ % Percentages | Converts the values of rows/columns to percentages. Note that all values in the same row/column must be relative to one another. Either the data must have been provided as relative numbers, or the data must have been normalized. Formula: VALUE = VALUE / SUM(VALUES) * 100 |
| ☑ ⊷ Smoothen | Smooth all numeric values in the same row/column, using moving average. The smoothened value will be the average of the previous value, next value and itself. |
| 📐 Display density | Sets the width and height of all table cells. Compact will result in a small-sized table. Comfortable will result in a medium-sized table. Default will result in the intended large-sized table. |
| Button | Description |
|---|---|
| ⤨ Transpose | Rotates the data by 90 degrees, which means that rows become columns and columns become rows. |
| Button | Description |
|---|---|
| ☑ 🏷 Detect types | If turned on, the type of each value is automatically detected and the value will be converted to that type. If turned off, the value will remain a string. |
| ☑ ↮ Remove duplicate columns | Removes all columns from the new data that have the same name as one of columns in the existing data. |
| ☑ ⭊ Normalize values | If checked, all values of the new data will be made relative to the existing data. This only works when both the new and existing data contain the same column name (see field Normal column). If no columns with the same name can be found, normalization will fail. If you are uncertain about what this setting is doing, it's better to turn it off. |
| 🔀 Add data as | Defines how the new data should be added to the existing data: as rows or as columns. If it is set to Auto Detect, the application determines the mode based on the number of columns and rows. If the number of new rows is equal to (or comes close to) the number of existing rows, the new data is interpreted as columns. Otherwise, if the number of new columns is equal to (or comes close to) the number of existing columns, the new data is interpreted as rows. |
| 🔤 Normal column | The column to use when normalizing values. If set to Auto Detect, the first column that exists in both the new and existing data will be used. |
| 📄 Clear | Clears the text area holding the new data. |
| ❌ Cancel | Disregards the new data and closes the window. |
| ✔️ OK | Adds the new data to the existing data and closes the window. |
| Button | Description |
|---|---|
| ☑ 📅 Format dates | If checked, dates will be formatted using the specified date format. |
| Date format | Format to use when formatting dates. Supports years (Y), quarters (Q), months (M), weeks (W), days (D), hours (H), minutes (m) and seconds (S). |
| ☑ 🔢 Format numbers | If checked, numbers will be formatted using the specified number format. |
| Decimals | Number of decimals to use when rounding and displaying numbers. |
| Prefix | If set, numbers will be preceded by the prefix. |
| Suffix | If set, numbers will be succeeded by the suffix. |
| ☑ 🔤 Format text | If checked, strings will be formatted using the specified text format. |
| Length limit | The maximum length a string can have. Any characters exceeding this limit will be truncated. |
| Side | The side of a string that will be truncated when it exceeds the length limit. |
| Indicator | When a string exceeds the length limit, the indicator (typically an ellipsis) will be added to the side of the string that has been truncated (start, middle or end). |