Comma Separated: How to Join, Split and Publish Values

Comma separated means that commas mark the boundaries between values. For example, Red,Blue,Green contains three values. The comma is the delimiter: the character that separates one value from the next.

Before preparing data for a public table, decide whether you need a list inside one cell or a CSV file with rows and columns. They can look similar, but they need different handling.

A comma-separated list is not a whole table

A simple list looks like this:

Red,Blue,Green

A CSV—short for comma-separated values—uses comma-separated fields to represent records. A header row can name the columns. Under the common conventions documented in RFC 4180, each record should have the same number of fields.

Here is a fictional dataset with two records and three columns:

record_id,organization,note
R001,"North, South Research",Survey complete
R002,East Research,"Reported ""provisional"" results"

A CSV reader should display:

record_id	organization	note
R001	North, South Research	Survey complete
R002	East Research	Reported “provisional” results

The comma inside North, South Research belongs to the organization name. It does not start another column. That distinction is why splitting every comma is unsafe for CSV.

Join cells into a simple list

In Google Sheets, suppose cells A2 through A4 contain Red, Blue and Green. Enter this formula in another cell:

=JOIN(",",A2:A4)

Result:

Red,Blue,Green

For a display list with spaces, use:

=JOIN(", ",A2:A4)

Result: Red, Blue, Green.

Google’s JOIN documentation confirms that the function places a specified delimiter between values in a one-dimensional array.

Use JOIN for simple lists, not as a general CSV exporter. It concatenates values; it does not provide the quoting and escaping needed when values themselves contain commas or quotation marks. To publish a table, keep your data in separate columns and use a CSV export rather than joining each row manually.

Split a simple list into cells

If A2 contains Red,Blue,Green, enter this in an empty area with room for three output columns:

=SPLIT(A2,",",FALSE,FALSE)

The result is Red, Blue and Green in separate cells across the row.

The last FALSE preserves empty positions between consecutive commas. For example, Red,,Green produces a blank middle cell rather than silently collapsing the list to two values. Google documents these options in its SPLIT reference.

For a list that consistently uses a comma followed by a space, such as Red, Blue, Green, use =SPLIT(A2,", ",FALSE,FALSE). The first FALSE treats comma-space as one delimiter rather than splitting on commas and spaces individually.

This is appropriate only when every delimiter marks a boundary between values. Do not apply it to the CSV example above: SPLIT works around delimiter characters, not CSV quoting rules.

If a field contains multiple vendor or product names, first establish how the list is encoded. Our guide to deduplicating comma-separated names covers parsing the outer CSV before splitting values within a field.

Keep commas inside values intact

The common CSV quoting rules are:

• Enclose fields containing commas, line breaks or double quotes in double quotes.
• Represent a double quote inside a quoted field with two double quotes.
• Treat spaces as data, not automatic padding.

For example, Red, Blue contains a leading space before Blue under those conventions. Avoid adding spaces after CSV delimiters merely for appearance; clean unwanted whitespace deliberately instead.

For more on file structure and export checks, see the CSV comma-delimited format guide.

Check the result before publishing

Review the exported file in a text editor, then import it into a CSV-aware reader. Confirm:

• Every record has the expected number of columns.
• Names containing commas remain in one cell.
• Quotation marks display correctly.
• Empty fields and identifiers, including any leading zeros, match the original.
• Headers explain the fields, and accompanying documentation states the source, units, date coverage and meaning of blanks.

Remove sensitive or confidential information before uploading. As of October 2026, TablePage lists CSV, TSV, XLSX and XLS uploads and generates public dataset pages with shareable links and filterable tables.

After publication, compare the displayed headers and sample records with your reviewed file—especially records containing commas, quotes or missing values. The finished page should preserve the table’s structure, not turn punctuation inside a value into extra columns.