LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 02-15-2011, 09:34 PM   #1
ust
Senior Member
 
Registered: Mar 2003
Location: fasdf
Distribution: Debian / Suse /RHEL
Posts: 1,130

Rep: Reputation: 30
csv to excel


I would like to find a tools to change csv file to excel , I tried google , there are some tools can do it , but the file have some specical character and Chinese character , can advise what tools is good for it ?

another that , I have one specical requirement , I would like the tools can change the date format of a specific column ( eg. from mm-dd-yy to dd/mm/yy ) , is there any tools can do that ?

Thanks in advance.
 
Old 02-15-2011, 10:30 PM   #2
kbp
Senior Member
 
Registered: Aug 2009
Posts: 3,790

Rep: Reputation: 650Reputation: 650Reputation: 650Reputation: 650Reputation: 650Reputation: 650
There is an Excel module for perl if you have perl skills ... ?
 
Old 02-15-2011, 11:14 PM   #3
sunnydrake
Member
 
Registered: Jul 2009
Location: Kiev,Ukraine
Distribution: Ubuntu,Slax,RedHat
Posts: 289
Blog Entries: 1

Rep: Reputation: 41
open in OpenOffice save in xls
 
Old 02-16-2011, 12:26 AM   #4
ust
Senior Member
 
Registered: Mar 2003
Location: fasdf
Distribution: Debian / Suse /RHEL
Posts: 1,130

Original Poster
Rep: Reputation: 30
Quote:
Originally Posted by sunnydrake View Post
open in OpenOffice save in xls
No , I prefer use tools .
 
Old 02-16-2011, 12:42 AM   #5
John VV
LQ Muse
 
Registered: Aug 2005
Location: A2 area Mi.
Posts: 17,225

Rep: Reputation: 2521Reputation: 2521Reputation: 2521Reputation: 2521Reputation: 2521Reputation: 2521Reputation: 2521Reputation: 2521Reputation: 2521Reputation: 2521Reputation: 2521
Quote:
I would like to find a tools to change csv file to excel
it is called
" sheet from file"

look in the insert tab

that is how i put csv files ( images ) into OO calc

then to edit
-- use calc -- this is a spread sheet .
 
Old 02-16-2011, 07:58 PM   #6
ust
Senior Member
 
Registered: Mar 2003
Location: fasdf
Distribution: Debian / Suse /RHEL
Posts: 1,130

Original Poster
Rep: Reputation: 30
Quote:
Originally Posted by John VV View Post
it is called
" sheet from file"

look in the insert tab

that is how i put csv files ( images ) into OO calc

then to edit
-- use calc -- this is a spread sheet .

Sorry , do you mean I need manually do something to convert the file ? if I want to use a tools to help me convert it , what can i do ? thx
 
Old 02-16-2011, 08:10 PM   #7
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910
http://search.cpan.org/~jmcnamara/Ex...ter-XLSX-0.09/




Cheers,
Tink
 
Old 02-16-2011, 08:14 PM   #8
John VV
LQ Muse
 
Registered: Aug 2005
Location: A2 area Mi.
Posts: 17,225

Rep: Reputation: 2521Reputation: 2521Reputation: 2521Reputation: 2521Reputation: 2521Reputation: 2521Reputation: 2521Reputation: 2521Reputation: 2521Reputation: 2521Reputation: 2521
Quote:
Sorry , do you mean I need manually do something to convert the file
no , you import a csv text file into a spread sheet .
it is a basic function .
 
Old 02-16-2011, 08:54 PM   #9
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.9, Centos 7.3
Posts: 17,411

Rep: Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397
To expand on JohnVV, modern spreadsheet systems automatically recognise a csv and will load it without any need for 'conversion'.
Of course if you have 'specical character and Chinese character' that are not part of your native settings, then you will have to do a conversion.
You'll need to supply a bit more detail for us to help.
NB: my knowledge of Excel etc pretty much stops at this point ... good luck
 
Old 02-17-2011, 08:23 PM   #10
ust
Senior Member
 
Registered: Mar 2003
Location: fasdf
Distribution: Debian / Suse /RHEL
Posts: 1,130

Original Poster
Rep: Reputation: 30
Quote:
Originally Posted by Tinkster View Post

Thanks ,

But I do not know how to use perl , can advise other tools ? Thanks
 
Old 02-17-2011, 08:27 PM   #11
dugan
LQ Guru
 
Registered: Nov 2003
Location: Canada
Distribution: Slackware
Posts: 7,633

Rep: Reputation: 2951Reputation: 2951Reputation: 2951Reputation: 2951Reputation: 2951Reputation: 2951Reputation: 2951Reputation: 2951Reputation: 2951Reputation: 2951Reputation: 2951
Launch Excel. Open the CSV file with Excel. Have Excel save it in its native format.
 
Old 02-17-2011, 08:40 PM   #12
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910
Quote:
Originally Posted by ust View Post
Thanks ,

But I do not know how to use perl , can advise other tools ? Thanks

Sorry,

I don't know any; I recommend learning perl - the sysadmins swiss army knife.




Cheers,
Tink
 
Old 02-17-2011, 11:32 PM   #13
someshpr
Member
 
Registered: Jul 2009
Location: WI, USA
Distribution: Debian 8, Ubuntu 16.04, CentOS 7
Posts: 141

Rep: Reputation: 28
I came across this when I was looking for a python script to do the opposite, i.e., batch convert a bunch of xls files to csv and manipulate. Take a look if it helps:
http://sujitpal.blogspot.com/2007/02...-files-to.html
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Odd grep problem with Excel CSV saltz Programming 1 07-23-2009 10:23 PM
Comparing two csv files and write different record in third CSV file irfanb146 Linux - Newbie 3 06-30-2008 10:15 PM
convert excel to csv and html thelonius Programming 3 03-28-2007 12:16 PM
excel to csv generator shweta Linux - Software 2 09-08-2006 08:03 AM
Culling Data from a CSV file to output in excel jterr02 Programming 2 05-19-2006 05:58 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 06:56 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration