Skip to content

Instantly share code, notes, and snippets.

@leesmith

leesmith/import-csv-excel.txt

Created February 25, 2013 15:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save leesmith/5030422 to your computer and use it in GitHub Desktop.
Save leesmith/5030422 to your computer and use it in GitHub Desktop.
Download ZIP
Import CSV into Excel
Raw
import-csv-excel.txt
1. Download the file
2. Find the downloaded file on your computer and rename it so that it ends with the letters ".txt" rather than ".csv"
3. In Excel, click File -> Open, then locate and select the downloaded and renamed file. An "import" dialog will open.
4. During the import process, designate that the file is "Delimited" with a "Comma", and that the "File Origin" is set to UTF-8.
5. Click "Finish"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment