Working with Excel inevitably means handling data, but sometimes this data comes from a source other than Excel. This can…Read more
Working with Excel inevitably means handling data, but sometimes this data comes from a source other than Excel. This can be from a text file, word document, webpage or any other source. Usually copying and pasting data doesn’t format correctly, leading to errors and poor data security.
In the example below we are trying to import data from a .txt file.
Copying and pasting this data wouldn’t work so you need to do it through Excel.
Open the Excel file that you need and select the cell where you want the data to be imported into.
Select the type of data that you want to import.
Then go through the text import wizard. In this example we are selecting that the data is delimited as commas are used to separate each field. And we also need to select that the data has headers.
You can then need to select the delimiter and check that it is correct in the data preview.
Click finish, then okay and your data will be imported.