無料オンライン配列 & リストコンバーター
プレーンテキストリストを、プロジェクトが必要とする配列構文に変換します。DokallはJavaScript、Python、PHP、Perl、SQL IN句、JSON配列をサポートしています - スプレッドシートから列データがあり、コード対応の出力を必要とする場合に最適です。
1行に1項目を貼り付け、フォーマットされた結果をコピーします。手動での引用符付けやブラケットの追加は不要です。
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.