arraycat.com

ArrayCat can apply 14 named transformations to list data before or during conversion to an array format. They cover four common cleanup jobs: removing unwanted rows, normalizing text, encoding values, and reordering. You can combine several transformations in one pass, which is the main reason to use the tool instead of editing the list by hand.

The full list of transformations

The ArrayCat page lists these options:

Which transformations to combine for a typical cleanup

A CSV export usually arrives with blank rows, repeated entries, inconsistent capitalization, and stray spaces. A practical sequence is:

1. Remove empty elements — clears blank rows created by trailing line breaks.
2. Trim whitespace — removes spaces that would otherwise make "apple" and "apple " count as different values.
3. Remove duplicate elements — now actually catches the duplicates, because the values match after trimming.
4. Convert to lower case — merges Apple and apple if case should not matter.
5. Sort elements — produces a stable, readable order.

Order matters. Trimming before de-duplicating is the step people most often skip, and it is the reason duplicates survive a "remove duplicates" pass.

Text normalization vs. encoding

Two groups of transformations look similar but do different things:

• Normalization (remove diacritics, fix apostrophes, fix quotation marks, unify whitespace) changes characters so values are consistent and safe to compare. Removing diacritics turns café into cafe, which is useful when matching against a system that does not store accents.
• Encoding (Base64 encode elements, convert to HTML entities) changes how values are represented, not what they mean. Base64 is for transporting or storing values where raw characters would break the target format; HTML entities are for values that will be rendered in a page.

Pick encoding only when the destination requires it. Applying Base64 to a list you intend to read or compare makes the output unusable for that purpose.

Combining transformations with a format conversion

Transformations run alongside the output format choice, so you can clean and convert in one step. The output formats offered are:

• One item per row
• Delphi array
• Go array
• JavaScript array
• Pascal array
• PHP array
• Python array
• SQL insert

For example, converting a CSV file to a JavaScript array without duplicates means selecting the JavaScript array output and enabling remove duplicate elements (plus trim whitespace first, per the sequence above). The same cleaned list can be re-run with the PHP array or SQL insert output if you need it in more than one place.

Input formats you can start from

Transformations apply to whatever you paste or load, and the accepted input layouts are:

• One item per row
• Comma separated
• Inside quotation marks
• Tab separated

A "Load file" option is available for bringing in a file directly. The page also notes a maximum row length, so very long single rows may need to be split before processing.

Practical limits to check before relying on it

• Sort order is not specified on the page. If you need a particular collation (numeric vs. alphabetical, locale-aware), verify the result rather than assuming.
• "Count duplicate elements" produces a count, not a cleaned list. Use it to inspect the data, then run remove duplicate elements for the actual output.
• Encoding transformations are one-way in practice. Keep your original list if you may need the raw values again.
• The tool is described as free on its own page. No account or pricing details are given, so treat that as the current stated status rather than a guarantee.

If your goal is simply to see what is in the list before cleaning it, run count duplicate elements first; if your goal is a paste-ready array, run the cleanup sequence and pick the target format in the same pass.

ArrayCat is a free browser-based tool that converts a list of text data into an array format for a programming language. You paste or load your data, choose an output format, optionally apply transformations, and copy the result. It fits situations where you have raw rows of values — a CSV export, a column copied from a spreadsheet, a list of IDs — and need them as a JavaScript, PHP, Python, Go, Delphi, or Pascal array, or as a SQL insert statement.

What ArrayCat converts

The tool takes string data in and produces array-format text out. According to its own description, it handles conversions such as turning a CSV file into a PHP array or a JavaScript array, and it can also produce a SQL insertion statement — which the site itself notes is "technically not an array."

Supported output formats listed on the page:

• One item per row
• Delphi array
• Go array
• JavaScript array
• Pascal array
• PHP array
• Python array
• SQL insert

Accepted input formats

You can supply data in any of these shapes:

• One item per row
• Comma separated
• Inside quotation marks
• Tab separated

There is also a Load file option, so you can pull in a CSV or similar text file directly rather than pasting. The page states a maximum row length, so very long single lines may need to be split before conversion.

Transformations beyond conversion

ArrayCat is not only a format converter. It also applies text transformations to the elements, which is useful when your source data is messy. The listed transformations include:

A practical example

Suppose you export a customer list from a spreadsheet as CSV and it contains duplicate emails, stray blank rows, and inconsistent capitalization. You would:

1. Paste the CSV into the input area (or use Load file).
2. Select Comma separated as the input format.
3. Apply Remove duplicate elements, Remove empty elements, and Convert to lower case.
4. Choose JavaScript array as the output format.
5. Copy the result to your clipboard.

The output is a ready-to-paste array literal with duplicates and blanks already gone — the same workflow the site describes for converting a CSV file to a JavaScript array without duplicate elements.

When to use it

ArrayCat is a good fit when:

• You need a one-off conversion and don't want to write a script.
• Your data is small enough to paste or load as a file.
• You want to combine conversion with light cleaning (dedupe, trim, sort, encode).

It is less suited to large datasets, repeatable pipelines, or cases where you need validation of the data's meaning — it transforms text, it does not check whether your values are correct. The page describes it as a free tool; no pricing, account, or payment details are stated, so treat availability and any limits as things to confirm on the site itself.

ArrayCat accepts a list of data as text and converts it into one of several array formats. You can paste text directly or load a file, choose an input format that matches how your data is separated, pick an output format, and optionally apply transformations such as sorting or removing duplicates. It fits cases where you have a flat list of items — one value per line, or values separated by commas or tabs — and need it as a JavaScript, PHP, Python, Go, Delphi, or Pascal array, or as a SQL insert statement.

Input formats

ArrayCat's input data format options are:

• One item per row — each line is a separate element.
• Comma separated — values split on commas.
• Inside quotation marks — values wrapped in quotes.
• Tab separated — values split on tabs.

You can either paste your data into the input area or use the Load file option to bring in a file such as a CSV. The page notes a maximum row length, so very long single rows may need to be split before conversion.

Output formats

After conversion, you can produce:

• Delphi array
• Go array
• JavaScript array
• Pascal array
• PHP array
• Python array
• SQL insert — the site notes this is "technically not an array, but cats get confused sometimes."

The result can be copied to your clipboard.

Transformations you can apply

ArrayCat also supports transformations on the list before or during conversion:

• Sort elements
• Remove duplicate elements
• Count duplicate elements
• Remove empty elements
• Remove trailing separators
• Convert to lower case
• Base64 encode elements
• Convert to HTML entities
• Remove diacritics
• Fix apostrophes
• Fix quotation marks
• Strip excess whitespace
• Unify whitespace
• Trim whitespace

How to choose

If your goal is a clean list without repeated entries, apply Remove duplicate elements and Sort elements before copying the output. If you're moving data into a database, the SQL insert output is the relevant choice even though it isn't a literal array.

The site describes ArrayCat as a free tool for converting a list of data or any string into an array.

ArrayCat converts a list of data or any string into an array, and it can strip duplicate elements during the same pass. To turn a CSV file into a duplicate-free JavaScript array, load or paste your CSV, set the input format to comma separated, choose JavaScript array as the output format, enable Remove duplicate elements, then generate and copy the result. This works when your data is a flat list — one record per row — rather than nested or multi-column records that need to stay grouped.

What ArrayCat accepts as input

ArrayCat reads your data as a list, so the input format you pick tells it how to split rows into individual items. The supported input formats are:

• One item per row
• Comma separated
• Inside quotation marks
• One item per row, tab separated

For a CSV file, comma separated is the format you want. You can either paste the data directly or use the Load file option to bring in a CSV from your machine.

The page notes a Maximum row length, so extremely long single rows may be truncated — keep individual records reasonably short if you notice missing data.

Step-by-step: CSV to a deduplicated JavaScript array

