Connecting moralis DB to excel?

Moralis General
#1

I am working on an NFT project for a client that would like access to the Moralis DB. He said he would prefer to connect in using Excel.

Is there a way to do this?

If not how can I let someone view the DB without giving them my Moralis login?

#2

you can dump the data from db in a CSV format, you can connect directly to the db and do that:

https://docs.moralis.io/moralis-dapp/database/direct_access

#3

You can do this from Excel? I have 0 experience with Excel to know if this translates to it

#4

I don’t know, I thought that you know Excel by how you asked that question :slight_smile:

what you can do from excel then?

#5

I dont use excel. My client says he would like to also be able to view the DB from excel (excel is his specialty).

#6

ok, then maybe you can ask him how to connect excel to mongo db

#7

Have a look at these links:

Using Microsoft Query in Excel to Connect to MongoDB (cdata.com)