TradeLasso

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 Name
  • Vendor
  • Customer
  • Entity
  • Full 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:

  • Country
  • Country of Origin
  • Jurisdiction

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

IssueCauseFix
"Could not detect CSV headers"First row is missing or emptyEnsure row 1 contains column header names
"File has headers but no data"Only the header row is presentAdd at least one data row below the headers
File exceeds 5MB limitFile is too largeSplit into multiple files or remove unnecessary columns
Special characters garbledNon-UTF-8 encodingRe-save the file as UTF-8 CSV from Excel or your editor