Preparing Your CSV File
Your CSV file needs to meet a few simple requirements before uploading to Batch Screening.
File requirements
- Format: .csv (comma-separated values) only. Excel .xlsx files are not supported — export to CSV first.
- Size limit: 5 MB maximum
- Encoding: UTF-8 recommended. Files with special characters in non-UTF-8 encodings may display incorrectly.
- Headers: The first row must contain column headers. TradeLasso uses these to identify which column holds entity names.
- No empty files: The file must contain at least one data row below the header row.
Required column: Entity name
Your CSV must contain at least one column with the names of the entities you want to screen. The column can have any header — you will map it to the entity name field during the upload process. Examples of valid column headers:
Company NameVendorCustomerEntityFull Name
Optional column: Country
Including a country column improves screening accuracy by providing geographic context. The country value is used as a hint during matching but does not restrict which lists are searched. Examples:
CountryCountry of OriginJurisdiction
Country values can be full names (United States) or ISO 2-letter codes (US).
Example CSV structure
Company Name,Country,Invoice Number Acme Trading Co,Germany,INV-001 Beta Supplies Ltd,United Arab Emirates,INV-002 Sigma Industrial,Unknown,INV-003
In this example, you would map Company Name as the entity column and Country as the optional country column. The Invoice Number column will be preserved in your exported results but is not used for screening.
Row limits by plan
The maximum number of rows per batch job depends on your plan. If your file exceeds the limit, you will see an error during upload. In that case, split your file into smaller batches or upgrade your plan. See the pricing page for current row limits.
Note
Extra columns beyond entity name and country are fine — they are carried through to your exported results unchanged. This makes it easy to cross-reference screening results with your original data.
Common issues
| Issue | Cause | Fix |
|---|---|---|
| "Could not detect CSV headers" | First row is missing or empty | Ensure row 1 contains column header names |
| "File has headers but no data" | Only the header row is present | Add at least one data row below the headers |
| File exceeds 5MB limit | File is too large | Split into multiple files or remove unnecessary columns |
| Special characters garbled | Non-UTF-8 encoding | Re-save the file as UTF-8 CSV from Excel or your editor |