Skip to content

Instantly share code, notes, and snippets.

@ShaneIsley

ShaneIsley/csv convert with text

Created December 7, 2010 22:35
Show Gist options
  • Save ShaneIsley/732571 to your computer and use it in GitHub Desktop.
Save ShaneIsley/732571 to your computer and use it in GitHub Desktop.
Download ZIP
ause Excel to store data specifically as text
Raw
csv convert with text
Something I discovered way back when...
export data in the following pattern:
="Need to know",="0123456",="0101010"
The combination of the = and the " " cause Excel to store data specifically as text.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment