It's always a trick to convert flexible Excel tables to databases, like this one.
But, it's good practice to just aim for SQL format of the Excel table conversion.
Like this header
Note this is just applicable for internal threads, I can convert it to a one-line header as
MinorDiaMin
MinorDiaMax
PitchDiaMin
PitchDiaMax
MajorDiaMin
MajorDiaMax
TapDrillBasic
ThreadRunouts
and I can save this page to csv files.
After it's saved as csv files, I can simply import that csv file into the MongoDB compass app or use MongoDB VScode extension to import.
Now you have a MongoDB database, take your connection string out and we can continue.
Top comments (0)