Skip to main content

Importing Data with CSV

110 viewsUpdated March 10, 2026By Onbrix Team
importcsvdatamigration

CSV Import Guide

You can import data into any module using CSV files.

Preparing Your CSV File

  • Save your data as a .csv file (comma-separated values)
  • Include a header row with column names
  • Ensure date fields use a consistent format (e.g., YYYY-MM-DD)
  • Remove any completely empty rows
  • Import Steps

  • Navigate to the module you want to import into (e.g., Contacts)
  • Click the Import button in the toolbar
  • Upload your CSV file
  • Map columns: Match your CSV columns to Onbrix fields
  • Preview the data to verify mapping
  • Click Import to start
  • Tips for Successful Imports

  • Duplicates: The import will create new records for each row. Clean your CSV first to avoid duplicates
  • Required fields: Ensure all required fields have values
  • Lookup fields: For fields that reference other modules (e.g., Account on a Contact), use the exact name or ID
  • Large files: For files with more than 1,000 rows, consider splitting into smaller batches
  • Encoding: Save your CSV with UTF-8 encoding to handle special characters
  • Exporting Data

    You can also export any module's data to CSV:

  • Go to the module's list view
  • Click Export in the toolbar
  • Choose which fields to include
  • Download the CSV file