1. Load or paste your CSV. Use Load file to select the CSV, or paste the comma-separated text into the input area.
2. Set the input format to "Comma separated." This tells ArrayCat to treat each comma-delimited value as one item.
3. Set the output format to "JavaScript array." ArrayCat also supports Delphi, Go, Pascal, PHP, Python arrays and SQL insert output, so make sure JavaScript is selected.
4. Enable the "Remove duplicate elements" transform. This is the step that eliminates repeated values.
5. Generate the output. ArrayCat applies the selected transforms and produces the array.
6. Copy the result using the Copy to clipboard button.

The expected result is a JavaScript array literal containing each unique value from your CSV exactly once.

Useful transforms to combine with deduplication

Deduplication rarely happens in isolation — CSV exports often carry messy whitespace or inconsistent casing that makes "duplicates" look different. ArrayCat's transform list includes options that pair well with removing duplicates:

If your CSV has a trailing comma on each line, Remove trailing separators plus Remove empty elements prevents phantom blank entries from surviving into the array.

Common snags

• Duplicates survive because of whitespace or case. Enable Trim whitespace and Convert to lower case before deduplication so near-identical values collapse correctly.
• Blank entries appear in the array. CSV files often end with a newline or trailing comma; turn on Remove empty elements and Remove trailing separators.
• Wrong output language. If you get a PHP or Python array instead of JavaScript, recheck the output format selection.
• Quoted fields with commas inside. If your CSV wraps values in quotes, try the Inside quotation marks input format so embedded commas don't split a single value into two.

ArrayCat is described as a free tool, and it handles the conversion entirely through the format and transform options above — no scripting required.

Yes. ArrayCat is described on its own page as "a free tool for converting a list of data or any string into an array." There is no mention of paid plans, subscriptions, accounts, or sign-in requirements anywhere in the site's content. The only stated constraint is a maximum row length, and the page notes that processing happens in the browser rather than on a server.

What "free" means here

The page's own wording is the strongest evidence: ArrayCat is labeled a free tool, and the site lists no pricing page, no payment platform, and no upgrade path. That means you can use the converter without a paid tier being advertised.

Two things the page does not say, so don't assume them:

• It does not state that the tool is open source or that there is a public API.
• It does not describe any usage quota, daily conversion cap, or rate limit.

If you need a guarantee about commercial use, redistribution, or an API, the page doesn't provide one — treat those as unconfirmed rather than implied.

The one documented limit: maximum row length

The page lists "Maximum row length" as a setting/constraint, which tells you the tool is built around row-based input rather than arbitrarily large blobs. In practice this matters when you paste a long single-line string (for example, a minified JSON blob or a very long CSV field) instead of a clean list.

What to do if you hit it:

1. Split the oversized row into several shorter rows before converting.
2. Convert in batches, then concatenate the resulting arrays.
3. If the long row is a single logical value, check whether it actually needs to be an array element at all.

No account, no upload

The page states that processing is done in the browser, so your data isn't sent to a server. Combined with the absence of any login or account requirement, this means:

• No sign-up step before converting.
• No server-side storage of your pasted list.
• You can use it offline-ish in the sense that the conversion logic runs client-side, though you still need the page loaded.

For anyone converting data that contains names, emails, or internal identifiers, this is the relevant practical detail — not the price.

What you get for free

The free tool covers the full feature set described on the page, not a stripped-down version. Supported input formats:

• One item per row
• Comma separated
• Inside quotation marks
• Tab separated
• File loading

Supported output formats:

• One item per row
• Delphi array
• Go array
• JavaScript array
• Pascal array
• PHP array
• Python array
• SQL insert

Supported transformations:

• Base64 encode elements
• Count duplicate elements
• Convert to HTML entities
• Convert to lower case
• Fix apostrophes
• Fix quotation marks
• Remove diacritics
• Remove duplicate elements
• Remove empty elements
• Remove trailing separators
• Sort elements
• Strip excess whitespace
• Unify whitespace
• Trim whitespace

Quick check before you rely on it

If your decision depends on a specific guarantee, verify it on the page itself rather than assuming:

For typical one-off conversions — turning a CSV column into a JavaScript array, deduplicating a pasted list, or generating a SQL insert — the free tool with its row-length limit is enough. If you need programmatic access or contractual guarantees, the page doesn't offer them, so plan around that.