Trình chuyển đổi JSON sang CSV

Cách sử dụng công cụ này

1. 1

   Paste or type a JSON array of objects into the text box. The array must be non-empty (for example: [{"name":"A","value":1}]).

2. 2

   Click the Convert button to generate the CSV.

3. 3

   Read the CSV in the output panel below the button, with the header row first followed by one row per object.

4. 4

   Select the output text and copy it into a spreadsheet, a .csv file, or wherever you need it.

Trình chuyển đổi JSON sang CSV là gì?

Các trường hợp sử dụng phổ biến

• Turning a small JSON response from an API into a CSV you can paste straight into Excel or Google Sheets.

• Quickly eyeballing tabular API data as rows and columns instead of nested braces.

• Preparing a CSV for a bulk-import feature that expects flat columns, when your source data is already a uniform JSON array.

• Converting a JSON fixture or seed file into CSV for a quick import into a database GUI.

• Generating a CSV snippet for documentation or a bug report without installing jq or writing a script.

• Sanity-checking that a JSON array has consistent keys across records by spotting blank or missing cells in the output.

Câu hỏi thường gặp