RFC 4180 CSV Standard Explained
CSV appears simple, but real-world data frequently contains commas inside quotes (e.g. `"Apple, Inc."`), escaped quotes, and multiline text. Naive split calls corrupt column mapping. Lucentool strictly adheres to RFC 4180 to guarantee 100% roundtrip fidelity with Excel and SQL database dumps.
Smart Type Inference
- Number parsing: Automatically converts numeric strings to native JSON numbers.
- Booleans & Nulls: Maps literal strings to native boolean values and null.