View the Most Wanted LQ Wiki articles.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
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!


  Search this Thread
Old 11-07-2011, 01:16 PM   #1
Registered: Dec 2010
Posts: 241

Rep: Reputation: 1
Question HOWTO transfer Hosts in excel sheet to file in LINUX?

Hi guys!

I have around 300 hostsname is excelsheet in one column. These hosts I want to add in one file in linux one after the another like hostname1,hostname2.hostname3,

I don't want to waste enter it manually it very time consuming, so how to transfer these files from excelsheet to a file in Linux?
Edit/Delete Message
Old 11-07-2011, 01:18 PM   #2
Senior Member
Registered: Nov 2010
Location: Colorado
Distribution: OpenSUSE, CentOS
Posts: 4,299

Rep: Reputation: 1496Reputation: 1496Reputation: 1496Reputation: 1496Reputation: 1496Reputation: 1496Reputation: 1496Reputation: 1496Reputation: 1496Reputation: 1496
I would save it out as a csv (comma separated variable) file, then parse it in a script, dividing the fields up using the comma delimiters.
Old 11-07-2011, 01:18 PM   #3
LQ 5k Club
Registered: Dec 2008
Location: Tamil Nadu, India
Distribution: Debian except for netbook still on Slackware 13.37 (and I have to support Ubuntu)
Posts: 8,572
Blog Entries: 30

Rep: Reputation: 1182Reputation: 1182Reputation: 1182Reputation: 1182Reputation: 1182Reputation: 1182Reputation: 1182Reputation: 1182Reputation: 1182
Copy from spreadsheet and paste into an editor?


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
Convert from XML in excel format to Excel XLS file CPAN module Perseus Programming 9 10-14-2011 12:39 PM
i want c program for fetching data from excel sheet rinu budhbhatti Programming 3 01-31-2011 08:23 AM
Want to import an excel sheet data from from a remote linux server envisage Programming 1 01-31-2008 01:08 PM
how to import MS-Excel sheet data using PHP dileepkk Programming 1 07-28-2004 02:23 PM

All times are GMT -5. The time now is 05:20 PM.

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