CSV to Python List

Convert CSV rows into a Python list of dictionaries

CSV is a simple format used by spreadsheets, exports and reporting tools. The first row normally contains column names, while every later row contains values. This converter turns each row into a dictionary and returns a Python list that is easy to use in a script or notebook.

Prepare your file

• Use one header row with unique column names.
• Keep the same number of values on each row.
• Use commas or semicolons consistently.
• Save text as UTF-8 to preserve accents and special characters.

Example output

A table with the columns name,age and a row Ana,28 becomes [{'name': 'Ana', 'age': 28}]. Numeric values, true, false and null are recognized where possible.

Important limitation

For CSV files with quoted commas, embedded line breaks or complex spreadsheet exports, use Python's csv module or a library such as pandas in your application. Avoid uploading confidential exports; files are read locally in the browser.

For a more detailed walkthrough, read our CSV to Python guide.