AltDat table
Prepare a table
Read CSV, Excel, JSON and other supported files. Choose a source format and, optionally, a worksheet, delimiter or header row.
Documentation
Find the action you need
Browse all 27 workflow actions. Prepare a file, pass its table content through your actions, and export the result.
SQL and workbook preparation require paid access on your AltDat plan. Microsoft connector licensing is separate. Read about workbook credits.
27 actions
Files & Excel
Bring files in, return rows to your flow and save your results.
Tables arrayPaid plan
Prepare an Excel workbook
Read multiple worksheets as separate tables or combine them into one table with worksheet names.
JSON rows
List rows
Return a table to your flow as one record per row, for Apply to each, creating items or sending emails.
File
Export a table
Save an AltDat table as CSV, Excel, JSON, Parquet or another supported format.
Clean & reshape
Choose, organize and summarize your data.
AltDat table
Filter rows
Keep rows that match a condition on a column.
AltDat table
Sort rows
Put rows in ascending or descending order.
AltDat table
Select columns
Keep the columns you need in the order you choose.
AltDat table
Rename a column
Give a column a new name while preserving its values.
AltDat table
Remove duplicate rows
Keep one matching row or only rows with no duplicates, using selected columns or the full row.
AltDat table
Fill missing values
Replace missing values with a chosen value or supported fill method.
AltDat table
Change a column type
Convert a column to the data type needed by the next action.
AltDat table
Group and summarize rows
Group matching values and count rows or summarize a value column.
AltDat table
Pivot a table
Turn values from one column into columns for a summary table.
AltDat tableAdvanced
Run a transformation pipeline
Apply an ordered set of operations in one action using a JSON pipeline.
Text & JSON
Extract values, compare text and expand lists.
AltDat table
Extract text with a pattern
Extract the first regular-expression match or capture group into a new column.
AltDat table
Clean text
Trim whitespace or change letter case, keeping the original column.
AltDat table
Replace text
Replace matching text and write the result into a new column.
AltDat table
Compare text by edit distance
Count the edits needed to make two values match. A distance of zero means equal.
AltDat table
Compare text similarity
Score two text values with Jaro-Winkler similarity. One means equal; lower scores mean less similar.
AltDat table
Extract a JSON value
Read a JSON path from a column into a new text column. Missing values return null.
AltDat table
Expand a list into rows
Make a row for each list item and repeat the other columns alongside it.
Combine tables
Match records or stack datasets.
AltDat table
Join two tables
Match rows from two prepared tables using a shared key column.
AltDat table
Append two tables
Stack a second prepared table underneath the first.
Analyze & SQL
Inspect a table and answer questions.
JSON report
Describe a table
Get ordered column names, row and column counts, and numeric summary statistics.
JSON report
Find correlations
Compare relationships between numeric columns with a correlation matrix.
JSON report
Analyze a distribution
Inspect per-column distributions and summary statistics.
JSON rowsPaid plan
Query a table with SQL
Run one read-only SQL query against the prepared table named data.