简体中文
EnglishWhat Is ArrayCat and What Does It Do?
Updated
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:
| Transformation | What it does |
|---|---|
| Sort elements | Orders the list |
| Remove duplicate elements | Deletes repeated values |
| Remove empty elements | Drops blank rows |
| Count duplicate elements | Reports how many repeats exist |
| Remove trailing separators | Cleans up dangling commas or tabs |
| Trim whitespace | Removes leading/trailing spaces |
| Strip excess whitespace | Collapses extra spacing |
| Unify whitespace | Normalizes spacing between items |
| Convert to lower case | Lowercases every element |
| Remove diacritics | Strips accents from characters |
| Fix apostrophes | Normalizes apostrophe characters |
| Fix quotation marks | Normalizes quote characters |
| Convert to HTML entities | Escapes characters for HTML |
| Base64 encode elements | Encodes each element in Base64 |
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:
- Paste the CSV into the input area (or use Load file).
- Select Comma separated as the input format.
- Apply Remove duplicate elements, Remove empty elements, and Convert to lower case.
- Choose JavaScript array as the output format.
- 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.