Excel file to MongoDB Schema

A new client has given me an excel file that outlines an example of what they need in their date base.

Is there a tool of any sort that would extract a MongoDB schema from that excel file?

Obviously, I could edit the schema file when it’s done, but I thought it there might be something to get the heavy lifting of a rough draft out of the way first.

I found an answer here: https://stackoverflow.com/questions/25241500/how-to-import-excel-file-xlsx-to-mongodb#25244720

“You cannot import an XLSX file into MongoDB directly. However, what you can do with an Excel spreadsheet is save it as a CSV file, then use mongoimport to import it into MongoDB.” There is more to the answer.

1 Like

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.