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.
“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.