What’s the easiest way to convert some excel spreadsheets into an API and where do I host it?

[questionBot]

I’m thinking of finding primary keys across the tables and using the headers, then convert the CSV tables to JSON and then deploy to firebase

[b4oshany (Oshane Bailey)]

You can deploy it to firebase or put it on GitHub as a repository. If you put it on GitHub, you can use GitHub pages to provide an API endpoint or just using the raw file on GitHub

Convert Excel to CSV as I mentioned before, and then u can use one of the following tools to convert it to JSON:

• http://beautifytools.com/excel-to-json-converter.php
• https://www.convertcsv.com/csv-to-json.htm

Afterwards, create a GitHub repo on or firebase app, then deploy it.

If you’re doing it from code, there are packages for NodeJs and Python-like the ones below that can help with the major task:

• https://www.npmjs.com/package/convert-excel-to-json
• https://pypi.org/project/json-excel-converter/

[b4oshany (Oshane Bailey)]

@b4oshany

If you’re doing it from code, there are packages for NodeJs and Python-like the ones below that can help with the major task:

• convert-excel-to-json - npm
• json-excel-converter · PyPI

In addition, you can write a program to do the conversion upon uploading, which will then deploy the new API.