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.
Handle the data work inside your flow
Choose an action for common table tasks. Add a SQL query when you need a custom calculation.
File conversion
Read Excel, CSV, JSON or columnar files. Export the results in the format your next step needs.
Table cleanup
Filter rows, remove duplicates, fill empty values and group totals with dedicated workflow actions.
SQL when you need it
Use SQL for custom calculations and analysis on paid plans. Return the result as rows your flow can use.
Excel workbooks
Prepare a named sheet, or use the paid workbook action to discover sheets and keep them separate or combine them.
Built for Power Automate
Pass table content from one action to the next. Export the finished result to save or use elsewhere in your flow.
Access you control
Create and revoke API keys from your dashboard. Requests use HTTPS, and the dashboard shows your credit usage.
Supported Formats
Plans for your workload
Start free. Choose a paid plan for more capacity, SQL or workbook processing.
Build your first data workflow
Follow the tutorial to prepare an orders file, filter its rows and export the result. Start with a free account.
- Free monthly credit allowance
- Every supported table & spreadsheet format
- Power Automate connector
- No credit card required