MS Excel - Open CSV with Long Numbers

What?
This is a quick reminder for myself on opening a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway).

My Data:
copyraw
Account ID,Name,Phone,Record ID
1457102000000135533,Joel,00441234567890,1457102000000165989
1457102000000135566,Stanley,01709123456,1457102000000167543
1457102000000135608,David,00331234567890,1457102000000166795
  1.  Account ID,Name,Phone,Record ID 
  2.  1457102000000135533,Joel,00441234567890,1457102000000165989 
  3.  1457102000000135566,Stanley,01709123456,1457102000000167543 
  4.  1457102000000135608,David,00331234567890,1457102000000166795 
My Excel:
copyraw
Account ID	Name	Phone	Record ID
1.4571E+18	Joel	4.41235E+11	1.4571E+18
1.4571E+18	Stanley	1709123456	1.4571E+18
1.4571E+18	David	3.31235E+11	1.4571E+18
  1.  Account ID    Name    Phone    Record ID 
  2.  1.4571E+18    Joel    4.41235E+11    1.4571E+18 
  3.  1.4571E+18    Stanley    1709123456    1.4571E+18 
  4.  1.4571E+18    David    3.31235E+11    1.4571E+18 

How?
Firstly, save the CSV file as text file (*.TXT). This will stop MS Excel simply opening the CSV as if it knew what to do with it. It doesn't. Saving the data source as a text file means that Excel will prompt you what to do with each column:

1. Specify that the data is delimited
Excel Import Data Step 1 of 3

2. Specify the data is delimited by commas
Excel Import Data Step 2 of 3

3. Specify which columns should be imported as text (the long numbers and phone numbers)
Excel Import Data Step 3 of 3
Category: Excel :: Article: 689

Credit where Credit is Due:


Feel free to copy, redistribute and share this information. All that we ask is that you attribute credit and possibly even a link back to this website as it really helps in our search engine rankings.

Disclaimer: Please note that the information provided on this website is intended for informational purposes only and does not represent a warranty. The opinions expressed are those of the author only. We recommend testing any solutions in a development environment before implementing them in production. The articles are based on our good faith efforts and were current at the time of writing, reflecting our practical experience in a commercial setting.

Thank you for visiting and, as always, we hope this website was of some use to you!

Kind Regards,

Joel Lipman
www.joellipman.com

Please publish modules in offcanvas position.