Outils de tableau

Convertissez une liste de textes en tableaux JS, Python, PHP, Perl, SQL IN et JSON.

Convertisseur de tableaux et de listes en ligne gratuit

Transformez une liste de texte brut en la syntaxe de tableau dont votre projet a besoin. Dokall prend en charge les clauses JavaScript, Python, PHP, Perl, SQL IN et les tableaux JSON - parfait lorsque vous avez des données de colonne provenant d'une feuille de calcul et que vous avez besoin d'une sortie prête pour le code.

Collez un élément par ligne et copiez le résultat formaté. Aucun devis manuel ni emballage de support n’est requis.

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.