How is text file imported to Excel

August 1, 2022

A free Office suite fully compatible with Microsoft Office

Free Download

Although you may upload a text file (TXT) or comma-separated value file (CSV) containing contact information to Constant Contact without any issues, there may be circumstances when you'd want text file (XLS or XLSX) imported to Excel. If you need to make changes to your data before importing it, using an Excel spreadsheet will make it much simpler to understand and work with your data. This is especially true if your contact list is rather extensive.

TXT, CSV, and XLS file types differences

Depending on your needs, text files, CSV files, and Excel spreadsheets are excellent ways to store data:

Text File (TXT) - Text files are usually made with TextEdit or NotePad (PC) and contain plain text (Mac). All styles and formatting are removed when material is pasted into a text file, leaving you with plain text. Data may be copied and pasted without formatting problems as a result. Data from a spreadsheet is separated by tabbed spaces when it is pasted into a TXT document.

Comma Separated Value File (CSV): A CSV file may be opened on any operating system, in any text editor, and in spreadsheet programmes like Excel. It also contains plain text. Data from a spreadsheet is separated by commas when it is pasted into a CSV file.

Excel Spreadsheet (XLS): Excel spreadsheets can only be accessed by other spreadsheet programmes, such as Google Sheets or OpenOffice Calc, but they offer a wide range of formatting choices, functions for data calculation, and charts and tables for visual data presentation. Cells, rows, and columns are used to segregate information copied into a spreadsheet.

Steps to get text file imported to Excel:

Click Data→ Import data→ Import data.

 Step 1: Select data source interface, and then select the appropriate TXT or CSV file.

Step 2: We may choose the encoding that makes our document viewable in the File Conversion interface. Text encoding is available in two flavours: Windows (Default) and Other encoding. Here, we select Windows (Default).

Step 3: Choose Delimited. A delimiter is basically a fancy way of expressing that your CSV file utilises commas to aggregate and divide your data, whereas your TXT file uses tabs.

Choose Next.

Step 4: In the Data preview area, select the delimiter that divides your data into distinct columns. Typically, when converting a TXT or CSV file, you want to use Tab or Comma, respectively.

Note: If the column header text contains many words, selecting Space may occasionally cause a single column to be divided into numerous columns. A First Name column, for instance, becomes both a First column and a Name column. Make sure your data is aligned with the desired column header by paying close attention to the Data preview!

Step 5: Choose Next.

Step 6: Choose General.

Step 7: Press Finish.

Step 8: In the field, enter =$A$1. By doing this, you can be confident that your data starts in the spreadsheet's Row 1, Column A cell. A file import error may result if the spreadsheet above your data has any blank rows.

Step 9: Select OK.

Step 10: Press Save.

In order to avoid import issues during text file import to Excel, you may now make changes to the column headers to ensure that they correspond with the default contact headings in Constant Contact, improve spelling, update the formatting, and get rid of unusual characters. Save your file when you're finished, then import your contacts.

Did you learn about how is text file imported to Excel? You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets and PowerPoint Slides.

You can also download WPS Office to edit the word documents, excel, PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience