Articles with the tag:
Close
Changelog
Close
Articles with the tag:
Close
Try in the cloud

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.
Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action