CSV Import Data Issues

Various issues can occur when importing CSV files, including missing records, incorrect header detection, and handling of empty rows

Symptoms

• Records are missing from the beginning or middle of the imported file

• Empty rows in CSV files causing data import issues

• System starts reading from incorrect row, skipping intended header and initial records

• Only partial data is visible for mapping (limited to first 1000 rows)

Possible Causes

• Mismatched column counts between header row and data rows

• Empty lines before the header row or between data rows

• Header detection logic selecting wrong row as header due to column count differences

• Large files with unique values appearing after the first 1000 rows

Solutions

Solution 1: Fix Header Row Alignment

1. Ensure your header row has the same number of columns as your data rows

2. Remove any unnamed or extra columns from your data rows

3. Verify that the first row contains all necessary column headers 4. Re-import the file after making these corrections

Solution 2: Clean CSV File Format

1. Remove any empty lines before the header row

2. Remove unnecessary empty rows between data rows

3. Ensure all data rows start immediately after the header row

4. Save the file and attempt the import again

When to Contact Support

If the above solutions do not resolve the issue, please contact our support team with the following information:

• Your Space ID

• A sample file demonstrating the issue

• Description of expected vs. actual results

• Any error messages received during the import process