Csv to json

[Naren]

How to convert CSV to Json format for import json functionality?Any online tools for it or need to be scripted

[Stephen Sifers · Accepted solution]

Hello Narendra and welcome to the Community!

There are multiple tools available to convert a CSV file to a JSON format. Unfortunately, we cannot recommend one tool, but a quick google search will show multiple options.

If security is a concern then you’ll most likely want to avoid freeware or online tools to do such a conversation. A solution I’ve done in the past is to create a script to manage these types of conversions.

1. Ensure your CSV file is in a good state.
2. Within your script, ingest the file into either an array or database.
3. From there, output the array or database table into a JSON format.
4. Once you have this JSON formatted data, you can then progress to your next steps.

I hope this provides some guidance on how to move forward and assists with your goal.

Regards,
Stephen Sifers

[Saba Ghani]

Hi Stephen! Going forward with the ongoing discussion I have managed to convert my .csv to JSON. but the exact format Jira accepts, how to convert in that, please?