Import a spreadsheet into a database
Save or export the spreadsheet as a CSV file first; Excel, Numbers and most spreadsheet apps can. The first line of the file names the columns. You need edit access to the database.
Make a new database from a spreadsheet
Section titled “Make a new database from a spreadsheet”-
Open the folder it belongs in.
-
Choose New, then New database from CSV…, and pick the file.
The database takes the file’s name, and the import window opens with every column of the file set to become a new column. Stuga picks each new column’s type from its values.
-
Go on from step 3 below.
Import into a table
Section titled “Import into a table”-
Open the database and select the table you want to fill.
-
In the ⋯ menu beside Share, choose Import…, then drop the file in the window or click to choose it.
Stuga checks every row and says how many are ready.
-
Under Columns, check where each of the file’s columns goes: to a column of the table, to a new one (such as New column: Number), or nowhere (Skip this column). A column whose name is a typo away is marked (close match).
-
If some rows have a problem, a list shows each one: its Row, Column, Value and Problem. Fix them in the file and choose Change to pick it again, or go on without them.
-
If the file has dates like 1/4/26, say how to read them: Month / day / year or Day / month / year.
-
Choose the button at the bottom. It says what will happen, such as Import 120 rows or Import 118 rows, skip 2.
When it’s done, Done closes the window and the rows are in the table.
To keep the file apart, choose A new table under Import into, and type its Table name.
A file can be up to 10 MB, unless the person who set up Stuga raised the upload limit. Tab-separated and JSONL files work too.
Undo an import
Section titled “Undo an import”Open the side panels with the Side panels button, and choose Activity. If the import can still be undone, it shows Revert.
Good to know
Section titled “Good to know”An AI tool can import a file too. The whole file goes in at once as one change, which you can undo under Review → Agent changes. On a verified database it waits for the owners, with Accept all and Reject all in the bar above the table; to say what should change, choose Reject all with note… in the menu beside Reject all. See See and undo what an AI changed.
If the AI tool can’t send the file itself, it may give you a link that opens this same import window, for you to finish.
- Download a table as CSV: take rows back out.
- Create a database: set up the columns first.
- Import from Notion: bring a whole workspace.