LinuxQuestions.org
Share your knowledge at the LQ Wiki.
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 04-21-2017, 01:09 PM   #1
Gregg Bell
Senior Member
 
Registered: Mar 2014
Location: Illinois
Distribution: Xubuntu
Posts: 2,034

Rep: Reputation: 176Reputation: 176
converting .ods to .csv file in LibreOffice Calc question


I have email lists in .csv files. Sometimes I need to copy email addresses from the .csv into a new Calc text document, which is .ods. When I "save as" it gives me the option to save as a .csv. But when I do the actual saving it gives me this popup window (screenshot) giving me the options to change the "field delimiter" and "text delimiter." I tracked this down https://help.libreoffice.org/Calc/Im...ting_CSV_Fileshttps://help.libreoffice.org/Calc/Im...ting_CSV_Files but it doesn't say what the options mean. This is my first experience with this and I just want to make sure when I send the list to the Mailchimp provdier the email lists function properly. My guess is to just go with the default, but I'd really rather not be guessing about this. Thanks.
Attached Thumbnails
Click image for larger version

Name:	Selection_259.png
Views:	48
Size:	34.8 KB
ID:	24826  
 
Old 04-21-2017, 01:15 PM   #2
Turbocapitalist
LQ Guru
 
Registered: Apr 2005
Distribution: Linux Mint, Devuan, OpenBSD
Posts: 7,578
Blog Entries: 4

Rep: Reputation: 3875Reputation: 3875Reputation: 3875Reputation: 3875Reputation: 3875Reputation: 3875Reputation: 3875Reputation: 3875Reputation: 3875Reputation: 3875Reputation: 3875
As you see, you can separate the cells with a comma or other characters like a tab. Which does the provider require?

Also, since the resulting file is text, you can view it in an editor and actually see what it has used.
 
1 members found this post helpful.
Old 04-21-2017, 01:18 PM   #3
DavidMcCann
LQ Veteran
 
Registered: Jul 2006
Location: London
Distribution: PCLinuxOS, Salix
Posts: 6,185

Rep: Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325
The default is the normal for CSV: commas between fields, text in double quotes. As you see, you can separate fields with tabs, or use single quotes, etc: it's up to you.
 
1 members found this post helpful.
Old 04-21-2017, 01:53 PM   #4
Gregg Bell
Senior Member
 
Registered: Mar 2014
Location: Illinois
Distribution: Xubuntu
Posts: 2,034

Original Poster
Rep: Reputation: 176Reputation: 176
Thanks guys. It's still kind of confusing, though. Sometimes when I make changes in a .csv file and just click the save button it saves it as a .csv. Other times it gives me the popup window with the options to choose the text and field delimiters.

And there are no commas or quotation marks in any of my .csv files. And it just seems like lines separate the fields.

Second, when I experimented and changed the field and text delimiters I didn't notice any difference.

What am I missing?
 
Old 04-21-2017, 02:05 PM   #5
Turbocapitalist
LQ Guru
 
Registered: Apr 2005
Distribution: Linux Mint, Devuan, OpenBSD
Posts: 7,578
Blog Entries: 4

Rep: Reputation: 3875Reputation: 3875Reputation: 3875Reputation: 3875Reputation: 3875Reputation: 3875Reputation: 3875Reputation: 3875Reputation: 3875Reputation: 3875Reputation: 3875
The quotes only get used when there is something questionable in a cell that would confuse the parser otherwise. For example, if you have a comma separating the fields and then if you have a cell containing a comma, the quotes will be used around that cell, but probably skipped for all other cells.
 
1 members found this post helpful.
Old 04-21-2017, 02:34 PM   #6
Gregg Bell
Senior Member
 
Registered: Mar 2014
Location: Illinois
Distribution: Xubuntu
Posts: 2,034

Original Poster
Rep: Reputation: 176Reputation: 176
Quote:
Originally Posted by Turbocapitalist View Post
The quotes only get used when there is something questionable in a cell that would confuse the parser otherwise. For example, if you have a comma separating the fields and then if you have a cell containing a comma, the quotes will be used around that cell, but probably skipped for all other cells.
Thanks for the explanation, Turbo. I experimented and put some commas in the email addresses and they weren't surrounded by quotation marks but they were gray-highlighted to make them stand out.

I think for my purposes though I'm okay just going with the default (when it comes to saving the.ods as a .csv).

Appreciate your help.
 
Old 04-22-2017, 11:49 AM   #7
DavidMcCann
LQ Veteran
 
Registered: Jul 2006
Location: London
Distribution: PCLinuxOS, Salix
Posts: 6,185

Rep: Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325
I haven't tried, but I think the quotes would only be used if there was at least one numeric field. The CSV mark-up is intended for import, where the application has to know what the fields are: you can mark the text with quotes, but it's difficult to see how the numbers could be identified.
 
