Share via

CSV Converter by Power2Apps (Preview)

Converts between all common tabular (CSV, Excel, HTML table) and hierarchical (JSON, XML, YAML) data formats. The main action auto-detects the input and returns all supported formats in one step. Additional actions enable targeted conversions with advanced options. Supports flexible, reliable bidirectional format conversion for automation scenarios.

This connector is available in the following products and regions:

Service Class Regions
Copilot Studio Premium All Power Automate regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure Government regions
     -   Azure China regions
     -   US Department of Defense (DoD)
Power Apps Premium All Power Apps regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Power Automate Premium All Power Automate regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Contact
Name Power2Apps Support
URL https://www.power2apps.de/en/contact
Email getintouch@power2apps.de
Connector Metadata
Publisher Power2Apps P2A GmbH
Website https://www.power2apps.de/en
Privacy policy https://www.power2apps.de/en/converterprivacypolicy
Categories Content and Files;Data

CSV Converter by Power2Apps for Power Automate convert your data easily from and to CSV.

Prerequisites

You will only need a key to use this connector and build workflows with it.

How to get credentials?

Creating a connection

The connector supports the following authentication types:
Default Parameters for creating connection. All regions Not shareable

Default

Applicable: All regions

Parameters for creating connection.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Name Type Description Required
API Key securestring Get your API Key on https://power2apps.de/apikey True

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Actions

Auto-Detect Format Converter

Convert data between multiple formats including CSV, JSON, HTML, Excel, XML, and YAML with a single powerful action - https://converter.power2apps.com
Convert CSV to Excel

Convert a CSV to a Excel file - https://converter.power2apps.com
Convert CSV to HTML Table

Convert a CSV to a HTML table - https://converter.power2apps.com
Convert CSV to JSON

Convert a CSV to a JSON - https://converter.power2apps.com
Convert CSV to Text Table

Convert a CSV to a Text Table - https://converter.power2apps.com
Convert CSV to XML

Convert a CSV to a XML - https://converter.power2apps.com
Convert CSV to YAML

Convert a CSV to a YAML - https://converter.power2apps.com
Convert Excel to CSV

Convert a Excel file to a CSV - https://converter.power2apps.com
Convert HTML Table to CSV

Convert a HTML table to a CSV - https://converter.power2apps.com
Convert JSON to CSV

Convert a JSON to a CSV - https://converter.power2apps.com
Convert XML to CSV

Convert a XML to a CSV - https://converter.power2apps.com
Convert YAML to CSV

Convert a YAML to a CSV - https://converter.power2apps.com

Auto-Detect Format Converter

Operation ID:
T01_A000_AV01_CV01_ConvertAllFormats

Convert data between multiple formats including CSV, JSON, HTML, Excel, XML, and YAML with a single powerful action - https://converter.power2apps.com

Parameters

Name Key Required Type Description
Input Data
 inputData True string

Input data to be converted
Input Format
 inputFormat string

Input Format. Default: Auto-detect.
Output Formats
 outputFormat string

Limit output formats to improve performance. E.g. 'CSV, JSON, Excel'. Blank = all

Returns

Body
DtoResponseT01_A000_AV01_CV01_ConvertAllFormats

Convert CSV to Excel

Operation ID:
T01_A003_AV01_CV01_ConvertCsvToExcel

Convert a CSV to a Excel file - https://converter.power2apps.com

Parameters

Name Key Required Type Description
CSV
 csv True string

CSV
Separator
 delimiter string

Field separator (delimiter). Default = 'Auto-detect separator'
Auto-detect Quote Delimiter?
 mayHaveQuotedFields boolean

Auto-detect quote delimiter?
CSV has Headers?
 hasHeader boolean

CSV has headers?
Auto-detect Header?
 autoDetectHeaderLine boolean

Automatically detect the header line based on content. Default = true
Header Row Index
 headerLineIndex integer

Use specific row index as header. Ignored if Auto-detect is true. Default = 0
Auto-detect Field Types?
 autoDiscoverFieldTypes boolean

