AlphaSheets is web-based and can be opened from any of the following browsers: Google Chrome, Firefox, or Safari. Use the latest version of Google Chrome for the best experience. Internet Explorer is not supported at this time.
Navigate to https://app.alphasheets.com/register in your browser to get started.
AlphaSheets supports .xlsx, .xlsm, and .csv files. You can import these via the File... Import menu:
AlphaSheets supports Excel/Google Sheets formulas, with most of the popular functions available.
Start typing in a cell to see a suggested list of formulas. When a cell is selected, its dependencies are highlighted.
Reference other cells by typing the coordinates (A1:B4), clicking the cell, or using the arrow keys to navigate.
See the list of supported formulas.
Read this section to understand the key benefits of AlphaSheets for number crunching and analysis.
4a. Introduction to Tables
In AlphaSheets, you'll mainly work with data that lives in Tables. These are like in Excel or Google Sheets, but they include additional controls beyond Sorting and Filtering to analyze the data. ITables are also connected to an underlying data source, such as a CSV or PostgreSQL connection.
To create a table, click the Add Dataset button on the right side of the page.
Tables can be moved and resized anywhere on the worksheet, and support up to 2 million rows:
To create Tables from other data sources, read the tutorial on importing data.
4b. Sculpting data in Tables
Once a Table is created in your worksheet, right-click a column to begin transforming data. You can sort, filter, group, aggregate, clean, and more. You can also highlight multiple columns to delete or keep them. Deleting individual rows is not possible without a filter.
Users familiar with data analysis are highly recommended to read the tutorial on transforming data.
4c. Using Tables with formulas
You can use regular spreadsheet formulas in tandem with Tables. There are a few spreadsheet-like workflows that are enabled for creating custom computations involving tables:
i. reference columns or individual values in cells
Reference data in tables using the following syntax in your formulas:
ii. create computed columns using autofill
To the right of any table, enter a formula that references other columns in the table or cells. Drag down the formula or double-click the blue box to created a calculated column:
i. use the computed column creator
With the table or any column in it selected, a + button will appear. Click the button to enter a column formula:
Say goodbye to the cumbersome Pivot Table builder. In AlphaSheets, grouping and summarizing data is done in-place with simple transforms. Read up on it here
Click the chart button on a Table to generate a list of recommended charts.
To build your own, we recommend reading the docs to understand the rich library of visualizations supported by AlphaSheets.
To share a workbook, click the share button in the top-left. You can share a workbook as read-only, and choose whether to require an AlphaSheets account for access.
To export a Table, click the Settings icon, and click Export as CSV.