DEV Community

Robertblazor
Robertblazor

Posted on

Create a MongoDB database from Excel table

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

Image description

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)