Convert CSV to HTML table
Description
You can convert a CSV to a HTML table.
Input Arguments
| Input Argument | Type | Description | Required? | Advanced Option? | Default |
|---|---|---|---|---|---|
CSV | CSV | The table in CSV which shall be converted to a HTML table. | ✔️ | ❌ | - |
CSV has Headers? | Boolean | Indicates if the first row in the CSV contains column headers. | ❌ | ✔️ | Yes |
Auto-detect Field Types? | Boolean | Whether to automatically detect the data types of the CSV fields. | ❌ | ✔️ | No |
Number of Rows for Field Type Detection | Number | The number of rows to analyze for determining field data types (if auto-detection is enabled). | ❌ | ✔️ | 20 |
Remove Empty Rows? | Boolean | Whether to remove rows that have no data before converting to HTML. | ❌ | ✔️ | Yes |
Skip a Number of Rows | Number | Number of rows to skip from the start of the CSV before processing. | ❌ | ✔️ | 0 |
Stop at a specific Row | Number | Row number at which to stop reading the CSV. If not set, all rows will be processed. | ❌ | ✔️ | convert all rows |
Separator | String | The character used to separate fields in the CSV. If not set, the separator is auto-detected. | ❌ | ✔️ | Auto-detect separator |
Auto-detect Quote Delimiter? | Boolean | Whether to automatically detect the quote character used to enclose fields in the CSV. | ❌ | ✔️ | Yes |
Output
| Response | Type | Description |
|---|---|---|
HTML Response | HTML | The 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
💡
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!