Skip to content

Instantly share code, notes, and snippets.

@dkesberg

dkesberg/import-csv.md

Last active March 4, 2020 12:29
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 dkesberg/ab6040374672fa0de36e02910a09d48c to your computer and use it in GitHub Desktop.
Save dkesberg/ab6040374672fa0de36e02910a09d48c to your computer and use it in GitHub Desktop.
Download ZIP
import csv data into xls
Raw
import-csv.md

Excel 2010:

Create new workbook Data > From Text > Select your CSV file In the popup, choose "Delimited" radio button, then click "Next >" Delimiters checkboxes: tick only "Comma" and uncheck the other options, then click "Next >" In the "Data preview", scroll to the far right, then hold shift and click on the last column (this will select all columns). Now in the "Column data format" select the radio button "Text", then click "Finish".

Excel office365: (client version)

Create new workbook Data > From Text/CSV > Select your CSV file Data type detection > do not detect Note: Excel office365 (web version), as I'm writing this, you will not be able to do that.

https://stackoverflow.com/questions/165042/stop-excel-from-automatically-converting-certain-text-values-to-dates

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment