EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Tools Excel Create Database
Secondary Sidebar
Excel Functions
  • Excel Tools
    • Excel Shortcut Redo
    • Reduce Excel File Size
    • Quick Analysis in Excel
    • Goal Seek in Excel
    • Compare Two Lists in Excel
    • Excel Quick Analysis
    • Estimate Template in Excel
    • Pivot Table Count Unique
    • CSV Files into Excel
    • Excel Business Plan Template
    • Excel Export to PDF
    • Free Excel Template
    • Excel Repair
    • Color in Excel
    • Form Controls in Excel
    • Timecard Template in Excel
    • How to Unhide All Sheets in Excel?
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (12+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE

Excel Create Database

By Madhuri ThakurMadhuri Thakur

Feature Image

Excel Create Database (Table of Contents)

  • Create a Database in Excel
  • How to Create a Database in Excel?

Introduction to Create Database in Excel

If you want to create a database, MS Access is the tool you ideally should look for. However, it is a bit complicated to learn and master the techniques therein as MS Access. It would help if you had ample time to master those. In such cases, you can use excel as a good resource to create a database. It is easier to enter, store, and find specific information in the Excel Database. A well-structured, well-formatted excel table can be considered as a database itself. So, all you have to do is create a table that has a proper format. If the table is well-structured, you can sort the data in many different ways. Moreover, you can apply the filters to well-structured data to slice and dice it as per your requirements.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

How to Create a Database in Excel?

We’ll be creating an employee database for the organization. Let’s see how to create a database in Excel by following the below process:

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,325 ratings)
You can download this Create Database Excel Template here – Create Database Excel Template

Data Entering to Create Excel Database

Data entering is the main aspect while you are trying to create a database in Excel.

Employee Data

Suppose this is the data thatq1 you are going to use as an employee database.

I have added the first few Employee ID’s. Say D01, D02, D03 and then dragged the remaining till row 12 using Fill Handle. Column second onwards contains the general employee information like First Name, Last Name, Designation, and Salary. Filthis informationon in cells manually as per your details. Make sure the Salary column format is applied to all the cells in the column (Otherwise, this database may cause an error while using).

Entering Correct Data

It is always good to enter the correct data. Make sure there is no space in your data. When I say no other blanks, it covers the column cells, which are not blank as well. Try to the utmost that no data cells are blank. If you don’t have any information available with you, prefer to put NA over a blank cell. It’s also important to make the right input to the right column.

See the screenshot below:

Entering Correct Data - 1

Suppose,uy as shown in the image above, you wrongly interchanged the column inputs. i.e. you have mentioned Designation under Last Name and Last Name under Designation, which is a serious drop-back when you are thinking of this as a master employee data for your organization. It may mislead some of your conclusions.

Suppose you have added a correct entry, but at the 2nd row after the last row (i.e. one row is left blank). It is also not recommended to do so. It is a breakdown for your data. See screenshot given below:

Entering Correct Data - 2

As you can see, there is one row left blank after row no. 12 ( second last row of the dataset) and added one new row, which is not recommended. On similar lines, you should not leave any blank column in the database.

Let’s see the screenshot below:

Create Excel Database 4

As you can see, column F is left blank. Which causes Excel to think there is a split of data. Excel considers that a blank column is a separator for two databases. It is misleading, as the column after the blank column is a part of your original database. It’s not the start column of a new database.

All the Rows are called Record in Excel Database.

It is a kind of basic knowledge we should have about the database we are creating. Every single row we create/add is called as a Record in the database. See the below screenshot for your reference:

Create Excel Database 5

Every Column is a Field in Excel Database

Every column is called Field in the Excel database. The column headings are called Field Names.

Create Excel Database 6

Format Table

Once you are done with inputting the data, it should be converted into a better visualisation table.

  • Select cells A2 to F12 from the spreadsheet.
  • Go to the Home tab.
  • Select Format as Table drop-down menu. You can choose a table layout of your own.

Create Excel Database 7

Once you click a particular table format, a table window will pop up with the range of data selected, and a dotted line will surround that range. You can change the range of the data therein in the table dialog box as well.

Create Excel Database 8

Once you are happy with the range, you can choose, OK. You can see your data in a tabular form now. See the screenshot given below:

Create Excel Database 9

Use Excel Database Tools to Sort or Filter the Data

You can use the drop-down arrows situated beside each Field Name to Sort or Filter the data as per your requirement. These options are really helpful when you are dealing with a large amount of data.

Create Excel Database 10

Expanding the Database

If you want to add some more records to your table, you can do it as well. Select all the cells from your table.

Place your mouse at the bottom of the last cell of your table. The mouse pointer will turn into a two-headed arrow. You can drag down the pointer from there until you want to add that many blank rows in your database. Subsequently, you can add data under those blank cells as well.

Database Formatting

Highlight cell A1 to F1 from the spreadsheet.

  • Select Home tab
  • Under the Home tab, go to Wrap Text as well as Merge and Center.
  • You can also change the fill colour. Select Fill Color. Choose the colour of your interest. Here I have selected Green as a colour.

Create Excel Database 11

This is how we have created our Database in Excel.

Things to Remember About Create Database in Excel

  • Information about one item should be populated in one single row entirely. You can’t use multiple lines to add different data of the same item in the excel database.
  • The field should not be kept empty. (Including Column Headings/Field Name).
  • The data type entered in one column should be homogeneous. For, e.g. If you are entering Salary details in the Salary column, there should not be any text string in that column. Similarly, any column containing text strings should not contain any numerical information.
  • The database created here is really a very small example. It becomes huge in terms of employees joining every now and then and becomes hectic to maintain the data again and again with the standard formatting. That’s why it is recommended to use databases.

Recommended Articles

This has been a guide to Create a Database in Excel. Here we discuss how to Create a Database in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Excel Import Data
  2. Table styles in Excel
  3. Toolbar in Excel
  4. Excel Rows and Columns
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Training (23 Courses, 9+ Projects)4.9
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formulas, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Create Database Excel Template

EDUCBA

Download Create Database Excel Template

EDUCBA

डाउनलोड Create Database Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more