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 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 24, 2010 at 04:16 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 24, 2010 at 04:16 AM
Related:
- Moving data from csv to excel ?
- Transfer data from one excel worksheet to another automatically - Guide
- How to insert picture in word without moving text - Guide
- Tmobile data check - Guide
- Number to words in excel - Guide
- Excel date format dd.mm.yyyy - Guide
2 responses
Obviously it is possible by importing csv file from excel. Go to data menu and select from other souces option.
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..
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 24, 2010 at 04:16 AM
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.
