CSV to JSON [DEPRECATED]
This action is deprecated, meaning it is outdated and no longer maintained. It can still be used, but the updated version here (opens in a new tab) includes new features and bug fixes.
Description
This action converts your CSV into an JSON format.
The delimiters of the CSV input are recognized automatically.
Possible delimiters:
- Comma
, - Tab
- Space
- Semicolon
; - Pipe
|
Input Arguments
| Input Argument | Type | Description | Required? | Advanced Option? | Default |
|---|---|---|---|---|---|
CSV | String in CSV format | The CSV code or a file containing CSV | ✔️ | ✔️ | - |
Data Includes Header? | Boolean | Yes: The first line of the CSV input will be formatted as headers in the Excel table. No: Default names will be included as headers in the Excel table. | ✔️ | ✔️ | Yes |
Output
| Response | Type | Description |
|---|---|---|
JSON | String | The JSON response from the CSV formatted as a String |
Power Automate Examples
Basic CSV with Comma delimiter with headers
We use a simple CSV with four pets.
Simple CSV with semicolon delimiter
Pet; Identifier;First name;Last name
Dog;1000;Eats;A Lot
Cat;1001;Likes;To Scratch
Cat;1002;Furry;Kitty
Duck;1003;Dagobert;SwimmyWe have not changed the advanced options.
Basic CSV with Pipe | delimiter and without headers
We once again use a simple JSON with four pets.
Simple CSV with Pipe delimiter
Dog|1000|Eats|A Lot
Cat|1001|Likes|To Scratch
Cat|1002|Furry|Kitty
Duck|1003|Dagobert|SwimmyWe have directly entered the CSV into our action. We have not changed in the Advanced Options that there is no header included.
Power Apps Examples
Known Limitations
⚠️
If you experienced other limitations please get in touch with us!