CSV to HTML Table

Convert CSV to HTML table

Description

You can convert a CSV to a HTML table.

Input Arguments

Input ArgumentTypeDescriptionRequired?Advanced Option?Default
CSVCSVThe table in CSV which shall be converted to a HTML table.✔️-
CSV has Headers?BooleanIndicates if the first row in the CSV contains column headers.✔️Yes
Auto-detect Field Types?BooleanWhether to automatically detect the data types of the CSV fields.✔️No
Number of Rows for Field Type Detection NumberThe number of rows to analyze for determining field data types (if auto-detection is enabled).✔️20
Remove Empty Rows? BooleanWhether to remove rows that have no data before converting to HTML.✔️Yes
Skip a Number of RowsNumberNumber of rows to skip from the start of the CSV before processing.✔️0
Stop at a specific RowNumberRow number at which to stop reading the CSV. If not set, all rows will be processed.✔️convert all rows
SeparatorStringThe character used to separate fields in the CSV. If not set, the separator is auto-detected.✔️Auto-detect separator
Auto-detect Quote Delimiter?BooleanWhether to automatically detect the quote character used to enclose fields in the CSV.✔️Yes

Output

ResponseTypeDescription
HTML ResponseHTMLThe CSV table in HTML.

Power Automate Examples

Convert CSV to HTML table

We use a CSV table as input and convert it into HTML.

A CSV with our SuperHeroSquad
squadName,homeTown,formed,secretBase,active,members_name,members_age,members_secretIdentity,members_powers
Super hero squad,Metro City,2016,Super tower,True,Molecule Man,29,Dan Jukes,Radiation resistance
Super hero squad,Metro City,2016,Super tower,True,Molecule Man,29,Dan Jukes,Turning tiny
Super hero squad,Metro City,2016,Super tower,True,Molecule Man,29,Dan Jukes,Radiation blast
Super hero squad,Metro City,2016,Super tower,True,Madame Uppercut,39,Jane Wilson,Million tonne punch
Super hero squad,Metro City,2016,Super tower,True,Madame Uppercut,39,Jane Wilson,Damage resistance
Super hero squad,Metro City,2016,Super tower,True,Madame Uppercut,39,Jane Wilson,Superhuman reflexes
Super hero squad,Metro City,2016,Super tower,True,Eternal Flame,1000000,Unknown,Immortality
Super hero squad,Metro City,2016,Super tower,True,Eternal Flame,1000000,Unknown,Heat Immunity
Super hero squad,Metro City,2016,Super tower,True,Eternal Flame,1000000,Unknown,Inferno
Super hero squad,Metro City,2016,Super tower,True,Eternal Flame,1000000,Unknown,Teleportation
Super hero squad,Metro City,2016,Super tower,True,Eternal Flame,1000000,Unknown,Interdimensional travel

Picture

💡

Looking for the response to this example? Scroll up to see the Output tab.

Known Limitations

⚠️
If you experienced other limitations please get in touch with us!