Privacy-first, cross-platformÂ
spreadsheet automationAutomate tedious spreadsheet tasks. Available on Web, iOS, macOS and Windows.
Why Tablesmith
Tablesmith is an automation-oriented tool designed to decouple your spreadsheets from your automation processes. This means that Tablesmith is not a spreadsheet editor. When you open Tablesmith, you will see a pipeline builder instead. Spreadsheets are merely the input/output components of a pipeline. If this is confusing, I highly recommend watching the demo video above, which demonstrates how Tablesmith works.
Privacy-Focused Design
We prioritize your privacy at every step. For logged-in users, Tablesmith only stores your pipelines and ensures that your spreadsheet data stays on your device. For guest users, all data are stored on your device and no internet connection is needed.
Free and Intuitive
Tired of complex data workflows and ETL jobs? Struggling with Power Query, DAX, or M language? Tablesmith is easy to learn! In just 15 minutes (5 minutes watching the demo + 10 minutes trying it yourself), you’ll be up and running.
Cross-Platform & Mobile-Friendly
Work seamlessly across web, iOS, macOS and Windows, facilitated by our cross-platform capabilities and mobile-friendly UI/UX.Cconsider using the Tablesmith app if available for a more streamlined experience.
Flexible Input and Output
Tablesmith seamlessly handles both CSV and XLSX formats for both input and output. Whether you use Excel, Google Sheets, Airtable, WPS, or LibreOffice, Tablesmith is your one-stop shop for data pipeline.
Spreadsheet Automation
Tablesmith offers six stage types: filter, sort, group, add column, update column, and data extraction. You can combine these to form highly complex pipelines. All stage types are easy to understand and configure. You can add them in seconds, and with the powerful formula editor, you can write formulas using columns and variables. Another cool feature is that you can publish your pipeline as a web app. Check out the demos below; they are all real pipelines.
Demo Pipelines
You can run these pipelines without logging in. Download a demo input file first(tracks.csv or tracks.xlsx). Clicking any pipeline will take you to its shared page where you can simply click Run and select the downloaded file. Curious about the pipeline’s inner workings? Just click the Clone button.
Spotify Tracks Demo 1
This pipeline automatically organizes tracks by genre. Each genre will be displayed in a separate sheet containing the 30 most popular tracks.
Spotify Tracks Demo 2
This pipeline calculates the percentage of popular tracks (popularity >= 70) out of all tracks for each genre. The results are then sorted by the calculated popularity in descending order and returned in percentage format.
Spotify Tracks Demo 3
This pipeline will create a random playlist matching your input energy level and count.
Generic Sort Group Top10
This pipeline sorts your data by a numerical column (like ‘popularity’) and groups it by a text column (like ‘playlist_genre’). It then keeps only the top 10 entries within each group. Make sure you map right columns contain ‘sort_by’ and ‘group_by’ information. All other data will be included in the final output.
If you have any questions or suggestions, please feel free to send a message now: