Table.FromList
Makes a table from a list, splitting each item into the row's columns.
Group: Table. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Table.FromList(list as list, optional splitter as nullable function, optional columns as any, optional default as any, optional extraValues as nullable number) as table| Parameter | Type | Description |
|---|---|---|
list | list | The items, one per row. |
splitter | nullable function optional | How an item is split into columns; a text is split at its commas when left out. Splitter.SplitByNothing() keeps each item whole, whatever it is. |
columns | any optional | The column names as a list, a number of columns, or a table type. |
default | any optional | The value for the columns an item has too few parts for. |
extraValues | nullable number optional | What to do with parts beyond the last column: ExtraValues.Error, ExtraValues.Ignore or ExtraValues.List. |
Returns
table. One row per item.
Remarks
- The parts of a split text stay texts: change the columns' types afterwards.
Examples
Texts split at commas
Table.FromList({"Chair,50", "Desk,120"}, null, {"Product", "Price"})| Product | Price |
|---|---|
| Chair | 50 |
| Desk | 120 |
A list of dates as one column
Table.FromList({#date(2026, 3, 1), #date(2026, 3, 2)}, Splitter.SplitByNothing(), {"Date"})| Date |
|---|
| 2026-03-01 |
| 2026-03-02 |
Extra parts left out
Table.FromList({"Chair,50", "Desk,120,oak"}, null, {"Product", "Price"}, null, ExtraValues.Ignore)| Product | Price |
|---|---|
| Chair | 50 |
| Desk | 120 |
Related functions
Table.FromRows, Table.FromColumns, Table.ToList, Splitter.SplitTextByDelimiter.