Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

Please note: This guide assumes the regional format settings of your Windows OS has been set to English (United Kingdom).*

*The same applies if you have selected different English-language settings e.g. English (United States).

What to expect from this page?

...

  1. Open a blank Excel workbook

  2. Click the "Data" field in the top menu bar

  3. Select "Get External Data > From Text"

  4. Choose the file you want to import and click "Import"

  5. In the Step 1 window that shows up select the option "Delimited" for the original data type, and check the box "My data has headers", then click "Next"
    -->

  6. Image Added

    Image Removed

    In Step 2 choose "Comma" as the delimiter (separator) type -->

    Image Removed
  7. Image Added

    Click on "Finish", then "OK" to insert the data into the workbook

  8. Check if your decimal data has been imported correctly

...