# Delimiter converter

Canonical page: https://datalens.flazetech.in/delimiter

Publisher: DataLens by Flazetech (https://datalens.flazetech.in/about).

Switch between commas, tabs, pipes, and custom separators. Clean up a list and get it into the format your next task needs.

## How to change a text delimiter

1. Paste the text and choose its current input separator.
2. Choose the output separator. Set trimming, duplicate removal, quotes, and sorting as needed.
3. Review the live result, then copy it or download a text file.

## Worked example

### Example input

```text
alpha|beta|gamma
```

### Example output

```text
alpha,beta,gamma
```

## Common questions

### What is a delimiter?

A delimiter is a character or sequence that separates values in text. CSV uses commas, TSV uses tabs, and other formats use pipes or semicolons. A separator tells a parser where one field ends and the next begins.

### Can I use a custom delimiter?

Yes. Choose Custom for the input or output separator and enter one or more characters. The input delimiter must not be empty.

### Will this preserve a spreadsheet table?

This tool flattens fields into a list. To preserve rows and column names when converting a table, use the CSV to JSON converter. Quoted CSV fields can contain commas, line breaks, or escaped double quotes.

### Does the converter upload my text?

No. Delimiter conversion runs locally in your browser. Copy and download also operate on the result in your current browser session.

## Related guides

- [Convert an Excel column to a comma-separated list](https://datalens.flazetech.in/guides/excel-column-to-comma-list)
- [Convert CSV to JSON without losing field values](https://datalens.flazetech.in/guides/csv-to-json-preserve-values)

## Data handling

[Processing and privacy](https://datalens.flazetech.in/privacy). Formatting and conversion run in the browser. Optional sharing and API requests can transmit supplied data. The interactive tools require JavaScript; this reference does not.