Instadeq as a Free Online CSV Data Transformation Tool
Instadeq supports all operations required to import, manipulate and export tabular data such as CSV files.
Below is a list of common operations, you can use instadeq for free without an account to work with tabular data by visiting the following link: https://app.instadeq.com/?try
You can also visit https://app.instadeq.com/ and select the Try it Now button.
If you have an account you can keep useful transformations on decks to reuse them every time you need them without having to redo the steps.
How To Load a CSV File
Follow this guide for details: How to Load Data from a CSV File
The short version:
Create a new card and select the card type CSV File
Drop the file in the drop area or click on it to open the file picker and select it from there
How to Export a Table as a CSV File
To export the Output table from a card select the toggle actions icon on the card's top right and then select the export button to download the table as a CSV file.
Column Operations
How to Remove Columns
To remove a column from the Output table:
-
Select the column you want to remove from the Query section
(Select, Chart, Group By)
Select the remove button
To completely remove the field from the card:
Select the field from the input section or the calculated fields section
Select the remove button
Confirm the action by selecting the remove button once more
How to Rename Columns
To rename a column:
Select the field from the input section or the calculated fields section
Select the edit button
Write the new name in the input field that appears
-
To confirm do one of the following:
Select the confirm button
Press the ↵ Enter key
-
To cancel do one of the following:
Select the cancel button
Press the Esc Escape key
How to Reorder Columns
To reorder a column:
-
Drag a column on the Output table and drop it onto another column:
Drop it on the left side to move it to its left
Drop it on the right side to move it to its right
Alternatively you can reorder columns by doing the same in the Query section:
-
Drag a column on the Query section and drop it onto another query field:
Drop it on the left side to move it to its left
Drop it on the right side to move it to its right
How to Add Columns
There are different ways to add new Output columns:
A new column whose value is derived from existing inputs and/or calculated fields
-
Create a new calculated field by selecting the + new calculated field button
Rename as needed
Select the default formula 0 to open the formula editor and edit the formula as needed
Drag it to the appropriate Query placeholder to add it to the query
A new input column from another card's output columns
Drag an Output column from another card into the appropriate Query placeholder to add it to the query
An Alternave way to achieve the same:
Select the target Query placeholder to open a list of available Output columns from other cards
Select the desired columns from the list to add them to the selected target
How to Combine Columns
Create a new calculated field by selecting the + new calculated field button
Rename as needed
Select the default formula 0 to open the formula editor and edit the formula as needed
Add existing inputs and/or calculated fields to the formula
If the intermediate values are not required in the output table you can remove them.
How to Sort By Columns
Select the sort icon to the right of one or more columns to cycle through the sort options:
No Sort
Sort Ascending
Sort Descending
When sorting by more than one column the order in which they sorting is enabled affects the result.
To know the sorting order hover over each column that has sorting enabled to get the sort order as a tooltip.
How to Add All Columns From a Card at Once
Select the target Query placeholder to open a list of available Output columns from other cards
Select the add all button to the right of the list of columns you want to add
Row Operations
How to Filter Rows
Build Filter Formula From Scratch
Create a new filter condition by selecting the + new filter button to the right of Where condition
Select the default formula to open the formula editor and edit the formula as needed
Create a Filter Formula By Example
Drag a value from the input table and drop it into the Where condition placeholder to create a condition that matched the provided example
Edit as needed