Import Fields using CSV, XLS files

Overview

For teams that manage data definitions in offline spreadsheets or are migrating legacy schemas where a direct API connection isn't feasible, the Upload File method is the optimal solution.

UnifyApps allows you to upload standard spreadsheet formats to bulk-create entity fields.

This feature parses the column headers of your file to automatically generate the corresponding Field Keys and Display Labels in the Entity Designer, significantly reducing the manual effort required to set up large data models.

The Import Process

1. Initiate Import From the Entity's Fields tab, click the Import Fields button located near the top right of the interface.

2. Select File Method In the "Import Fields" modal, select the first option: Upload File. As indicated by the description "Import schema from csv or xls," this method supports both standard comma-separated value files and Excel spreadsheets.

   
   

3. File Preparation & Parsing Before uploading, ensure your file is formatted correct

   fieldName	fieldType	label	description	primaryKey	required	searchable
   field_1	string	Field 1	This is a string field that contains field 1 data	FALSE	TRUE	FALSE
   field_2	number	Field 2	This is a number field that contains field 2 data	FALSE	TRUE	FALSE
   field_3	Integer	Field 3	This is a integer field that contains field 3 data	FALSE	TRUE	FALSE
   field_4	number	Field 4	This is a number field that contains field 4 data	FALSE	TRUE	TRUE
   field_5	number	Field 5	This is a number field that contains field 5 data	FALSE	FALSE	FALSE

   Use Cases

   • Legacy Migration: Quickly recreating a database schema from an exported report of an older system.

   • Offline Modeling: allowing data architects to design the schema in Excel and upload it only when finalized.

   • Bulk Updates: Adding a large batch of new columns to an existing entity without manual click-throughs