Auto-detect field types?
Detection Accuracy
 detectionAccuracy string

Scans rows to detect headers and formats — more rows improve accuracy. Default = 'Fast'
Null Value
 nullValue string

Treats this value (e.g. '-', 'N/A') as null (if Auto-detect field type is true). Default = empty
Rows to skip
 skipRows string

Skip a range or specific rows e.g.: '2-5', '2', '2,4'.
Stop at Row
 skipLast integer

Stop at a specific row number. Default = convert all rows
Remove Empty Rows?
 ignoreEmptyLine boolean

Remove empty rows
Quote Character
 quoteCharacter string

Character used to quote values. Default = '"'
Escape Character
 escapeCharacter string

Character used to escape special characters. Default = ''
Auto-detect Wrapped Lines?
 autoDetectWrappedLines boolean

Try to detect and unwrap multi-line values. Default = true
Rename Columns
 columnRenames string

Use 'Old=New' pairs, separated by ';'. Example: OrderID=ID;Total=Amount
Include Columns
 columnsToInclude string

Comma-separated list of columns to include e.g.: OrderID,Total. Empty = all
Adjust Excel Column to Content
 adjustColumnToContent boolean

Adjust Excel column to content.
Wrap Excel Column Text
 wrapColumnText boolean

Wrap Excel text of column.
Max Excel Column Width
 maxColumnWidth integer

Maximum of Excel column width. Default = 15

Returns

Body
DtoResponseT01_A003_AV01_CV01_ConvertCsvToExcel

Convert CSV to HTML Table

Operation ID:
T01_A005_AV01_CV01_ConvertCsvToHtml

Convert a CSV to a HTML table - https://converter.power2apps.com

Parameters

Name Key Required Type Description
CSV
 csv True string

CSV
Separator
 delimiter string

Field separator (delimiter). Default = 'Auto-detect separator'
Auto-detect Quote Delimiter?
 mayHaveQuotedFields boolean

Auto-detect quote delimiter?
CSV has Headers?
 hasHeader boolean

CSV has headers?
Auto-detect Header?
 autoDetectHeaderLine boolean

Automatically detect the header line based on content. Default = true
Header Row Index
 headerLineIndex integer

Use specific row index as header. Ignored if Auto-detect is true. Default = 0
Auto-detect Field Types?
 autoDiscoverFieldTypes boolean

Auto-detect field types?
Detection Accuracy
 detectionAccuracy string

Scans rows to detect headers and formats — more rows improve accuracy. Default = 'Fast'
Null Value
 nullValue string

Treats this value (e.g. '-', 'N/A') as null (if Auto-detect field type is true). Default = empty
Rows to skip
 skipRows string

Skip a range or specific rows e.g.: '2-5', '2', '2,4'.
Stop at Row
 skipLast integer

Stop at a specific row number. Default = convert all rows
Remove Empty Rows?
 ignoreEmptyLine boolean

Remove empty rows
Quote Character
 quoteCharacter string

Character used to quote values. Default = '"'
Escape Character
 escapeCharacter string

Character used to escape special characters. Default = ''
Auto-detect Wrapped Lines?
 autoDetectWrappedLines boolean

Try to detect and unwrap multi-line values. Default = true
Rename Columns
 columnRenames string

Use 'Old=New' pairs, separated by ';'. Example: OrderID=ID;Total=Amount
Include Columns
 columnsToInclude string

Comma-separated list of columns to include e.g.: OrderID,Total. Empty = all

Returns

Body
DtoResponseT01_A005_AV01_CV01_ConvertCsvToHtml

Convert CSV to JSON

Operation ID:
T01_A001_AV01_CV01_ConvertCsvToJson

Convert a CSV to a JSON - https://converter.power2apps.com

Parameters

Name Key Required Type Description
CSV
 csv True string

CSV
Separator
 delimiter string

Field separator (delimiter). Default = 'Auto-detect separator'
Auto-detect Quote Delimiter?
 mayHaveQuotedFields boolean

Auto-detect quote delimiter?
CSV has Headers?
 hasHeader boolean

CSV has headers?
Auto-detect Header?
 autoDetectHeaderLine boolean

Automatically detect the header line based on content. Default = true
Header Row Index
 headerLineIndex integer

Use specific row index as header. Ignored if Auto-detect is true. Default = 0
Auto-detect Field Types?
 autoDiscoverFieldTypes boolean

Auto-detect field types?
Detection Accuracy
 detectionAccuracy string

Scans rows to detect headers and formats — more rows improve accuracy. Default = 'Fast'
Null Value
 nullValue string

Treats this value (e.g. '-', 'N/A') as null (if Auto-detect field type is true). Default = empty
Rows to skip
 skipRows string

Skip a range or specific rows e.g.: '2-5', '2', '2,4'.
Stop at Row
 skipLast integer

Stop at a specific row number. Default = convert all rows
Remove Empty Rows?
 ignoreEmptyLine boolean

Remove empty rows
Quote Character
 quoteCharacter string

Character used to quote values. Default = '"'
Escape Character
 escapeCharacter string

Character used to escape special characters. Default = ''
Auto-detect Wrapped Lines?
 autoDetectWrappedLines boolean

Try to detect and unwrap multi-line values. Default = true
Rename Columns
 columnRenames string

Use 'Old=New' pairs, separated by ';'. Example: OrderID=ID;Total=Amount
Include Columns
 columnsToInclude string

Comma-separated list of columns to include e.g.: OrderID,Total. Empty = all

Returns

Body
DtoResponseT01_A001_AV01_CV01_ConvertCsvToJson

Convert CSV to Text Table

Operation ID:
T01_A011_AV01_CV01_ConvertCsvToTextTable

Convert a CSV to a Text Table - https://converter.power2apps.com

Parameters

Name Key Required Type Description
CSV
 csv True string

CSV
Separator
 delimiter string

Field separator (delimiter). Default = 'Auto-detect separator'
Auto-detect Quote Delimiter?
 mayHaveQuotedFields boolean

Auto-detect quote delimiter?
CSV has Headers?
 hasHeader boolean

CSV has headers?
Auto-detect Header?
 autoDetectHeaderLine boolean

Automatically detect the header line based on content. Default = true
Header Row Index
 headerLineIndex integer

Use specific row index as header. Ignored if Auto-detect is true. Default = 0
Auto-detect Field Types?
 autoDiscoverFieldTypes boolean

Auto-detect field types?
Detection Accuracy
 detectionAccuracy string

Scans rows to detect headers and formats — more rows improve accuracy. Default = 'Fast'
Null Value
 nullValue string

Treats this value (e.g. '-', 'N/A') as null (if Auto-detect field type is true). Default = empty
Rows to skip
 skipRows string

Skip a range or specific rows e.g.: '2-5', '2', '2,4'.
Stop at Row
 skipLast integer

Stop at a specific row number. Default = convert all rows
Remove Empty Rows?
 ignoreEmptyLine boolean

Remove empty rows
Quote Character
 quoteCharacter string

Character used to quote values. Default = '"'
Escape Character
 escapeCharacter string

Character used to escape special characters. Default = ''
Auto-detect Wrapped Lines?
 autoDetectWrappedLines boolean

Try to detect and unwrap multi-line values. Default = true
Rename Columns
 columnRenames string

Use 'Old=New' pairs, separated by ';'. Example: OrderID=ID;Total=Amount
Include Columns
 columnsToInclude string

Comma-separated list of columns to include e.g.: OrderID,Total. Empty = all

Returns

Body
DtoResponseT01_A011_AV01_CV01_ConvertCsvToTextTable

Convert CSV to XML

Operation ID:
T01_A007_AV01_CV01_ConvertCsvToXml

Convert a CSV to a XML - https://converter.power2apps.com

Parameters

Name Key Required Type Description
CSV
 csv True string

CSV
Separator
 delimiter string

Field separator (delimiter). Default = 'Auto-detect separator'
Auto-detect Quote Delimiter?
 mayHaveQuotedFields boolean

