help with excel

#1
Hi Everyone,

I need help with Excel. I have multiple CSV file with historical data which I want to put it in Excel. Can anyone help me with this.

Thanks,
ar_wind
 
#2
Dear Ar_Wind

Its pretty simple. Just File / Open and select the CSV File (incase u are unable to see the same in the directory, change the "Files of Type" to ALL FILES - instead of EXCEL FILES)...
A Text Import Wizard Popup will come on screen. On the 1st screen popup, select DELIMITED and clk NEXT.
In Step 2 of 3 (can be seen in the heading of the dialog box), Check TICK on Comma and u will see the data automatically getting formatted into proper columns.
Then (in Step 3 of 3), if there is any column with date format, highlight that particular column and change the date format to the proper setting and select FINISH....
After that (incase you want to save it as Excel File), select File / SAVE AS and select TYPES OF FILE as Excel.....
And u're done.....
Hope this solves your problem.
RB
 

sudris

Well-Known Member
#3
I guess what rbhapkar said will be applicable to single file only and you will have to do it for all the files one by one.

just try doing this small step before you proceed with text import.

1) Windows Start Button | Run
2) Type cmd and hit enter (“command” in Win 98)
3) Go to the folder with the CSV files (for help enter “help cd“)
4) Type copy *.csv all.txt and hit enter to copy all data in the files into all.txt.
5) Type exit and hit enter to close the DOS window

Now we must import the text file all.txt into Excel.

1) Open Excel
2) When you use File Open to open all.txt the Text Import Wizard will help you import the file
3) Choose Delimited
4) Next
5) Check Comma
6) Finish
 
#4
Which version o MS Office (Excel) are you using ?? Generally you can open .csv files simply by double-clicking on the file name. Then you can either (a) "Save as" in excel format, or (b) simply copy/paste the data onto a new blank excel worksheet and save it :)
 

chandra1

Active Member
#6
Thanks but I have many such files so how do I select them all into one excel sheet.
Please specify your requirement in detail, like

How many files do you have (in number),
Number of rows and columns in each file,
What you want to do with these files.
In how many files you want to convert these files.
Is the data of these files are of similar type (but of different dates only).
Which version you are using upto 2003 or 2007 and later.

If possible and if you wish, you may attach one file for reference and to understand what you want to do.

Perhaps myself or someone else may help you, after knowing your exact requirement.
 

sudris

Well-Known Member
#7
Thanks but I have many such files so how do I select them all into one excel sheet.
did you try with what I had posted in post#3?

you can even try the code
Code:
copy *.csv all.csv
instead of all.txt to avoid the text import later on.

even if you have headers in those individual files, they could be taken care of by sorting once you open all.csv in excel.


This is the simplest way and doesn't require much knowledge of coding
 

biggles

Active Member
#8
hi sidris,
when a cell is updated with fresh data (refresh all), the new data replaces the old data. i want to push the old data down one cell and have the new data in the first cell. that is to say insert rather than replace. Is there a facility for this? i want this to happen automatically every time data is refreshed.

thanks
 

mastermind007

Well-Known Member
#9
hi sidris,
when a cell is updated with fresh data (refresh all), the new data replaces the old data. i want to push the old data down one cell and have the new data in the first cell. that is to say insert rather than replace. Is there a facility for this? i want this to happen automatically every time data is refreshed.

thanks
You cannot push down without causing excel hangups. If you want to archive as well as use latest, it is easier to have your feed routed to write to a csv (or a locally stored html file) and then have excel refresh from the source.
 
#10
Hi there
I have encountered the same questions.Is it possible to convert the multiple CSV file with historical data to excel?Or is there any amazing excel processing program which supports to do that directly?I wish there is a tool supports to do that.Thanks for any suggestion.
 

Similar threads