First let's understand the difference between Spreadsheets & Databases
Quick video here:
Terminology
| Excel | Stackby | |
| Spreadsheet File | Workbook | Stack |
| Tabs | Worksheet | Table |
| Rows | Rows | Rows or Records |
| Columns | Columns | Columns or Fields |
| Cell | Cell | Cell |
| Views | Not there | In a table |
Prepare for Import
| Clean your tables | Each table should have uniformity across rows and columns |
| Make columns proper | Make sure each of the column represent a certain data type - Text, Number, Date etc. and properly formatted |
| Add column headers | Add the first row of the column as a header row and give a name to every column |
Ways to Import
There are multiple ways to import data in Stackby:
| Create a stack after import | Select 'Import Data' when creating new stack and bring data from CSV, Microsoft Excel or even copy paste from Google Sheets to create a new stack (database). |
| Create a table after import | Select 'Import Data' when creating a new table and bring data from CSV, Microsoft Excel or even copy paste from Google Sheets to create a new table. |
| Append data to an existing table | Use a Stackby Powerup, to append a CSV file in your existing table and map your columns to bring information. |
After Import
After you import, you'll see your table data as a text. You can then convert the data into relevant column types automatically in Stackby
- Changing the column containing paragraphs, into long text column type
- Changing the column containing numbers, into a number column type
- Changing the column containing tags, to single option column type
- Changing the column containing multiple tags, to multiple option column type
- Changing the column containing values, that are important to be referenced from a different table, to link column type (will create a new linked table).
Learn more in Stackby:
Add 25+ unique column types
Connect columns to popular services & automate data
Create custom views to visualize data differently
Collaborate and work with your team to get things done
