dataflow-lab is a local-first data workbench for Windows. It helps you clean data, explore it, make charts, and build dashboards in one place. It also creates SQL and Python pipelines for common tasks.
You keep your data on your computer. That makes it a good fit for private files, small teams, and offline work.
- Import CSV, Excel, and SQLite files
- Clean data with simple point-and-click tools
- Filter, sort, and group rows
- Build charts and tables
- Create dashboards from your data
- Generate SQL queries for analysis
- Generate Python steps for data prep
- Work with local files on your PC
- Save your work for later use
- Windows 10 or Windows 11
- 4 GB RAM minimum
- 8 GB RAM recommended
- 500 MB free disk space
- Internet access for the first download
Visit this page to download the Windows release:
Look for the latest release and download the Windows file from that page.
- Open the download page in your browser.
- Find the latest release at the top of the page.
- Download the Windows version of dataflow-lab.
- If the file is a
.zip, open it and extract the contents. - If the file is an
.exe, double-click it to start the app. - If Windows asks for permission, choose Yes.
- Wait for the app to finish opening.
- Start dataflow-lab from the file you downloaded.
- If you see a setup screen, follow the on-screen steps.
- Choose the folder where your data files are stored.
- Open a CSV, Excel, or SQLite file.
- Review the data in the main table.
- Use the tools on the side panel to clean or explore the data.
- Click Open File
- Select a CSV, Excel, or SQLite file
- Wait for the file to load
- Remove blank rows
- Rename columns
- Fix date and number fields
- Replace empty values
- Filter out rows you do not need
- Sort by a column
- Group rows by category
- Check totals and counts
- Look for missing values
- Scan for repeated rows
- Choose a chart type
- Pick the field for the X axis
- Pick the field for the Y axis
- Adjust labels and colors
- Save the chart to your dashboard
- Add one or more charts
- Place tables beside charts
- Rearrange panels
- Save the dashboard layout
- Open it again later
dataflow-lab can create useful starting steps for analysis.
Use SQL when you want to:
- Filter rows
- Join tables
- Group data
- Build saved queries
- Reuse the same logic on the same files
Use Python when you want to:
- Prepare data for later use
- Repeat a cleaning task
- Build a simple data pipeline
- Export results after changes
The app writes starter code based on the data you load. You can use it as a base for your own work.
- Open a CSV file with sales data.
- Remove blank rows and fix column names.
- Group the data by month and product.
- Create a bar chart for sales totals.
- Add the chart to a dashboard.
- Save the cleaned file and the dashboard for later use.
dataflow-lab works well with:
.csv.xlsx.xls.sqlite.db
- Use the search box to find columns fast
- Drag columns to change order
- Right-click a table for more actions
- Save often when you make changes
- Keep source files in one folder
- Use short file names with no extra symbols
Try these steps:
- Download the latest release again.
- Make sure the file finished downloading.
- Right-click the file and choose Run as administrator.
- Check that Windows did not block the file.
- Restart your PC and try again.
- Use the newest Windows update if the app still does not open
bi-tool, dashboard, data-analytics, data-cleaning, data-pipeline, data-visualization, eda, etl, local-first, nodejs, react, sql, sqlite
dataflow-lab is built for local data work. It keeps the process simple, with a focus on loading data, shaping it, and turning it into useful views. It is a good match for users who want one app for cleaning, charts, and dashboard work without moving data to another service