I have some data that is currently in an xlsx. I'd like to put this data on the web, as is, so that it is queryable by anyone via a UI. ie someone visits mydatabase.com and they can perform ad hoc queries (SQL, some slick UI, whatever works) on the data.
The data is not big, it's a single sheet with about 20 columns and less than a million rows (however the xlsx file is too large to import in to google drive sheets, and attempts to save as csv have failed). I don't care if it is SQL, cloud based, some other service. I'm not concerned about cost. I don't need authentication or authorization or anything. I'm optimizing for just getting the data out there and ease of querying. I would like to be able to see visitor analytics if possible.
Before I go writing a webapp to do this, there must be something off the shelf?
First, get the data somehow to plain text. LibreOffice is maybe able to convert it to an CSV file. Otherwise you have to open it with Python (for example) to export the data to a text file or directly to a database.
Best way is to find a web hoster which allows you to make the database public. With this solution you can transfer the XLSX columns one by one (with Python) to your online database. After finishing change the database from public to local.
An easy UI in PHP isn't really a thing.