CSV不完整记录检测
CSV不完整记录检测；输入、输出与参数范围在实施前细化。
使用步骤
如何使用
- Paste CSV data and choose the separator used by your file.
- Choose whether the first row contains column names, then select Find incomplete records.
- Review row numbers, field counts, and the affected record text before fixing the source file.
Checks real CSV fields
Quoted commas, escaped quotes, and quoted line breaks are handled as CSV fields. A record is incomplete when its field count differs from the first record’s expected width.
Useful before importing
The report shows the source row number, actual field count, expected count, and a compact preview so you can find the problem quickly in a spreadsheet or export job.
Private and bounded
Parsing runs locally in your browser. Input is limited to 100,000 characters, 10,000 records, and 500 fields per record.
常见问题
你可能还想知道
Does this upload my CSV?
No. The CSV is parsed and checked locally in your browser.
Does it understand quoted commas?
Yes. Commas, line breaks, and doubled quotes inside quoted fields are treated as part of the field.
What is the expected field count?
The first data record sets the expected width, or the header row when you enable the header option.
Can it fix incomplete records?
No. It reports the exact rows so you can correct the source data without silently changing values.