Learn how to import or export existing data from Ninox
You may import and export data in Ninox, for example, if you want to transfer data from another program from the start, or if you want to share data with people who don't use Ninox.
A number of options are available for exporting or backing up your data from Ninox
In general, you don't need to worry about your data. When you use Ninox Cloud, Ninox periodically creates automatic backups of your data, and you can restore them whenever you need them.
In addition, however, you may want to download or export your data for a couple of other reasons.
Perform the following steps to export a database in a workspace in one go:
Go to the workspace overview, where you can see all databases of your workspace.
Hover the mouse over the database you want to export until you see the arrowhead .
Select Create backup.
By default, all options except change history are selected in the following popup. So your backup automatically contains the following values:
all data
all attached files
all comments
Click OK.
In the Manage backups popup, under Manual backups, find the latest backup at the top. Select the appropriate backup and click Download backup. Locate the file in your downloads.
The downloaded file is in the Ninox format (.ninox
).
Perform the following steps to export a table from a database in a workspace:
Open the table you want to export.
Select Export data from the dropdown menu.
Select the desired format (CSV or Excel) and click Download.
Click the gear icon in the upper right corner.
An introduction to importing CSV files to Ninox
To import a CSV file to an existing or a new table in Ninox:
Go to the database where you want to upload your CSV file.
Click on Import Data.
The Import Wizard opens and you click the Import CSV file button in the Import data pop-up.
Select the appropriate file on your device and click Open, follow the prompts until you see your data, and click the Import now button in the bottom right corner to import your data. Done!
That was the quick tour! On the way, you have certainly seen that you can do much more there.
Using the Import Wizard (we named the pop-up this way for simplicity), you can set various options.
Help the Import Wizard by giving it details about the data you want to import.
If you want to import dates, specify the format of the dates to be imported, if possible so that they can be transferred correctly.
Specify which data should be imported and what exactly should happen to it.
Click Next and the following pop-up appears:
In the next step, name the table and assign fields.
If you import data into an existing table, matching field names are automatically assigned to each other.
After that, you will see a preview of the data to be imported. Click Import now. Done!