Import or export text (.txt or .csv) files - Microsoft Support
There are two ways to import data from a text file with Excel: you can open it in Excel, or you can import it as an external data range. To export data from Excel to a text file, use the Save As …
Text Import Wizard - Microsoft Support
Use the Text Import Wizard in Excel to import data from a text file into a worksheet. The Text Import Wizard examines the text file that you are importing and helps you ensure that the data …
Import data from a CSV, HTML, or text file - Microsoft Support
Here's how: Go to Data > Get & Transform Data > Get Data > From File. Select the type of file that you want to import (such as From Excel Workbook or From Text/CSV). Select the file you …
Save a workbook to text format (.txt or .csv) - Microsoft Support
Open the workbook you want to save. Click File > Save As. Pick the place where you want to save the workbook. In the Save As dialog box, navigate to the location you want. Click the …
File formats that are supported in Excel - Microsoft Support
Lists the file formats that are supported in Excel. The topic also includes a list of unsupported file formats and some suggested workarounds.
What to do if a data set is too large for the Excel grid
If you’ve opened a file with a large data set in Excel, such as a delimited text (.txt) or comma separated (.csv) file, you might have seen the warning message, " This data set is too large for …
Import data from data sources (Power Query) - Microsoft Support
Use Power Query in Excel to import data into Excel from a wide variety of popular data sources, including CSV, XML, JSON, PDF, SharePoint, SQL, and more.
Import data from a folder with multiple files (Power Query)
Use Excel's Get & Transform (Power Query) experience to combine multiple files, which have the same schema, from a single folder into a single table.
Insert an object in your Excel spreadsheet - Microsoft Support
Learn to insert objects such as Word documents, PowerPoint presentations, Visio drawings, graphs, to name a few, in your Excel spreadsheet.
Split text into different columns with the Convert Text to Columns ...
Learn how to take the text in one or more cells, and split it out across multiple cells by using Excel functions. This is called parsing, and is the opposite of concatenate. Watch more in this video.