Search : in
By :

Moving data from csv to excel ?

Last answer on Dec 25, 2008 1:25:54 am GMT munkee, on Jul 26, 2008 12:00:09 am BST 
 Report this message to moderators

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.

Configuration: Windows 2000
Firefox 2.0.0.16

Best answers for « moving data from csv to excel ? » in :
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
VBA: Finding Hdc in an Excel worksheet or UserForm ShowVBA: Finding Hdc in an Excel worksheet or UserForm Here are two small examples on how to find Hdc in a worksheet: By clicking on Sheet1 the UserForm is displayed. Put the pointer on UF, hold the left mouse button down and drag the...
[Ingres] Importing/ Exporting data Show[Ingres] Importing/ Exporting data Making use of these commands copydb unloaddb Notes Ingres allows you to export data from an Ingres installation to another (it is a platform independent procedure). unloaddb copydb The main...
Spreadsheets - Data Entry ShowCell Content A cell of a worksheet can contain a value or be empty. The value of a cell has two essential characteristics: a type, which means the intrinsic type of the data. There are generally three types of values: numeric values, for example...

1

 Abz, on Dec 25, 2008 1:25:54 am GMT
  • +4

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

Reply to Abz