Previous Topic Next Topic

Moving data from csv to excel ?

Closed
munkee Posts 2 Registration date Friday July 25, 2008 Status Member Last seen July 25, 2008 - Jul 25, 2008 at 07:00 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 24, 2010 at 04:16 AM
Hello and thanks for any help that might be provided,

I was wondering if it is possible to grab data from a csv file that is updated by another program once a day and input it into an excel sheet to do further analysis?

example from csv file:

XYZ,07/25/2008,345.59
ABC,07/25/2008,122.01
DEF,07/25/2008,35.22

translate to excel file:

Date XYZ ABC DEF
07/25/2008 345.59 122.01 35.22
07/24/2008 343.29 124.88 37.05

Is this possible?

Thanks again for your help.

2 replies

Answer 1 / 2
Abz
Dec 24, 2008 at 08:25 PM
Obviously it is possible by importing csv file from excel. Go to data menu and select from other souces option.
10
Answer 2 / 2
D.choudhary
Feb 24, 2010 at 12:24 AM
What if we have records > 65k , eg. 2 Lakh.. in csv file , how we can build single excel sheet from that, like records more then the limit of excel sheet will in sceond tab of that excel sheet..
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Feb 24, 2010 at 04:16 AM
With such a huge amount of data, perhaps you should look into usage of access or sql server or mysql or some thing like that. But if you still want to use excel, you either divide the file into less than max allowed row in your version of excel or use code to read the file and import one record at a time.
0