Import csv

[Moniek]

Hi,

I import multiple excel files, for row header I added the function: "each Excel.Workbook([Content], true", now I want to import CSV files, does anyone knows what the "true" is in Csv.document? Thanks!

[v-easonf-msft · Accepted solution]

Hi, @Moniek 

Unlike function used to access excel data, function used to return the contents of a CSV document does not contain nullable logical (true/false) values in options.

Excel.Workbook(workbook as binary, optional useHeaders as any, optional delayTypes as nullable logical) as table

Csv.Document(source as any, optional columns as any, optional delimiter as any, optional extraValues as nullable number, optional encoding as nullable number) as table

Please refer to official document about Power Query M formula language for more detail.

Csv.Document 

Excel.Workbook 

Best Regards,
Community Support Team _ Eason