What CSV delimiters are supported?
The tool supports comma (,), semicolon (;), tab, pipe (|), and custom delimiters. It can automatically detect the most common delimiter patterns in your CSV file.
How does auto-detection work?
The tool analyzes your CSV file to automatically detect the delimiter, quote characters, and data structure. You can override these settings if the auto-detection isn't perfect.
Are data types preserved during conversion?
Yes, the tool intelligently detects and preserves data types. Numbers remain as numbers, dates are formatted as Excel dates, and text is preserved as text with proper formatting.
Can I handle CSV files with quoted fields?
Yes, the tool properly handles CSV files with quoted fields, escaped quotes, and fields containing the delimiter character. Standard CSV quoting rules are fully supported.
What happens to special characters?
Special characters and Unicode text are properly preserved during conversion. The resulting Excel file maintains full UTF-8 compatibility.
Is there a limit on the number of rows or columns?
The tool can handle files up to 50MB and supports Excel's maximum limits of 1,048,576 rows and 16,384 columns. Large files are processed efficiently.