Data
CSV Delimiters: Comma, Semicolon, and Tab to JSON
CSV does not always mean comma-separated. Spreadsheet tools can export comma, semicolon, or tab-delimited data depending on region, settings, and file type.
Use the free CSV to JSON ConverterLook for the visible separator
If each row appears as one giant column after conversion, the delimiter is probably wrong. Try comma, semicolon, or tab until the columns split correctly.
Use tab for copied spreadsheets
Rows copied directly from spreadsheet apps are often tab-separated, even if the file is called CSV in casual conversation.
Keep quoted cells intact
A good converter should keep commas inside quoted cells instead of treating them as column breaks.
FAQ
Why does my CSV not split into columns?
The selected delimiter may not match the data.
Are semicolon CSV files valid?
Yes. Semicolon-delimited files are common in some regions and spreadsheet exports.
What delimiter should I use for copied spreadsheet rows?
Tab is often the best choice for copied spreadsheet cells.