I'll guide you through converting between Excel and CSV formats with full control over delimiters, encoding, and formatting options.
Converting Excel to CSV:
Step 1: Select Excel to CSV
Choose "Excel → CSV" from the conversion direction options.
Step 2: Upload Excel File
Upload your Excel file (.xlsx or .xls, max 10MB). The tool will read your data for conversion.
Step 3: Configure CSV Settings
- Delimiter: Choose comma, semicolon, tab, or pipe separator
- Text Qualifier: Select quotes around text fields
- Encoding: UTF-8 (recommended) or Windows-1252
- Sheet Selection: Convert first sheet or all sheets
Step 4: Convert and Download
Click "Convert to CSV" to generate your CSV file(s).
Converting CSV to Excel:
Step 1: Select CSV to Excel
Choose "CSV → Excel" from the conversion options.
Step 2: Upload CSV File
Upload your CSV file. The tool will auto-detect the delimiter and structure.
Step 3: Configure Import Settings
- Delimiter Detection: Auto-detect or manually specify
- Text Encoding: Choose the correct encoding for your data
- Header Row: Specify if first row contains column headers
Step 4: Generate Excel File
Click "Convert to Excel" to create your formatted spreadsheet.
Best Practices:
- Use UTF-8 encoding for international characters
- Choose appropriate delimiters based on your data content
- Always preview converted files before using in production
- Keep original files as backups during conversion