PRACTICAL CSV CHECKS
Fix the source.
Not the story.
取り込み前に構造を見て、推測では直さない。
These short examples describe only the checks that are built into this local prototype. They use fictional data and do not promise that every spreadsheet or import destination will accept a checked copy.
01
INCONSISTENT ROW WIDTHS
Stop a broken CSV before it shifts your fields.
One row with too few or too many columns can move every later value into the wrong field. Inspect the delimiter and row widths before importing. If the structure is inconsistent, CSV Preflight blocks the checked copy instead of padding, deleting, or guessing at cells.
Use this when an importer reports an invalid row, a pasted note has an unexpected comma, or an export mixes formats. Fix the source, then inspect it again.
It does not promise: that a structurally valid CSV will meet every destination’s own rules.
Load the fictional broken-row example 架空例を読み込む →02
IDENTIFIERS, NOT NUMBERS
Keep 00123 as an identifier.
Account IDs, postal codes, and product codes can lose meaning if a spreadsheet or importer treats them as numbers. CSV Preflight reads cells as text and does not silently turn 00123 into 123.
Review the preview, choose only the header changes you intend, and save a separate checked copy. Test one file before importing a full dataset.
It does not promise: that every spreadsheet will preserve leading zeroes after it opens the file.
Load the fictional identifier example 架空例を読み込む →03
EXACT DUPLICATE ROWS
Remove only the duplicate rows you choose.
Duplicate rows can create duplicate records, messages, or orders. CSV Preflight shows complete duplicate rows, but keeps every row by default. If you choose removal, it keeps the first matching row and lists that selected change before export.
This is a visible preflight check. It is not a replacement for a destination system’s own duplicate rules, matching logic, or approval process.
It does not promise: to find two records with the same business meaning unless every cell value matches.
Load the fictional duplicate example 架空例を読み込む →DEMO REHEARSALS
Two local walkthroughs before any video
These are filming and review cards, not videos. Each link loads fixed fictional text only and never starts inspection automatically.
- Review before saving.Choose one header edit and one exact-duplicate removal, read the two selected changes, then save a separate checked copy.
- Hold malformed input.Show an unclosed quote, its location, and the blocked export. Do not invent a missing value or claim to repair the source.
DEMO 01 · REVIEW BEFORE SAVING
Show only the changes you selected.
Use the fixed exact-duplicate example. It has four data rows, three columns, and one exact duplicate. It does not contain a repeated header.
- LoadOpen the fixed fictional example. The text appears in the input area; inspection has not started.
- InspectRun the check and review the exact-duplicate notice.
- ChooseSelect exact-duplicate removal and, if useful for the walkthrough, change only the
quantity header. - Review & saveShow the selected changes, then save the separate checked copy after its CSV values are read back and compared.
Load the fictional duplicate example 自動検査なしで読み込む →Do not say: that it finds similar records, repairs a source file, or guarantees an import outcome.
DEMO 02 · HOLD MALFORMED INPUT
Stop when a quoted field has no safe boundary.
Use the fixed fictional example with one unclosed quote. It is deliberately malformed so the checker can show a safe hold instead of guessing.
- LoadOpen the fixed fictional malformed-quote example. The text appears in the input area; inspection has not started.
- InspectRun the check and show the source location for the unclosed quote.
- HoldShow that no checked-copy download is offered. The tool does not insert a quote or shift values into another column.
- Resolve outside the demoFix the source data deliberately, then inspect the corrected source again.
Load the fictional malformed-quote example 自動検査なしで読み込む →Do not say: that malformed CSV is automatically repaired or that this identifies every data-quality problem.
What stays out of these examples
No customer CSV, file name, header, affiliate link, advertising claim, account registration, or AI output is included. The checker handles files in the browser tab for normal checks; this portable edition makes no application API request. See the usage and limits.