In this tutorial, you will learn how to create a Database or DataTable in Microsoft Excel. Please follow these simple steps to create your Microsoft Excel Database or Datatable. Step 1: Open Microsoft Excel Workbook Step 2: Enter below data Image 1: Sample data Step 3: Select all data Step 4: Click on Insert | Table Step 5: A dialog box will appear where the data range was automatically selected based on your data. Image 2: Insert | Datatable Step 6: Place a check mark on " My table has headers ". Image 3: Create "Ok" Step 7: Click on "Ok". Your current data is now converted to Database or Datatable.