Question

State the steps to import data from a text file.

Accepted Answer

Steps to import/copy data from other sources: 1. Create the data file using Notepad program of MS Window. A comma-separated data value in one line of this text file is a row in a spreadsheet and each entry, separated by a comma is a column for that row. 2. In the first line provide names for the columns of the spreadsheet. In the next line onward, start entering the data separate by comma as per the names given in the first line. 3. It may be possible that every data may not be of similar length, but each data should be separated by comma as per the names of the column. 4. Open a new Excel worksheet from the Office Button. 5. Select data tab on the Ribbon. 6. On data Tab; an option get external Data having from Text option. 7. Click on 'from Text' which will allow Selecting a notepad file saved as, cum into Excel format directly and data will be copied into respective rows and columns. 8. Each and every data from Notepad file can be saved as an excel date file. This provides a lead that Excel worksheet consist of four types of data in Cells: Labels, Values, date and formulas and Data Validation. Labels: are Descriptive data Values: are generally raw numbers of dates a) whole numbers. b) Value with decimal Formulas: instructions to perform Calculation Dates

State the steps to import data from a text file.

Marking-scheme solution

More from Spreadsheet