JSON database for Excel


Excel 2019 has extract, transform and load features worth exploring. Using Azure SQL database tab therein, can one access the Mongodb databases? If so how, please detail the steps. Any help or lead would be useful.

Thank you.

Yours truly,
Ashish Rai

Hi @Ashish_Rai,

The tabular layout of Excel generally isn’t a great match for the flexible data structure of MongoDB, so I’d personally be inclined to use a tool more focused on Business Intelligence (BI) use cases.

You can connect to MongoDB from Excel and other tools that do not natively support MongoDB using the MongoDB Connector for BI (which provides a SQL to MongoDB interface) and the MongoDB ODBC Driver for BI Connector (which adds an ODBC interface via the BI Connector).

Assuming you are using Windows (refer docs for other O/S), to get started see:


1 Like

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.