On


Hello everyone, this article will be the first in a series of essential Excel tips (often used in study and work). Hope everyone will always follow and support QTitHow.

In many cases you need to import data into the Excel file from a text file or from a CSV file.

In fact, the data you receive is in a simple text file, and your wish is to convert that text file into an Excel file (with rows and columns) for you to easily manage and use. This article will guide you to do that.


➠ Follow & send us a message on QTitHow for answers to IT issues.


How to do:

Step 1: Open a new Excel file (new Workbook). Switch to the Data tab, select From Text/CSV.



Step 2: A window will appear, please select the existing text file > Click Import (or double click on the selected file). The data on your text file will be displayed as below.



Step 3: Next step, choose Delimiter to match the content of your text file. Commonly used delimiters: colon - ":", comma - ",", equal sign "=", semi colon - ";"...

For example, in this case, the data fields are separated by semicolons.



Step 4: Click Load to import the data into the Excel file. This is the result.


The data on the excel file after being imported from the text file will be in Table format.

Some more features explained:

  • You can define your own delimiter and choose Custom to import the data.
  • Refresh feature: restore all original values, including delimiter entries.
  • Transform feature: Used to adjust some information before you perform step 4. Adjustments such as rows, columns, data,...

Use Transform feature to adjust rows, column, data...

Attention:

  • The data on the excel file after being imported from the text file will be in Table format.
  • You can import data from a CSV file (Excel sheet). The method is similar to the text file.

Conclusion:
The above are just extremely basic instructions when you want to import data into an Excel file from a Text or CSV file. If you have any questions please leave a comment below. Thank you!