# Import data > [HTML Version](360009354059.html) You can import data by uploading Excel spreadsheets and **.csv** files to BRIX apps. So you can quickly add a large amount of data to the system. ```` начало внимание ```` By default, [all users](360006871932.md#all_users) can import data to the system. Learn how to restrict import in the [Access to app data](360007527512.md) article. ```` конец внимание ```` You can also add or update app items in batches by using scripts. For more information, see the [Batch operations with app items in scripts](batch-actions.md) article. To start importing data, follow these steps: **1. Create an app that will store the data**. To ensure that data is imported correctly, add fields to the app [form](360007235031.md#create_form) that will store this data. Suppose you want to upload your customer database to BRIX. Customer data is stored in a **.xlsx** table in the following columns: company name, phone, email address, contact person, and bank details. In order to complete the import, you first need to create an app and add fields of the [corresponding types](360009707032.md) to its form: **String** (to store names), **Phone Number**, **Email**, **Full Name**, and **Text**. **(data-import-1.png)** If the **Status** system field is specified in the table you import, [statuses](360009920611.md) need to be configured in the app. **2. Generate a template for the app**. A template is used to make the file you are going to upload meet the import requirements. To download the template, click the **(three-vert-dots-icon.png)** icon in the upper right corner of the app page and select **Data Import**. In the window that opens, choose the type of template depending on the type of file you are planning to import: **.xlsx** or **.csv**. **(data-import-2.png)** **3. Bring the file you want to import according to the template**. The template contains a table with columns that match app fields. In each column, there is an example of data it can contain. **(hmfile_hash_c2604e28.png)** You can copy the names of fields from the template into your file or fill out the template with your data. Here are the requirements for the format of the data you want to import: | | | | | |------|------|------|------| | **Field type** | **Data format in the template** | **Note** | **Example value** | | Name | Text | | Invoice | | String | Text | | Order | | Number | Integer or non-integer | In the format preset in the template column. | 27.37 | | Yes/No switch | **true** or **false** | **true** means the variable is switched to **Yes** or another value that replaces it.
**false** means the variable is switched to **No** or another value that replaces it. | Text value: Enabled
Value in the template: **true** | | Date/Time | Date and time | In the format preset in the template column. | 4/17/2022 3:27 PM | | Category | Text | The option of the **Category** field (the name, not the code) assigned to the field during import. | Let’s say the **Delivery** field has three values: Customer pickup, Courier delivery, and Parcel collection. You need to import an order delivered by courier. To do this, in the import template in the row with order data in the **Delivery** column, specify **Courier** delivery. | | Money | Integer or non‑integer | | 125.6 | | Account | | Cannot be imported. | | | Phone Number | Integer | | 16505551122 | | Email | Text | Format: name@domain | name@example.com | | Files | File name\[file ID\] | You can only import the ID of the file uploaded to BRIX. It will be displayed in the browser address bar, if you click on the file name. | file1\[fd2af6d9-3e95-4896-9604-250929347acb\] | | Image | Image name\[image ID\] | You can only import the ID of the image uploaded to BRIX. It will be displayed in the browser address bar if you click on the image name. | image1\[fd2af6d9-3e95-4896-9604-250929347acb\] | | Full Name
| Text | The first word is considered the last name, the second one the first name, and the others the middle name. | Rogers Sarah Jane | | Link | Link text | | https://brix365.com/en | | Table | \[\{"rows":\[\{"column code":\{"cell code": "cell value"\}\}\], "result":\{"\_\_count":number of rows in the table\}, "view":""\}\] | A string listing all cells in the table with their values.
Specify the number of rows in the **result** parameter.
Leave the **view** parameter without value. It will be filled in automatically if the [template view](360010201779.md#kind-of-table) is set up for the table. | For example, an entry for a table with **Account** and **Customer Name **columns, consisting of two rows:
\[\{"rows":\[\{"account":\{"login":"@example"\}, "name":\{"lastname": "Rogers", "firstname":
"Sarah", ‘middlename’: ‘Jane\}\},
\{"account":\{"login":"@example1"\}\},
"name":\{”lastname": ‘Rogers,
\{ "firstname":
"Sarah", ‘middlename’: ‘Jane \}\}\],
"result":\{"\_\_count":2\},"view":""\}\] | | Users | \[User’s ID\] | To get a user’s ID, go to **Administration > Users** and click on the name of the user’s account. The ID will be displayed in your browser’s address bar. | \[29cadb73-8246-4f3d-9992-87a4a1ad20cf\] | | App | \[App item’s ID\] | The app item needs to belong to the app that the field is linked with. | \[12f05b18-5559-40cb-b138-97b8d0233f4c\] | **4. Upload the file populated with data to BRIX**. When you make sure the file you are importing is aligned with the template, go back to the BRIX interface. Click the **(three-vert-dots-icon.png)** icon in the upper right corner of the app page and select **Data Import**. In the opened window, upload the prepared file. Here you can also check the **Ignore event handler** box. It disables all [event handlers](events_processing.md) configured in **Administration > Modules **while importing the data. This allows you to reduce the system load if an event handler runs whenever a new app item is created (for example, if a notification is sent or a business process is launched). Click **Import**, then **Close**. The new data will appear in the app. **(data-import-4.gif)** Please note that the importing speed depends on the number of app items and the number of indexes in the PostgreSQL database. Indexes are created in the database for each app property with the [Search and sort option enabled](360028941112.md#searchandsortbyfield). If you need to import a large volume of data, we recommend enabling this option after the import. ## Import features By importing files, you can update information stored in several app items at once. To do that, [export](360009264480.md) data from an existing app into a file (you need to check the **Export system information** box). Edit field values in the file, then import it back into the app. All edited app items will be updated. Please note that if you specify an ID (status: id) in the **Status** system field that does not exist in the app, the item will be assigned an initial status. **(data-import-status.png)** If you export data from an app without system information, new items will be created in the app when you import the file. ## Import multiple values You can import multiple values into one BRIX field. In this case, you should use comma (,) as separator. ```` начало примера ```` Example: company@example1.com, company@example2.com allow you to add two email addresses to one field. ```` конец примера ```` This works for the following [types of fields](360009707032.md): **Number**, **Category**, **Phone Number**, **Email**, **Link**, **Users**, and **App**. ## Possible errors The format of the uploaded data must match the type of field. Otherwise, you will see a warning indicating the row and column in which the incorrect entry was found. **(hmfile_hash_576e2c35.png)** Correct the entry and continue importing.