List of dictionary in CSV file

That is not correct python syntax.

Dictionaries are created like that:

my_dictionary = {"name":"John", "age":"33"}

So your List shall be like this:

[{"name": "John", "age": "33"}, {"name": "Alice", "age": "40"}]

and you should also take care of that “double”-Quotes.
Sometimes in Excel you do not get "but you get or . That is something different…

1 Like