Welcome to the Columns User Guide
Note: This user guide is still under construction!
We've populated some of the more important aspects (eg. Getting Started, Add Column, etc.) but there's still work to be done! As a result, some pages are still blank. Please bear with us as more content gets added within the upcoming weeks.
Thank you!
Why Columns?
Columns is a lightning-fast, intuitive app for quick and simple data transformations. It strives to let you work with data the way you think. We like to think of it as the Photoshop for Data, or the Missing Office Tool. You'll be able to be much more efficient in data transformations here than you would be in Excel, for example.
Whether you're dealing with complex joins, multiple data sources, or millions of rows, Columns gives you immediate results without the complexity of programming or the limitations of spreadsheets.
Quick Links
These guides are designed to get you up and running with Columns as quickly as possible.
First time using it? Go to Installation
Need a quick formula cheatsheet for "Add Column"? Go to Add Column
What makes Columns great?
- โก Lightning Fast: Load and process millions of rows instantly on your local machine.
- ๐ Zero Config: Open your data and start working immediately - no setup required.
- ๐ Immediate Feedback: See results in real-time as you work, no "run" button to see your work.
- ๐ฏ Visual Interface: Complex operations become intuitive through direct manipulation.
- ๐ป Local-First: Your data stays on your machine, with no need for internet access or the cloud.
Basic Concepts
Columns is built around projects, not datasets. While you're working, you're not actually editing the underlying data at all! Rather, this is what is called non-destructive editing - all changes are trackable, anything can be changed.
These projects are held in files with the extension .colm
, which only references the underlying data, rather than physically holds it (unless you're using the "Edit Table" feature - which we'll go into later).
We go into more detail about this here.
Need Help?
As this is an early private beta, it's very likely you'll run into a bug or other major issue!
If you need help, don't hesitate to get in touch via email. We'll get back to you within 12 hours at most ๐.
Or, for more in-depth help, you can also book a call with a Co-Founder.