How to Remove Quotes from a CSV File Online

Q: How do I remove quotes from a CSV file online?

Paste the CSV text into the CSV Splitter/Joiner , turn on Strip Quotes, and split. Every value has its wrapping single or double quotes removed as it's split out to its own line.

Q: What's the difference between removing quotes and it breaking my data?

If a quoted value contains the delimiter itself (like "Smith, John" ), stripping the quotes without also handling the embedded comma would incorrectly split that one value into two fields. The tool's quote stripping accounts for this - it only strips the wrapping quotes once the value has already been correctly separated, not before.

A CSV export where every value is wrapped in quotes - "apple","banana","cherry" - is common from database exports and some spreadsheet tools, and it needs to go before the data is usable as a plain list. A single Find & Replace on the quote character works until a value legitimately needs its quotes to protect a comma inside it.

Quick answer

Paste the quoted CSV into the CSV Splitter/Joiner, turn on Strip Quotes, and split it into one value per line. The wrapping quotes are removed from each value correctly, without breaking values that used the quotes to protect an embedded comma - since splitting happens before quote stripping, not after.

Remove your CSV's quotes now. Free, no account needed.

Open CSV Splitter/Joiner →

How to do it

Paste your quoted CSV into the Splitter. A single row or many lines both work.
Turn on Strip Quotes.
Copy the split result. One clean, unquoted value per line.

A row like this:

"apple","banana","cherry"

becomes:

apple
banana
cherry

Why quotes are there in the first place

A CSV value gets wrapped in quotes when it contains the delimiter itself - a comma inside a name like "Smith, John" - or a line break or quote character within the field. Without the wrapping quotes, that embedded comma would be misread as marking a new field, splitting one value into two by mistake. Some export tools quote every single field regardless of whether it strictly needs it, which is why you sometimes see quotes on values with no comma in them at all.

Why a naive Find & Replace can break things

Simply replacing every quote character with nothing works fine for CSVs where no value contains the delimiter - but if a value does (that "Smith, John" example), removing the quotes first and then splitting on commas would incorrectly break it into Smith and John as two separate values. The correct order is to split the row into fields first, respecting quoted commas as part of the value, and only then strip the now-unnecessary wrapping quotes off each already-correctly-split value. That's the order the CSV Splitter/Joiner tool follows.

Adding quotes back later

If you need the values quoted again afterward - for a SQL query, a JSON array, or rejoining into a CSV row - use Join mode in the same tool, or the List to Format Converter if you need a specific target format. Stripping and re-adding quotes are two separate, composable steps rather than one irreversible operation.

Splitting a whole CSV row, not just removing quotes?

See the full guide to splitting a CSV row into lines and joining it back.

Read the full guide →

Frequently Asked Questions

How do I remove quotes from a CSV file online?

Paste the CSV text into the CSV Splitter/Joiner, turn on Strip Quotes, and split. Every value has its wrapping single or double quotes removed as it's split out to its own line.

Why do CSV values have quotes around them in the first place?

Quotes wrap a value when the value itself contains the delimiter (a comma inside a field), a line break, or a quote character - without the wrapping quotes, a comma inside the data would be misread as a new field boundary. Some export tools quote every field regardless, whether it needs it or not.

What's the difference between removing quotes and it breaking my data?

If a quoted value contains the delimiter itself (like "Smith, John"), stripping the quotes without also handling the embedded comma would incorrectly split that one value into two fields. The tool's quote stripping accounts for this - it only strips the wrapping quotes once the value has already been correctly separated, not before.

Can I remove quotes from a single row, not a whole file?

Yes. Splitting works the same whether you paste one quoted row or many lines of quoted rows - each value gets unquoted the same way regardless of how much text you paste at once.

What if I need to add quotes back later, like for a SQL query?

Use the Join mode in the same tool, or the List to Format Converter's SQL IN clause format - both wrap each value in quotes again, so you can strip quotes to clean the data and re-add them in whatever format you need next.

What's the Excel/PowerShell way of doing this, and why use a browser tool instead?

In Excel, a full-worksheet Find & Replace searching for a quote character and replacing with nothing removes them, though this can misfire on values that need the quotes to protect an embedded comma. PowerShell scripts using Foreach-Object with a replace operator handle it at the file level for larger batch jobs. Both require opening a tool built for scripting or spreadsheets; pasting into a browser tool is faster for a one-off CSV someone handed you.

Does this handle both single and double quotes?

Yes, both are recognised and stripped the same way - useful since not every export uses double quotes as the wrapping character.

Can I remove quotes and change the delimiter at the same time, like comma to semicolon?

Yes. Set both the new delimiter and Strip Quotes before splitting, then rejoin with your target delimiter in Join mode - quote stripping and delimiter conversion happen in the same workflow rather than needing two separate passes.