免費線上數組和列表轉換器
將純文字清單轉換為您的專案所需的陣列語法。 Dokall 支援 JavaScript、Python、PHP、Perl、SQL IN 子句和 JSON 陣列 - 當您擁有電子表格中的列資料並需要程式碼就緒輸出時，這是完美的選擇。
每行貼上一項並複製格式化結果。無需手動引用或括號括起來。
Frequently Asked Questions
What output formats are supported?
Dokall converts a line-separated list into JavaScript arrays, Python lists, PHP arrays, Perl arrays, SQL IN clauses, and JSON arrays. Each format handles quoting and escaping according to its language rules.
How does the SQL IN clause format work?
Each line becomes a quoted value inside parentheses: ('value1', 'value2', 'value3'). String values are single-quoted and internal quotes are escaped. Use this for WHERE column IN (...) queries when you have a list of IDs or names from a spreadsheet.
Are special characters escaped?
Yes. Quotes, backslashes, and other special characters in your input are escaped according to the target format. A line containing it's becomes "it's" in JavaScript and 'it\'s' in SQL.
Can I convert from an array back to lines?
This tool converts lines to arrays, not the reverse. To extract values from an existing array, use the JSON formatter to pretty-print it, then manually copy values, or use your language's join method programmatically.
One item per line - what about commas in values?
Each line is treated as one array element regardless of commas within the line. If your data uses commas as separators instead of newlines, paste into a spreadsheet first, then copy the column to get one value per line.