The database capabilities of Excel are very powerful. In fact, not only can Excel be used to create a simple searchable database, it also can be used to create a proper relational database.

How Excel makes a relational database Relational databases—databases structured to recognize relations among the information stored in them—are essential for working with large amounts of ...

How to Create Excel Spreadsheets With MySQL. When you use MySQL to query a database, you have the ability to view results from that query on your screen or send them to a text file.