Auto-detect quote delimiter?
CSV has Headers?
 hasHeader boolean

CSV has headers?
Auto-detect Header?
 autoDetectHeaderLine boolean

Automatically detect the header line based on content. Default = true
Header Row Index
 headerLineIndex integer

Use specific row index as header. Ignored if Auto-detect is true. Default = 0
Auto-detect Field Types?
 autoDiscoverFieldTypes boolean

Auto-detect field types?
Detection Accuracy
 detectionAccuracy string

Scans rows to detect headers and formats — more rows improve accuracy. Default = 'Fast'
Null Value
 nullValue string

Treats this value (e.g. '-', 'N/A') as null (if Auto-detect field type is true). Default = empty
Rows to skip
 skipRows string

Skip a range or specific rows e.g.: '2-5', '2', '2,4'.
Stop at Row
 skipLast integer

Stop at a specific row number. Default = convert all rows
Remove Empty Rows?
 ignoreEmptyLine boolean

Remove empty rows
Quote Character
 quoteCharacter string

Character used to quote values. Default = '"'
Escape Character
 escapeCharacter string

Character used to escape special characters. Default = ''
Auto-detect Wrapped Lines?
 autoDetectWrappedLines boolean

Try to detect and unwrap multi-line values. Default = true
Rename Columns
 columnRenames string

Use 'Old=New' pairs, separated by ';'. Example: OrderID=ID;Total=Amount
Include Columns
 columnsToInclude string

Comma-separated list of columns to include e.g.: OrderID,Total. Empty = all

Returns

Body
DtoResponseT01_A007_AV01_CV01_ConvertCsvToXml

Convert CSV to YAML

Operation ID:
T01_A009_AV01_CV01_ConvertCsvToYaml

Convert a CSV to a YAML - https://converter.power2apps.com

Parameters

Name Key Required Type Description
CSV
 csv True string

CSV
Separator
 delimiter string

Field separator (delimiter). Default = 'Auto-detect separator'
Auto-detect Quote Delimiter?
 mayHaveQuotedFields boolean

Auto-detect quote delimiter?
CSV has Headers?
 hasHeader boolean

CSV has headers?
Auto-detect Header?
 autoDetectHeaderLine boolean

Automatically detect the header line based on content. Default = true
Header Row Index
 headerLineIndex integer

Use specific row index as header. Ignored if Auto-detect is true. Default = 0
Auto-detect Field Types?
 autoDiscoverFieldTypes boolean

Auto-detect field types?
Detection Accuracy
 detectionAccuracy string

Scans rows to detect headers and formats — more rows improve accuracy. Default = 'Fast'
Null Value
 nullValue string

Treats this value (e.g. '-', 'N/A') as null (if Auto-detect field type is true). Default = empty
Rows to skip
 skipRows string

Skip a range or specific rows e.g.: '2-5', '2', '2,4'.
Stop at Row
 skipLast integer

Stop at a specific row number. Default = convert all rows
Remove Empty Rows?
 ignoreEmptyLine boolean

Remove empty rows
Quote Character
 quoteCharacter string

Character used to quote values. Default = '"'
Escape Character
 escapeCharacter string

Character used to escape special characters. Default = ''
Auto-detect Wrapped Lines?
 autoDetectWrappedLines boolean

Try to detect and unwrap multi-line values. Default = true
Rename Columns
 columnRenames string

Use 'Old=New' pairs, separated by ';'. Example: OrderID=ID;Total=Amount
Include Columns
 columnsToInclude string

Comma-separated list of columns to include e.g.: OrderID,Total. Empty = all

Returns

Body
DtoResponseT01_A009_AV01_CV01_ConvertCsvToYaml

Convert Excel to CSV

Operation ID:
T01_A004_AV01_CV01_ConvertExcelToCsv

Convert a Excel file to a CSV - https://converter.power2apps.com

Parameters

Name Key Required Type Description
Excel file
 excel True byte

Excel file

Returns

Body
DtoResponseT01_A004_AV01_CV01_ConvertExcelToCsv

Convert HTML Table to CSV

Operation ID:
T01_A006_AV01_CV01_ConvertHtmlToCsv

Convert a HTML table to a CSV - https://converter.power2apps.com

Parameters

Name Key Required Type Description
HTML table
 html True string

HTML table

Returns

Body
DtoResponseT01_A006_AV01_CV01_ConvertHtmlToCsv

Convert JSON to CSV

Operation ID:
T01_A002_AV01_CV01_ConvertJsonToCsv

Convert a JSON to a CSV - https://converter.power2apps.com

Parameters

Name Key Required Type Description
JSON
 json True string

JSON

Returns

Body
DtoResponseT01_A002_AV01_CV01_ConvertJsonToCsv

Convert XML to CSV

Operation ID:
T01_A008_AV01_CV01_ConvertXmlToCsv

Convert a XML to a CSV - https://converter.power2apps.com

Parameters

Name Key Required Type Description
XML
 xml True string

XML

Returns

Body
DtoResponseT01_A008_AV01_CV01_ConvertXmlToCsv

Convert YAML to CSV

Operation ID:
T01_A010_AV01_CV01_ConvertYamlToCsv

Convert a YAML to a CSV - https://converter.power2apps.com

Parameters

Name Key Required Type Description
YAML
 yaml True string

YAML

Returns

Body
DtoResponseT01_A010_AV01_CV01_ConvertYamlToCsv

Definitions

DtoResponseT01_A000_AV01_CV01_ConvertAllFormats

Name Path Type Description
Detected Format
 detectedFormat string

Detected Format
JSON result
 json string

JSON result
XML result
 xml string

XML result
YAML result
 yaml string

YAML result
First CSV result
 firstCsv string

First CSV result
CSV result
 csv array of string

CSV result
First HTML-Table result
 firstHtmlTable string

First HTML-table result
HTML result
 htmlTable array of string

HTML result
First Text-Table result
 firstTextTable string

First Text-table result
Text-Table result
 textTable array of string

Text-table result
Excel result
 excel byte

Excel result

DtoResponseT01_A001_AV01_CV01_ConvertCsvToJson

Name Path Type Description
JSON response
 json string

JSON response

DtoResponseT01_A002_AV01_CV01_ConvertJsonToCsv

Name Path Type Description
CSV table list
 csvs array of string

CSV table list
First CSV table
 firstCsv string

First CSV table

DtoResponseT01_A003_AV01_CV01_ConvertCsvToExcel

Name Path Type Description
Excel response
 excel byte

Excel response

DtoResponseT01_A004_AV01_CV01_ConvertExcelToCsv

Name Path Type Description
CSV table list
 csvs array of string

CSV table list
First CSV table
 firstCsv string

First CSV table

DtoResponseT01_A005_AV01_CV01_ConvertCsvToHtml

Name Path Type Description
HTML response
 html string

HTML response
HTML table list
 htmlTables array of string

HTML table list
First HTML table
 firstHtmlTable string

First HTML table

DtoResponseT01_A006_AV01_CV01_ConvertHtmlToCsv

Name Path Type Description
CSV table list
 csvs array of string

CSV table list
First CSV table
 firstCsv string

First CSV table

DtoResponseT01_A007_AV01_CV01_ConvertCsvToXml

Name Path Type Description
XML response
 xml string

XML response

DtoResponseT01_A008_AV01_CV01_ConvertXmlToCsv

Name Path Type Description
CSV table list
 csvs array of string

CSV table list
First CSV table
 firstCsv string

First CSV table

DtoResponseT01_A009_AV01_CV01_ConvertCsvToYaml

Name Path Type Description
YAML response
 yaml string

YAML response

DtoResponseT01_A010_AV01_CV01_ConvertYamlToCsv

Name Path Type Description
CSV table list
 csvs array of string

CSV table list
First CSV table
 firstCsv string

First CSV table

DtoResponseT01_A011_AV01_CV01_ConvertCsvToTextTable

Name Path Type Description
Text table list
 textTables array of string

Text table list
First Text table
 firstTextTable string

First Text table