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.
This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.