json2csv is a Visual Studio Code extension that allows you to easily convert between JSON and CSV formats, directly within the editor. It is designed to simplify data manipulation and format conversion for developers and data analysts, with support for lossless conversion of big integer numbers.
- Convert JSON to CSV: Transform JSON files into CSV format with customizable options.
- Convert CSV to JSON: Easily convert CSV files back into JSON format.
- Customizable Options: Configure delimiters, headers, and other formatting options for the output.
- Lossless Conversion for Big Integer Numbers: Ensures large integers are accurately converted without losing precision during format conversion.
- Supports Complex JSON Structures: Handles nested objects and arrays, with options to expand array objects.
- Open Visual Studio Code.
- Go to the Extensions panel (or press
Ctrl+Shift+X
). - Search for
json2csv
. - Click Install.
Alternatively, install directly from the Visual Studio Marketplace.
- Open a JSON file.
- Press
Ctrl+Shift+P
(orCmd+Shift+P
on macOS) to open the Command Palette. - Type
Convert JSON to CSV
and select the command. - The converted CSV will be displayed in a new editor tab.
- Open a CSV file.
- Press
Ctrl+Shift+P
(orCmd+Shift+P
on macOS) to open the Command Palette. - Type
Convert CSV to JSON
and select the command. - The converted JSON will be displayed in a new editor tab.
You can customize the behavior of json2csv
through the following configuration options:
json2csv.toCSV.arrayIndexesAsKeys
(default:false
): Should array indexes be included in the generated keys? Note: This provides a more accurate representation of the JSON in the returned CSV, but may be less human readable. See #207 for more details.json2csv.toCSV.checkSchemaDifferences
(default:false
): Should all documents have the same schema? Note: An error will be thrown if some documents have differing schemas when this is set totrue
.json2csv.toCSV.delimiter.field
(default:,
): Field delimiter for CSV.json2csv.toCSV.delimiter.wrap
(default:"
): Wrap values in the delimiter of choice.json2csv.toCSV.delimiter.eol
(default:\n
): End of line delimiter.json2csv.toCSV.emptyFieldValue
(default: none): Value that, if specified, will be substituted in for field values that areundefined
,null
, or an empty string.json2csv.toCSV.excelBOM
(default:false
): Should a unicode character be prepended to allow Excel to open a UTF-8 encoded file with non-ASCII characters present.json2csv.toCSV.expandNestedObjects
(default:true
): Should nested objects be deep-converted to CSV? Note: Set this tofalse
may result in CSV output that does not map back exactly to the original JSONjson2csv.toCSV.expandArrayObjects
(default:false
): Should objects in array values be deep-converted to CSV? Note: This may result in CSV output that does not map back exactly to the original JSON. See #102 for more information.json2csv.toCSV.prependHeader
(default:true
): Should the auto-generated header be prepended as the first line in the CSV?json2csv.toCSV.sortHeader
(default:false
): Should the header keys be sorted in alphabetical order?json2csv.toCSV.trimFieldValues
(default:false
): Should the field values be trimmed?json2csv.toCSV.trimHeaderFields
(default:false
): Should the header fields be trimmed?json2csv.toCSV.useDateIso8601Format
(default:false
): Should date values be converted to an ISO8601 date string? Note: If selected, values will be converted usingtoISOString()
rather thantoString()
ortoLocaleString()
depending on the other options provided.json2csv.toCSV.useLocaleFormat
(default:false
): Should boolean values be wrapped in wrap delimiters to prevent Excel from converting them to Excel's TRUE/FALSE Boolean values.json2csv.toCSV.preventCsvInjection
(default:false
): Should CSV injection be prevented by left trimming these characters: Equals (=), Plus (+), Minus (-), At (@), Tab (0x09), Carriage return (0x0D).
json2csv.toJSON.delimiter.field
(default:,
): Field delimiter for CSV.json2csv.toJSON.delimiter.wrap
(default:"
): Wrap values in the delimiter of choice.json2csv.toJSON.delimiter.eol
(default:\n
): End of line delimiter.json2csv.toJSON.excelBOM
(default:false
): Should a unicode character be prepended to allow Excel to open a UTF-8 encoded file with non-ASCII characters present.json2csv.toJSON.trimHeaderFields
(default:false
): Should the header fields be trimmed?json2csv.toJSON.trimFieldValues
(default:false
): Should the field values be trimmed?json2csv.toJSON.parseStringLiteralNull
(default:false
): Should the string literal"null"
be parsed as anull
value? Note: case-insensitive comparison is used.
JavaScript and JSON have limitations when handling big integers due to the Number
type’s precision. json2csv handles this by ensuring lossless conversion of large integers, preserving their precision across both JSON and CSV formats. For safety, large integers are quoted during the conversion process to ensure they are not misinterpreted or rounded.
For example, a large integer such as:
bigNumber
900719925474099123
will be converted to:
[
{
"bigNumber": "900719925474099123"
}
]
and accurately preserved when converting between formats.
Input JSON:
[
{
"id": 1,
"name": "John Doe",
"email": "john@example.com"
},
{
"id": 2,
"name": "Jane Doe",
"email": "jane@example.com"
}
]
Output CSV:
id,name,email
1,John Doe,john@example.com
2,Jane Doe,jane@example.com
Input CSV:
id,name,email
1,John Doe,john@example.com
2,Jane Doe,jane@example.com
Output JSON:
[
{
"id": 1,
"name": "John Doe",
"email": "john@example.com"
},
{
"id": 2,
"name": "Jane Doe",
"email": "jane@example.com"
}
]
This extension makes use of the following libraries:
- lossless-json by Jos de Jong: Used for ensuring lossless conversion of big integer numbers in JSON format, preserving precision by quoting large numbers.
- json-2-csv by Manuel Rodriguez: A fast and flexible library for converting between JSON and CSV formats, used for core format conversion functionalities in this extension.
Feel free to contribute! Here’s how you can help:
- Fork the repository.
- Create your feature branch (
git checkout -b feature/my-feature
). - Commit your changes (
git commit -am 'Add a new feature'
). - Push to the branch (
git push origin feature/my-feature
). - Open a pull request.
This project is licensed under the MIT License.