CSV Import
What is CSV Import?
Section titled “What is CSV Import?”CSV Import lets you add large numbers of records to brix at once by uploading a spreadsheet file. Instead of adding materials, equipment, or assets one by one, you can prepare your data in a spreadsheet and import it all at once.
What you can import
Section titled “What you can import”| Record type | Where to find the import option |
|---|---|
| Materials | Click Materials in the sidebar, then click Import in the top-right of the page |
| Equipments | Click Equipments in the sidebar, then click Import in the top-right of the page |
| Assets | Click Assets in the sidebar, then click Import in the top-right of the page |
Importing a file
Section titled “Importing a file”The steps below use Materials as an example. The same process applies to Equipments and Assets.
-
Click Materials in the sidebar.
-
Click Import in the top-right corner of the page.
-
Download the template file to see the required column format.
-
Fill in your data in the template spreadsheet using the correct column headers.
-
Click Upload and select your completed file.
-
Review the field mapping — confirm that each column from your spreadsheet maps to the correct field in brix.
-
Choose how to handle duplicates: Ignore duplicates (skip existing records) or Overwrite existing (update records that already exist).
-
Click Import to start the process.
-
Wait for the import to finish. The status will update when complete.
Import statuses
Section titled “Import statuses”| Status | Meaning |
|---|---|
| Processing | The import is running. Do not close the page. |
| Success | All records imported successfully. |
| Warning | Import finished but some rows had issues. Check the import log for details. |
| Error | One or more records could not be imported. Review the error log to see which rows failed. |
Viewing import history
Section titled “Viewing import history”After each import, a record is saved in the import history for that section. Click any past import to view the log, including which rows succeeded and which had errors.
Frequently asked questions
Section titled “Frequently asked questions”Can I import clients?
Client import is not currently available through CSV Import. Clients must be added individually from the Clients section.
What happens if a column in my spreadsheet doesn’t match the template?
brix will ask you to map your column to the correct field during the import preview step. If a required field is missing, the import will not proceed.
Can I undo an import?
No. Imported records cannot be removed in bulk automatically. Check your data carefully using the template before importing.
Things to check
Section titled “Things to check”Import failed
Open the error log to see which rows had issues. Common causes include missing required columns, incorrect date formats, or duplicate records when overwriting is not selected.
Records are duplicated after import
If you imported with “Ignore duplicates” and records still appear duplicated, the matching field may not match exactly. Check that the field used for matching (such as a name or code) is identical to the existing record.