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 menu.

On the File menu, click Import. In the Import dialog box, click the option for the type of file that you want to import, and then click Import. In the Choose a File dialog box, locate and click the CSV, HTML, or text file that you want to use as an external data range, and then click Get Data.

CSV (comma delimited) .csv. Saves a workbook as a comma-delimited text file for use on another Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet. CSV (Macintosh).csv

Um die Ausführung des Textimport-Assistenten in Excel zu erzwingen, können Sie die Dateinamenerweiterung von .csv in .txt ändern, bevor Sie es öffnen, oder Sie können eine Textdatei importieren, indem Sie eine Verbindung damit herstellen (weitere Informationen finden Sie im folgenden Abschnitt).

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 …

The XML-based and macro-enabled file format for Excel 2016, Excel 2013, Excel 2010, and Excel 2007. Stores VBA macro code or Excel 4.0 macro sheets (.xlm). Excel Binary Workbook

Textové soubory hodnot oddělených čárkami (.csv), ve kterých znak čárky (,) obvykle odděluje jednotlivá pole textu. Můžete změnit znak oddělovače, který se používá v textových souborech s oddělovači i .csv.

När en .csv fil öppnas i Excel används de aktuella standardinställningarna för dataformat för att tolka hur du importerar varje kolumn med data. Om du vill ha mer flexibilitet när du konverterar kolumner till olika dataformat kan du använda guiden Importera text.

Pentru a forța Excel să ruleze Expertul import text, puteți modifica extensia numelui de fișier din .csv în .txt înainte de a-l deschide sau puteți importa un fișier text conectându-vă la acesta (pentru mai multe informații, consultați secțiunea următoare).

If your data source is an existing Excel spreadsheet, then you just need to prepare the data for a mail merge. But if your data source is a tab delimited (.txt) or a comma-separated value (.csv) file, you first need to import the data into Excel, and then prepare it for a mail merge. Step 1: Set up your data source in Excel