Editing Web scraping (section)

== Transforming CSV data to JSON ==

'''Step 9'''

CSV data is good for analysis, but not so handy to use on the Web. JSON is a format that the Web and JavaScript likes. Luckily we can transform data from CSV to JSON with [https://csvjson.com/csv2json CSV2JSON].

The scraped data usually needs to be edited first. You can open the excel file in Number or Excel, change the headers and add content. After this you will need to export the data again to CSV (Comma-separated values) or TSV (Tab-separated values). This new file can then be uploaded to [https://csvjson.com/csv2json CSV2JSON], exported to a JSON file and added to you Web project.

We have a [https://hrnl-my.sharepoint.com/:f:/g/personal/kranv_hr_nl/EjySoHDaH5lPgdiA4aKTrUQBb2UpSQF5t9l7bUrcm2VI5g?e=bDz4KS demo video] available on this process.