1 members found this post helpful.
Old 04-22-2017, 01:40 PM   #8
ondoho
LQ Addict
 
Registered: Dec 2013
Posts: 19,872
Blog Entries: 12

Rep: Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053Reputation: 6053
Quote:
Originally Posted by Gregg Bell View Post
And there are no commas or quotation marks in any of my .csv files. And it just seems like lines separate the fields.
are you sure you are looking at these csv files in a plain text editor?
 
1 members found this post helpful.
Old 04-22-2017, 01:48 PM   #9
defconmatrix
LQ Newbie
 
Registered: Aug 2012
Location: Eugene, OR
Distribution: Fedora 21
Posts: 3

Rep: Reputation: Disabled
CSV file

Quote:
Originally Posted by DavidMcCann View Post
I haven't tried, but I think the quotes would only be used if there was at least one numeric field. The CSV mark-up is intended for import, where the application has to know what the fields are: you can mark the text with quotes, but it's difficult to see how the numbers could be identified.
Provide us with a screen shot please of the CSV file's first 5 lines.
 
1 members found this post helpful.
Old 04-22-2017, 04:39 PM   #10
AwesomeMachine
LQ Guru
 
Registered: Jan 2005
Location: USA and Italy
Distribution: Debian testing/sid; OpenSuSE; Fedora; Mint
Posts: 5,524

Rep: Reputation: 1015Reputation: 1015Reputation: 1015Reputation: 1015Reputation: 1015Reputation: 1015Reputation: 1015Reputation: 1015
Considering csv stands for "comma separated variables", it's difficult to imagine a csv file without any commas.
 
1 members found this post helpful.
Old 04-23-2017, 12:54 AM   #11
Gregg Bell
Senior Member
 
Registered: Mar 2014
Location: Illinois
Distribution: Xubuntu
Posts: 2,034

Original Poster
Rep: Reputation: 176Reputation: 176
Quote:
Originally Posted by DavidMcCann View Post
I haven't tried, but I think the quotes would only be used if there was at least one numeric field. The CSV mark-up is intended for import, where the application has to know what the fields are: you can mark the text with quotes, but it's difficult to see how the numbers could be identified.
Thanks David. I think I over-complicated this. The default works just fine.
 
Old 04-23-2017, 12:54 AM   #12
Gregg Bell
Senior Member
 
Registered: Mar 2014
Location: Illinois
Distribution: Xubuntu
Posts: 2,034

Original Poster
Rep: Reputation: 176Reputation: 176
Quote:
Originally Posted by ondoho View Post
are you sure you are looking at these csv files in a plain text editor?
No, I was looking at in LibreOffice Calc.
 
Old 04-23-2017, 12:56 AM   #13
Gregg Bell
Senior Member
 
Registered: Mar 2014
Location: Illinois
Distribution: Xubuntu
Posts: 2,034

Original Poster
Rep: Reputation: 176Reputation: 176
Quote:
Originally Posted by defconmatrix View Post
Provide us with a screen shot please of the CSV file's first 5 lines.
I really can't because it has people's email addresses. I'm pretty satisfied with the default anyway and am going to mark this thread as solved.
 
Old 04-23-2017, 12:57 AM   #14
Gregg Bell
Senior Member
 
Registered: Mar 2014
Location: Illinois
Distribution: Xubuntu
Posts: 2,034

Original Poster
Rep: Reputation: 176Reputation: 176
Quote:
Originally Posted by AwesomeMachine View Post
Considering csv stands for "comma separated variables", it's difficult to imagine a csv file without any commas.
I thought so too! But the ones with the email addresses only have:

1)The email address
2) The first name
3) The last name.

Hence no commas anywhere.
 
Old 04-23-2017, 12:59 AM   #15
Gregg Bell
Senior Member
 
Registered: Mar 2014
Location: Illinois
Distribution: Xubuntu
Posts: 2,034

Original Poster
Rep: Reputation: 176Reputation: 176
Calling this one solved. I was over-analyzing this. The default is working fine for me.
 
  


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
Converting delimited file to csv or excel file - column wise Vthimmap Linux - Newbie 17 03-22-2016 05:32 AM
Libreoffice Calc vs Excel speed question redart Linux - Software 17 11-15-2015 08:25 PM
[SOLVED] LibreOffice calc quick question timl Linux - Software 5 09-17-2014 06:37 AM
[SOLVED] Parsing text file with passwords and converting to CSV list Jumpingmushroom Programming 10 04-15-2013 04:11 AM
Libpe Ofc Calc won't open spreadsheets in ods and xls formats jdtiede Linux - Software 1 11-02-2011 10:00 AM

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

All times are GMT -5. The time now is 01:13 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
Open Source Consulting | Domain Registration