What's the difference between the JS and JSON output modes?

They look almost identical, but the JS/TS mode appends a trailing semicolon (so it's a ready-to-paste statement, like `const grid = [...]` minus the assignment), while the JSON mode omits it, since a semicolon isn't valid JSON.

Why does Python mode use single quotes and JS/JSON use double quotes?

Those are each language's own idiomatic default string-quote style. Python string literals conventionally use single quotes, while JSON requires double quotes and JS/TS commonly uses them too - this tool matches each target's own convention rather than using one style everywhere.

Are numeric-looking cells output as numbers or strings?

Always as quoted strings, in every syntax mode. CSV itself has no type system, so a cell like "42" is just the text "42" - this tool doesn't guess which cells were meant to be numbers.

Does it require a rectangular (uniform column count) CSV?

The CSV is automatically padded with empty strings so every row has the same number of columns as the widest row, so the output is always a clean, uniform matrix even from a slightly ragged CSV.

CSV to Matrix Converter - Convert Online

Overview

Introduction

Pasting a CSV's data straight into a script often means manually wrapping every row in brackets and quoting every value - tedious and error-prone for anything beyond a handful of rows. This tool does that formatting for you, in your choice of target language syntax.

Pick JS/TS, Python, or plain JSON, and the whole CSV grid comes out as a ready-to-paste literal 2D array, with each language's own string-quoting conventions applied automatically.

What Is CSV to Matrix Converter?

A CSV-to-matrix converter that renders a parsed, rectangularized CSV grid as a nested array literal: `[["a", "b"], ["c", "d"]]`-style for JS/TS and JSON, or `[['a', 'b'], ['c', 'd']]`-style for Python.

Every cell stays a string in every output mode, since CSV itself carries no type information - this tool doesn't attempt to infer numbers, booleans, or dates from cell text.

How CSV to Matrix Converter Works

The CSV is parsed and padded to a rectangle using this category's shared grid parser, guaranteeing every row has the same column count even if the source CSV was slightly ragged.

Each cell is then formatted as a properly-escaped string literal in the chosen target syntax: `JSON.stringify` handles double-quote escaping for JS/TS/JSON mode, while a small dedicated function handles single-quote escaping (including backslashes and embedded newlines) for Python mode; rows are joined into an indented, multi-line array literal.

When To Use CSV to Matrix Converter

Use it when you need a small-to-medium CSV's data hard-coded directly into a script or test file, as a literal array rather than a file you load at runtime.

It's especially handy for quickly turning example/sample data into a test fixture in whichever language you're working in.

Often used alongside CSV to qCSV Converter, CSV to PDF Converter and Image to CSV Converter.

Features

Advantages

Supports three common target syntaxes (JS/TS, Python, JSON) with each one's own idiomatic quoting convention, rather than a one-size-fits-all format.
Automatically rectangularizes ragged CSVs, so every output row has a consistent column count.
Correctly escapes quotes, backslashes, and embedded newlines within cell values for whichever target language you pick.

Limitations

Every value is emitted as a quoted string in every mode - there's no automatic type inference for numbers, booleans, or dates, since CSV itself has no such type information.
Very large CSVs produce correspondingly large literals, which may not be the best approach for genuinely large datasets - a real data file (CSV/JSON) loaded at runtime scales better than a hard-coded literal.

Examples

A small CSV as a Python list literal

Input

a,b
1,2

Output

[
  ['a', 'b'],
  ['1', '2']
]

Both the header row and the data row become nested lists of single-quoted strings, ready to paste into Python code.

Best Practices & Notes

Best Practices

Use this for small sample/fixture data meant to live directly in source code - for larger datasets, keep the data in a CSV/JSON file loaded at runtime instead.
Remember every value comes out as a string in every mode; cast to numbers/booleans in your own code afterward if you need typed values.
Double check the target syntax toggle before copying - JS/TS output includes a trailing semicolon that isn't valid in the JSON mode.

Developer Notes

String formatting is intentionally split by target syntax rather than reusing one shared escaper: JS/TS/JSON both delegate to the built-in `JSON.stringify` (which already handles every JS string-escaping edge case correctly), while Python mode needs its own single-quote-oriented escaper, since JSON's escaping rules don't match Python's string-literal syntax.

CSV to Matrix Converter Use Cases

Hard-coding a small CSV's sample data directly into a script, notebook, or test file
Quickly converting a spreadsheet snippet into a nested array for a code example or Stack Overflow answer
Generating consistent test fixtures across a JS/TS codebase and a Python codebase from the same source CSV

Common Mistakes

Expecting numeric-looking cells to come out as unquoted numbers - every cell is a quoted string in every syntax mode, by design.
Copying JS/TS output (with its trailing semicolon) directly where JSON is expected - switch the syntax toggle to JSON mode instead.

Tips

If you need typed values (numbers, booleans) in your target language, cast them after pasting this tool's string-only output.
For very large CSVs, consider whether a loaded data file would serve your code better than a hard-coded literal.

CSV to Matrix Converter