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 command and change the file type from the drop-down …
Import data from a CSV, HTML, or text file - Microsoft Support
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 want to import, and then select Import .
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.
Create or edit .csv files to import into Outlook - Microsoft Support
A CSV (Comma Separated Values) file is a special type of file that you can create or edit in Excel. Rather than storing information in columns, CSV files store information separated by commas. When text and numbers are saved in a CSV file, it's easy to …
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 is imported in the way that you want.
Opening CSV UTF-8 files correctly in Excel - Microsoft Support
You can open a CSV file encoded with UTF-8 normally if it was saved with BOM (Byte Order Mark). Otherwise, you can open it through either of the following ways. Through PQ (Power Query) using the Get Data dropdown.
Save a workbook to text format (.txt or .csv) - Microsoft Support
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 arrow in the Save as type box and pick the type of text or CSV file format you want.
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 the Excel grid. If you save this workbook, you'll lose data that wasn't loaded.
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.
Import or export contacts in Outlook using a .csv file
How to convert your CSV file to UTF-8 using Microsoft Excel: In Excel, create a new blank document (workbook). From the Data menu, select From Text/CSV. Browse to your exported CSV file (you may have to select to display Text Files (....csv) to see it). Select Import.