Clean and combine data in Power Automate

Prepare Excel, CSV and JSON files, filter or join their tables, and send the result to your next step. Use ready-made flow actions or call the API.

Get an email when AltDat launches

API example

$ curl -X POST https://api.altdat.com/v1/tables/convert

-H "X-API-Key: YOUR_API_KEY"

-F "file=@sales.csv" -F "target=json"

[

{"region": "West", "revenue": 128400},

{"region": "East", "revenue": 97200}

]

Handle the data work inside your flow

Choose an action for common table tasks. Add a SQL query when you need a custom calculation.

Read Excel, CSV, JSON or columnar files. Export the results in the format your next step needs.

Filter rows, remove duplicates, fill empty values and group totals with dedicated workflow actions.

Use SQL for custom calculations and analysis on paid plans. Return the result as rows your flow can use.

Prepare a named sheet, or use the paid workbook action to discover sheets and keep them separate or combine them.

Pass table content from one action to the next. Export the finished result to save or use elsewhere in your flow.

Create and revoke API keys from your dashboard. Requests use HTTPS, and the dashboard shows your credit usage.

Spreadsheets

CSV, TSV, XLSX

Data

JSON, HTML

Columnar

Parquet, Feather, ORC

Join the waitlist for an email when AltDat is available. You can explore the workflow guides while you wait.