Start a data import
Load structured records from an authorised file or configured connection.
Provisional sandbox guidance
Steps
- Choose the Data source and expand Expected columns.
- For an uploaded file, choose CSV or XLSX and select Validate file. For a configured connection, use Fetch and validate to retrieve its CSV.
- Open Reconcile records before requesting approval.
Before you start
Files can contain up to 2 MB, 1,000 data rows and 40 columns. XLSX uses the first worksheet. Keep identifiers as text to preserve leading zeros. Extract and verify scanned or PDF data before preparing a structured file.
What happens next
If validation lists missing headers, fix the file and start a new import.
Common issues
For the hosted synthetic pilot, select Synthetic Data Imports test only and use fictional rows with Reference and Test note headers.