Split One Address Column into Separate Address Fields

The clean case: street, city, state, ZIP separated by commas. Set delimiter = comma, prefix = Addr. The single source column becomes four columns.

Input:
Name,Address
Jane Smith,"123 Main St, Springfield, IL, 62704"

Config: column = Address, delimiter = ",", prefix = Addr

Output:
Name,Addr_1,Addr_2,Addr_3,Addr_4
Jane Smith,123 Main St,Springfield,IL,62704

One address has an apartment line, another doesn't. The file width is the widest (5), and the shorter address gets an empty cell so columns stay aligned.

Input:
Address
"45 Oak Ave, Apt 2, Portland, OR, 97201"
"99 Pine Rd, Austin, TX, 78701"

Config: delimiter = ",", prefix = Addr

Output:
Addr_1,Addr_2,Addr_3,Addr_4,Addr_5
45 Oak Ave,Apt 2,Portland,OR,97201
99 Pine Rd,Austin,TX,78701,

(The second row's missing apartment leaves columns shifted — see edge cases.)

Addresses typed as Street, City have a space after each comma. Because every part is trimmed, you don't get City with a leading space.

Input:
Address
"12 Elm St,  Denver,  CO,  80202"

Config: delimiter = ","

Output (each part trimmed):
Address_1,Address_2,Address_3,Address_4
12 Elm St,Denver,CO,80202

If a street name contains commas, a comma split misfires. When the source uses a pipe between fields (Street | City | State | ZIP), split on the pipe instead so internal commas are safe.

Input:
Address
"Plaza 5, Suite 100 | Reno | NV | 89501"

Config: delimiter = "|", prefix = Addr

Output (commas inside the street survive):
Addr_1,Addr_2,Addr_3,Addr_4
"Plaza 5, Suite 100",Reno,NV,89501

Shipping platforms want named fields. Split, then rename headers to the labels the platform expects.

After split:
Addr_1,Addr_2,Addr_3,Addr_4
123 Main St,Springfield,IL,62704

Then csv-header-rename:
  Addr_1 -> Street
  Addr_2 -> City
  Addr_3 -> State
  Addr_4 -> ZIP

Final:
Street,City,State,ZIP
123 Main St,Springfield,IL,62704

If some rows have an apartment line and others don't, City/State/ZIP land in different columns per row. The tool splits positionally — it can't know Apt 2 is an extra field. Normalise the source so every address has the same comma count, or split the with-apartment rows separately. The padding only fixes width, not semantic alignment.

Plaza 5, Suite 100, Reno, NV, 89501 splits the street into two parts. A literal comma split can't tell a street comma from a field comma. Use a different delimiter in the source (pipe/semicolon) and split on that, or fix those rows manually.

US addresses often write Springfield, IL 62704 (space, not comma, between state and ZIP). Splitting on comma leaves IL 62704 as one part. Split again on the result column with the delimiter set to a space, or fix the source format first.

Clicking Split with no column chosen throws Select a column to split. Pick the address column's radio button. The button is disabled until a column and a non-empty delimiter are set.

The delimiter field can't be blank — it throws Delimiter cannot be empty. Enter the exact separator your addresses use (comma, pipe, or semicolon).

A blank address is treated as one empty part and padded to the file width. The row is kept. To drop rows with no address, clean them out with csv-cleaner first.

If Max parts per row is lower than an address's part count, the trailing parts (often the ZIP or country) are discarded, not merged. Leave the cap at the default 100 unless you deliberately want to truncate, and check Max parts seen after running.

Addresses ending in a country (..., London, SW1A 1AA, UK) add one more part, widening the whole grid. Domestic rows then get a trailing empty cell. That is expected; reorder or drop the country column afterwards with csv-column-reorder.

Free tier caps at 500 rows / 2 MB. Larger order exports need Pro (100,000 rows / 100 MB), or split into chunks first with csv-row-splitter.