Text to JSON Converter

Convert delimited text to JSON with your own column mapping and types.

Tab data copied from Excel, semicolon or pipe lists become an array of objects. The number, boolean and date types are strict: 08320 stays text, 12,50 becomes 12.5, 23.02.2025 becomes 2025-02-23 (ISO 8601, the format Power Automate and ParseJSON read directly). Anything that cannot be converted stays text and is marked. Two more modes: "key: value" for a single object and "single column as string array", which matches split() from tip 141.

Open Text to JSON

Free. You enter your email address once, then all tools are unlocked. Your data is processed locally in your browser.

How it works

Paste the text, pick output mode and delimiter.
Parse it and check column names and types.
Convert to JSON and copy.

Example: semicolon list with header

// Input
ID;Title;Quantity;Date
1001;Facade contract;12,5;23.02.2025

// Output
[
  { "ID": 1001, "Title": "Facade contract", "Quantity": 12.5, "Date": "2025-02-23" }
]

Example: key: value

// Input
Name: Contoso
Active: true

// Output
{
  "Name": "Contoso",
  "Active": true
}

Frequently asked questions

Is the tool free?

Yes.

Is my data uploaded?

No, the conversion happens locally in your browser.

How does the tool detect numbers?

Only digits without a leading zero, with a dot or comma as decimal separator. 08320, 0x1A or 1e3 stay text.

What happens to a date?

dd.MM.yyyy and d.M.yyyy become yyyy-MM-dd. ISO values stay, anything else stays text and is marked.

Which values count as boolean?

true/false, ja/nein, yes/no and 1/0. Other values stay text.

How do I get a plain array like split()?

With the mode "Single column as string array". The tool also shows the expression from tip 141.

Related tips

#PowerPlatformTip 141: Text to Array

All tips in the archive