Can MS Excel be used as a relational database?

Can you use Excel as relational database?

Not anymore: Excel 2013's table tools include features that make it easy to link charts and cells, perform searches, and create dynamically updated reports, just like—yes—a relational database. Excel can handle a lot of day-to-day office data this way, and we'll show you how to set it up.

How do you create a relational table in Excel?

Creating a relationship in Excel – Step by Step tutorial1First set up your data as tables. To create a table, select any cell in range and press CTRL+T. ... 2Now, go to data ribbon & click on relationships button.3Click New to create a new relationship.4Select Source table & column name. ... 5Add more relationships as needed.

Why use relational database over Excel?

But for the easy retrieval and updating of data, efficiency, data consistency, data integrity, speed, and security, relational databases are definitely the structure to opt for. They can store lots of raw data and are excellent when separating the data from the way it is displayed for analysis.