1
Pick a representative sample
Start with the row count or edge case relevant to your import. Review the card’s filename, bytes, and data-row count, then expand the preview. Choose escaping, semicolon, BOM, or no header deliberately, because a successful import with the simplest comma-separated file does not prove those other cases work.
2
Import with explicit settings
Download the file and select its encoding, delimiter, and header handling in the destination application. Treat identifier and postal-code columns as text when leading zeros matter. Confirm that dates and numbers were not silently reformatted by regional spreadsheet settings. Keep the original download unchanged so you can distinguish import behavior from an edited fixture.
3
Check fields before increasing rows
Compare the imported data-row total, column count, and representative cell values with the fixture. For the escaping example, verify the comma and newline remain inside their intended field. Only after those checks should you generate 10,000 or 100,000 rows to test progress indicators, timeouts, upload limits, and recovery from an interrupted operation.