Detect Numeric and Text Items in a List

Trying to figure out which items in a list are numbers and which are plain text? Detect Numeric and Text Items in a List makes it fast, easy, and reliable. This free online tool helps you sort through mixed data by identifying lines as numeric, alphabetic, or alphanumeric. Just paste your list and get a clean, structured breakdown instantly.

It’s built for speed and clarity. No loading, no waiting. And since everything happens in your browser, your data stays private.

Whether you’re prepping a spreadsheet, checking form input, or importing a messy list of values, this tool gives you a clean way to separate text from numbers and even flag mixed items like “abc123” if you want to.

Paste your list of numbers and text.
Items Detected: 0
Options
Trim before check
Include Mixed
Ignore Decimal

How to Use:

  1. Paste your content into the input box.
    You’ll see a live preview on the right showing the output.
  2. Adjust options in the “Options” box to control how the list is parsed:
    • Trim before check: Removes extra spaces from each line before checking its type.
    • Include Mixed: Adds a third category for values that combine letters and numbers.
    • Ignore Decimal: Tells the tool to treat decimal numbers as plain text if you’re only interested in integers.
  3. Select an output mode:
    • Tag Each Line: Labels every line with [Number], [Text], or [Mixed].
    • Separate Sections: Groups all numbers together, all text together, etc.
    • CSV Output: Outputs as Type,Value for use in spreadsheets or databases.
  4. Copy or export the result using the buttons below the output box.

As you tweak settings, the output updates automatically so you can experiment and see what works best.

What Detect Numeric and Text Items in a List can do:

There are tons of situations where you might need to clean up a list of values. You might be importing data into Excel and want to break it into columns. Maybe you’re building a database and need to validate entries before pushing them into production. Or you’re just trying to clean up user submissions to sort out which ones are usable.

This tool makes that painless.

Let’s say you paste in the following lines:

Input:

42
apple
3.14
Banana
123abc
hello123

   999
one hundred

Output (in Tag mode with all toggles on):

[Number] 42
[Text] apple
[Number] 3.14
[Text] Banana
[Mixed] 123abc
[Mixed] hello123
[Number] 999
[Text] one hundred

And that’s just one configuration. Try switching to CSV Output to get:

Number,42
Text,apple
Number,3.14
Text,Banana
Mixed,123abc
Mixed,hello123
Number,999
Text,one hundred

With the live preview and instant detection, you can experiment quickly and adjust settings without losing your place.

Detect Numeric and Text Items in a List Table:

This table shows how the tool behaves with different inputs and settings so you can preview expected results and optimize your workflow.

Original InputOutput (Tag Mode)
42[Number] 42
apple[Text] apple
3.14[Number] 3.14
Banana[Text] Banana
123abc[Mixed] 123abc
hello123[Mixed] hello123
999[Number] 999
one hundred[Text] one hundred

Common Use Cases:

Detect Numeric and Text Items in a List is great for scrubbing pasted data, filtering inputs for math-only operations, prepping CSV content, and flagging mixed-type fields that might break an import or analysis. If you’ve got any kind of raw text list, this tool helps you figure out what’s in there fast.

Related Tools