Step-by-Step Ninox Tutorial: From Spreadsheet to Custom App

Step-by-Step Ninox Tutorial: From Spreadsheet to Custom App Spreadsheets are excellent for tracking basic data, but they quickly fall apart when you need automated workflows, relational data, or user permissions. Ninox is a low-code database platform that bridges this gap, allowing you to transform flat spreadsheets into powerful, custom business applications.

This guide takes you through the step-by-step process of migrating your spreadsheet data into Ninox and building a functional custom app. Step 1: Prepare Your Spreadsheet Data

Before touching Ninox, clean your existing spreadsheet (Excel or Google Sheets) to ensure a flawless import.

Isolate your tables: Separate different data types into distinct sheets (e.g., one sheet for “Customers,” another for “Invoices”).

Format headers: Ensure the first row contains clear, unique column names (e.g., “First Name”, “Email”, “Purchase Date”).

Clean formatting: Remove merged cells, blank rows, and trailing spaces. Keep date and currency formats consistent. Step 2: Create Your Ninox Database and Import Data

Once your spreadsheet is ready, log into Ninox to set up your workspace.

Click New Database, choose a blank template, and give it a name. Click Import data and select your Excel or CSV file.

In the import wizard, Ninox will automatically map your spreadsheet columns to database fields. Preview the data type assignments (e.g., text, number, date) and adjust them if necessary. Click Import Now. Your spreadsheet is now a Ninox table. Step 3: Define Data Relationships

The biggest advantage of Ninox over a spreadsheet is its relational database capabilities. Instead of duplicating data, you link tables together.

Go to your main table (e.g., “Invoices”) and enter Administration Mode (click the wrench icon). Click Edit Fields and select Link to another table.

Choose the table you want to connect to (e.g., “Customers”).

Ninox will create a relationship. Now, instead of typing out customer details for every invoice, you simply select the customer from a dropdown menu, pulling their data instantly. Step 4: Customize the User Interface (UI)

Ninox automatically generates a data entry form, but you can customize the layout for better usability.

Open a record in your table and click the wrench icon to drag and drop fields into a logical order.

Use Layout Elements to add headings, dividers, and tabs to group related information (e.g., “Contact Info” tab vs. “Billing Details” tab).

Adjust field widths to create a clean, multi-column dashboard look that fits your team’s workflow. Step 5: Add Calculations and Smart Fields

Replace fragile spreadsheet formulas with robust Ninox formula fields. In the field editor, add a new Formula field.

Use the visual formula editor or write simple scripts to calculate values. For example, to calculate an invoice total, you can use: ‘Price”Quantity’.

You can also use formulas to dynamically change field colors or show alerts based on conditions, such as highlighting unpaid invoices in red. Step 6: Create Custom Views and Dashboards

Instead of endless scrolling, build specific views for different tasks.

Click the + icon next to your table tabs to create a new view (e.g., “Pending Orders” or “Top Clients”).

Apply Filters and Sorting rules to display only the relevant data.

Switch the view type from a standard table to a Kanban board, Calendar, or Gantt chart depending on how you need to visualize your workflow. Step 7: Automate Workflows and Deploy

Take your app a step further by automating repetitive tasks.

Use Triggers to execute actions automatically. For instance, you can set a trigger that automatically fills in today’s date when a new record is created.

Add Action Buttons to your forms. You can script a button to bundle invoice data and generate a printable PDF report with a single click.

Finally, invite your team members, set up roles and permissions (read-only, editor, admin), and start using your custom application. If you want to tailor this application further, tell me:

What specific spreadsheet use case are you converting? (e.g., CRM, inventory, project management) Do you need to connect to external software via API?

What specific automation would save your team the most time?

I can provide the exact Ninox script code or schema design for your project.