One of the common use of Microsoft Excel is for data log or entry for most of the root level users. As Excel has limitless cells, the users don’t need to be tensed. But setting data one after one is monotonous work. For that, a data log is a good solution. In this article, we will discuss how to create a data log in Excel in detail.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
What Is a Data Log in Excel?
The Data Log is a kind of form to gather data systematically. This makes data entry very easy. People don’t need to choose cells every time for data entry. They will put data in a specific form. And that form will decide where to locate data in the Excel worksheet.
We are showing a sample data log based on the Excel table. Basic data of employees are stored here.
- First, select all the cells with data.
- Now, choose the Table option from the Insert tab.
- The Create Table window will appear.
- Our selected range will show here. Check the My table has headers option.
- Finally, press OK.
We can see a table has been formed. There is a sign on the right bottom, that indicates the table area.
- We can expand the table easily. Press the Tab button from the keyboard and the table automatically expand.
There is a shortcut to forming a table, press Ctrl+T.
This is what a data log looks like in a table form. But we will show how to create a data log just by inputting information into a custom form and that will make a dataset.
2 Methods to Create a Data Log in Excel
We are going to discuss 2 methods to create a data log in Excel.
1. Create Data Log Using Customized Excel Form
We will apply this customized form in Excel Table to enter data smoothly.
- Go to the upper top portion of the worksheet.
- Press the right button of the mouse on the existing icon of the Quick Access Toolbar.
- Now, click on the Customize Quick Access Toolbar option.
- Excel Options window appears now.
- Select Quick Access Toolbar from the right side table.
- Choose All Commands of the Choose commands from section.
- Select Form and click Add button.
- Select the Form option of the Customize Quick Access Toolbar section. Finally, click OK.
- We can see the Form icon added to the worksheet.
- Now, select any cell of the table. Then, click on the Form icon.
Customize Form window appears now. And the information of the 1st cell is shown.
- Now, click on the New option of the Customize Form.
- Input values in different cells and then click on New.
- Have a look at the following image.
We can see a new row is added to the table.
- The Customize Form has multiple options to perform.
- We can move the navigator to get further data.
There are also options to go previous and next option. We can discover any item from the Criteria option.
- Click on the Criteria button.
- We can search based on any option of the input data. We will search based on the Department option. We can click on Find Prev and Find Next options.
- We can click on the Find Next button.
This is the easiest way for a data log.
Read More: How to Create Data Entry Form in Excel VBA (with Easy Steps)
- How to Create an Autofill Form in Excel (Step by Step Guide)
- Types of Data Entry in Excel (A Quick Overview)
- How to Create Data Entry Form with Drop Down List in Excel (2 Methods)
2. Create Data Log Using OndeDrive Forms
In this section, we will use the OneDrive-based Form. This is a Microsoft product to create a data log. Please have a look below.
- First, enter the Onedrive from any browser.
- Click on New from the Forms survey option.
- A form appears named Untitled form.
- Rename the form as Employee Information.
Now, we will add options to the input data.
- Click on Add new option.
- A row appears with different options.
- Click on the Text option.
- We can make the options mandatory or compulsory.
- Click on Required to make it mandatory.
- Similarly, add other columns.
- Click on the Preview option.
- Have a look at the window.
This is the user interface. We can also see there are 2 options desktop view and mobile view.
- Now, input the information. And, then click on Submit button.
- Finally, see a submitted response.
- Now, go to the Responses tab.
We can see the inputted information. And also there is the Open in Excel option to download the Excel file.
This is what the Excel file looks like after inserting information.
Read More: How to Create an Excel Data Entry Form without a UserForm
- For Method 1 Excel table is mandatory.
- In Methode 2, internet connectivity is a must, and the user must have an email address.
In this article, we described how to create a data log in Excel. Of them, one method is web-based. I hope this will satisfy your needs. Please have a look at our website ExcelDemy and give your suggestions in the comment box.