Export a list of list in a formatted csv file

[ced285]

Hello, I have searched the forums and use the "do it" to do several tests but nothing conclusive so far.

I want to export a list list in CSV (no problem at this level) but trying to put each item of a list in different columns.

The list in question is in this form (it is difficult for me to modify it upstream, I have already had enough trouble to get there ... and I would surely have to resume everything):

When exporting CSV, I end up with all the list 1 in a cell, in the second line all the list 2 in a second cell etc: 

For example

I want to arrive at this formatting with a header cell so that the user can work on the csv spreadsheet.

If you have a few minutes to give me, I'll be delighted.

Regards, Ced

[TimAI2]

Run Do It on your list to csv table table block, it should look like below

Also check the import options for your spreadsheet program for csv files - it should give you a preview (or Google Sheets will just do it)

Or check that your list of lists really is a list of lists!

Because you are working in an AI2 derivative (Kodular?) you should really be asking for help on their support forums, as the blocks and results/outputs are possibly different

[ced285]

Thank you TimAI2 for this quick response, always on top! Indeed the example comes from Kodular (there are a lot of interesting features for my project) but I have the clone of this application under AI2.

That's what I get, which differs from your example:

"Or check that your list of lists really is a list of lists!">  How ?

[TimAI2]

It looks like you are not forming your "end lists" correctly - e.g. it appears that "0001200 Equipe6 1 1" is a single list entry, not four items of a list 

[ced285]

Is there a way around this problem?

In the case where the list would be correct, what is the procedure for distributing the items in the cells (A, B, C ...) and one item is present per line in the csv file?

regards Ced

[TimAI2]

I think we need to see the blocks you use to create the list and fix it there. 

Of course it is possible, with text manipulation to convert it to a proper list, but better to do it in the first place

Right Click in Blocks Editor and select "Download Blocks as Image"

(use image editor to crop etc. if required)

In the forum, click on the image button to upload your blocks image