Artículos con :
Artículos con :
Pruébelo en la nube

Get data from TXT/CSV file

If you need to quickly get data from a .txt/.csv file and have it all arranged properly in a spreadsheet, use the Get data from Text/CSV file option available on the Data tab.

Step 1. Importing the file

  1. Click the Get data option on the Data tab.
  2. Choose one of the two importing options:
    • From local TXT/CSV: find the needed file on your hard drive, select it and click Open.
    • From TXT/CSV web address: paste the link to the file or web page into the Paste a data URL field and click OK.

Step 2. Configuring the settings

The Text Import Wizard encompasses four sections: Encoding, Delimiter, Preview, and Choose where to put data.

Text Import Wizard

  1. Encoding. The parameter is set to UTF-8 by default. Leave it at that or select the type you need using the drop-down menu.
  2. Delimiter. The parameter sets the type of delimiter used to distribute the plain text into different cells. The delimiters available are Comma, Semicolon, Colon, Tab, Space, and Other (enter manually). Click the Advanced button located to the right to set a decimal separator and a thousands separator. The default separators are “.” for decimal and “,” for thousands.
  3. Preview. The section shows how the text will be arranged in the spreadsheet cells.
  4. Choose where to put data. Enter the required range in the field or choose one using the Select data button to the right.
  5. Click OK to import the file and exit the Text Import Wizard.
Volver a la página anterior
Probar ahora gratis Pruebe y tome su decisión No se necesita instalar algo para
ver todas las posibilidades en la acción