How to Convert Text & CSV Files to Excel: 2 Easy Methods

This article was co-authored by wikiHow staff writer, Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions.

This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources.

This article has been viewed 73,250 times.

Do you have a plain text or CSV file you want to convert to an Excel spreadsheet? Whether you want to import a simple list of items or an extensive set of data that's delimited by commas, tabs, or other characters, you can use Excel's handy Text Import Wizard to open and format your data in organized columns and rows. This wikiHow guide will show you how to create a new Excel file from a text or CSV file, and how to import a text or CSV file into an existing workbook.

• You can open a text or CSV File in Excel from the "File" menu as you would any other file.
• After opening the text or CSV file, you'll go through the Text Import Wizard, which makes it easy to format your text into columns and rows. [1] X Research source
• If you want to add a text file to an existing workbook, just select "From Text/CSV" or "From Text (Legacy) on the Data tab.

Creating a New Excel File from Text

• Opening the file as you would any other file will launch the Text Import Wizard, which helps you format the text for your worksheet.
• If you already have Excel open, just click the File menu and select Open to get to the Open screen now.

Click Browse (Windows) or On My Mac (Mac). This opens your computer's file browser. [2] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source

Click the drop-down menu and select All Files (Windows only). This allows you to view all files instead of just those ending with Excel-specific formats.

• If you don't see your text file, click the file format menu and select All Files or Text Files. [3] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source

• Delimited text uses commas, tabs, or other characters to separate each field. This is common if you're importing things like contact lists, addresses, and data you've exported from databases. [4] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
• Fixed width contains text that's aligned into columns with single spaces between each field. This is common if you're working with a single-column list.

Check the box next to "My data has headers" (if your columns have headers). This tells Excel to format the first line as column headers rather than typical cell values.

Click Next in the Text Import window. This will take you to the next step, which varies depending on whether you're working with delimited data or fixed width data.

• Tab is checked by default. If you are not using tabs to separate data, uncheck this box. Otherwise, the wizard will automatically detect the spaces in your text as tabs and separated it into columns.
• If you don't see the character you need, select Other and type the character into the field.
• Select "Treat consecutive delimiters as one" if the delimiter consists of more than one character between data fields or if you have multiple delimiter characters.
• Optionally, you can select none of these options if you don't want to separate any of the data entries into columns.

• To add a break line, click at any location.
• Double-click a break line to delete it.
• Drag any of the lines to move it.

Click Finish . Your text file is now imported into Excel. You can now edit the data as you would on a standard worksheet. [6] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source

Save the file in the XLSX format. Now that you've imported your text file, you can easily save it as an Excel file. Just press Control + S (PC) or Command + S (Mac) on the keyboard to open the Save dialog, choose a file name and location, and click Save. The file will automatically save in Excel's default format.

Import Text into an Existing File

Open your Excel workbook." width="460" height="345" />

Open your Excel workbook. If you want to import a text file into a worksheet in an existing workbook, you can easily do so using Excel's built-in data tools.

Click the Data tab at the top of Excel. You can find this tab above the toolbar ribbon at the top of your spreadsheet.

• If you're using Excel for macOS, the option may be called From Text (Legacy), depending on your version. [7] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source

Select a text file and click Import . This can be any text file, including those which contain comma separated values (CSV). The selected file will open in the Text Import Wizard. [8] X Research source

• Delimited text uses commas, tabs, or other characters to separate each field.
• Fixed width contains text that's aligned into columns with single spaces between each field.
• Most text files contain delimited data. This means your data entries are separated by tabs, commas, or a different character, rather than fixed-width spaces with columns.

Check the box next to "My data has headers" (if your columns have headers). This tells Excel to format the first line as column headers rather than typical cell values.

Click Next in the Text Import window. This will take you to the next step, which varies depending on whether you're working with delimited data or fixed width data.

• Tab is checked by default. If you are not using tabs to separate data, uncheck this box. Otherwise, the wizard will automatically detect the spaces in your text as tabs and separated it into columns.
• If you don't see the character you need, select Other and type the character into the field.
• Select "Treat consecutive delimiters as one" if the delimiter consists of more than one character between data fields or if you have multiple delimiter characters.
• Optionally, you can select none of these options if you don't want to separate any of the data entries into columns.

• To add a break line, click at any location.
• Double-click a break line to delete it.
• Drag any of the lines to move it.

Click Finish . This takes you back to the Import window, where you'll be asked where you'd like to place the imported text. [10] X Research source

a worksheet and click OK." width="460" height="344" />

Select a worksheet and click OK . The text file is now imported into your Excel worksheet. You can edit this data as you would any other Excel data, such as using it to create graphs or pivot tables.

Save the file. Now that you've imported your text file, you can save it in the Excel format. Just press Control + S (PC) or Command + S (Mac) on the keyboard to save your changes to the workbook you've opened, or click File > Save As to create a new file containing your data. [11] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source

Expert Q&A

Tips

You Might Also Like

How to Merge Cells in Microsoft Excel: A Quick Guide

How to Password Protect a Microsoft Excel Spreadsheet

How to Use If‐Else in Microsoft Excel: Step-by-Step Tutorial

How to Show Hidden Columns in Microsoft Excel & Unhide Column A

How to Insert and Delete Rows in Microsoft Excel: Quick Guide

4 Easy Ways to Add Links in Microsoft Excel

How to Fix Ethernet Doesn't Have a Valid IP Configuration on Windows

How to Create an Inventory List in Microsoft Excel: Step-by-Step Guide