Moving data from csv to excel ?

Closed
Report
Posts
2
Registration date
Friday July 25, 2008
Status
Member
Last seen
July 25, 2008
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Obviously it is possible by importing csv file from excel. Go to data menu and select from other souces option.
10
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

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..
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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.