Answered

Export sharepoint list to CSV issue

(0) Share

Report

Posted on by Florian_P

Hey guys,

I'm trying to build a flow when I'm getting information from a Forms, copy these information to a sharepoint list (so far so good),

after that I want to export this list to a .csv file, so I get the list, create a csv table and creating a .csv file with the CSV table output but when I'm opening the .csv file everything is in the same column separated by coma.

I just want every information to be in different column as it should be but it seems like it doesn't want to do that.

Any advice on how to get everything in order ?

I'm giving you this screenshot of the flow as it could be useful

2022-01-12 16_02_58-Window.png

and what I get in the .csv file

2022-01-12 15_24_43-Window.png

Thanks in advance for any help on this !

I have the same question (0)

All responses (2)

Answers (1)

tom_riha 10,181 Most Valuable Professional on at

Like (0)

Report

Re: Export sharepoint list to CSV issue

Hello @Florian_P ,

that's a correct output for a .csv file (shortcut for comma separated values), the values are separated by a comma. If Excel doesn't convert it by itself into separate cells, you can use the 'Text to Columns' functionality in Excel to split it into columns using a comma.

Was this reply helpful? Yes No
Verified answer

Pstork1 68,330 Most Valuable Professional on at

Like (0)

Report

Re: Export sharepoint list to CSV issue

After doing the data select you may need to do a Parse JSON to re-establish the individual columns so they will show up in the CSV.

Was this reply helpful? Yes No