Skip to content

Numbers to an array

Turn a column of numbers into a numeric array — no quotes around the values.

  1. 1.Text to array converter

Paste a column of numbers and get an array of actual numbers rather than strings. Anything that reads as a plain number — 42, -7, 3.14 — is written without quotes, so the array is ready for arithmetic, a chart library or a sum, with no parseFloat pass afterwards.

Values that are not numeric still come out as quoted strings, which makes a stray label or a thousands separator easy to spot in the output. The tally under the result shows how many values went in and how many came out.

Questions

What happens to a value that is not a number?
It stays a quoted string. That way a stray heading or a value with a comma separator is visible in the output instead of silently corrupting the array.
Are decimals and negative numbers handled?
Yes. Both are recognised as numbers and written unquoted. Exponent notation such as 1e3, and zero-padded values such as 007, stay quoted — the padding on an ID is meaningful and dropping it would change the value.

Build your own chain in the pipeline builder.