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)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay