JSON2CSV and CSV2JSON

Compare versions

Old version made in 9/5/2020
Newer version made in 16/8/2020

Tier: 1-Beginner

Developers and end users are both experts in their own domains and as such, each speaks using a domain-specific language and terminology. This also extends to the tools used to manipulate data. Developers have found JSON to be a universally accepted method for transferring data between applications. End Users, on the other hand, rely on spreadsheets to organize and analyze data.

The objective of JSON2CSV is to help bridge the gap between JSON and CSV by converting JSON to CSV to make it easier to review data in a spreadsheet. It allows the user to paste JSON into a text box to generate its equivalent CSV.

Constraints

You may not use any libraries or packages designed to perform this type of conversion.
If you choose to implement this in JavaScript don't use complicated looping in your first implementation. Instead, use Object.keys() and Object.values to generate CSV for the header and data rows.
Nested JSON structures are not supported.

User Stories

User can paste JSON syntax into a text box
~~User can click a 'Convert' button to validate the JSON text box and convert it to CSV~~ Without convertion buttons
User can see the converted CSV in another text box
User can see an warning message if the JSON text box is empty or if it doesn't contain valid JSON
User can click a 'Clear' button to clear the contents of both the JSON and CSV text boxes.

Bonus features

User can enter the path to the JSON file on the local file system in a text box
User can click a 'Open' button to load file containing the JSON into the text box
User can see a warning message if the JSON file is not found
User can enter the path the CSV file is to be saved to in a text box
User can click a 'Save' button to save the CSV file to the local file system
User can see a warning message if the CSV text box is empty or if the save operation failed.
User can convert CSV data to JSON. See CSV2JSON from AppIdeas

Useful links and resources

Example projects

Try to complete your JSON2CSV implementation before reviewing the example project(s).

Examples

Old version

New version

oscaramos/json2csv

ErrorLooks like something went wrong!

About

Topics

Resources

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Languages

Error
Looks like something went wrong!

Packages