[Solved] CSV import problem

Discuss the spreadsheet application

[Solved] CSV import problem

Postby iso2000 » Sun Aug 02, 2020 1:36 pm

I have a problem viewing CSV files (comma delimited). When I import them, even if I choose "comma" as a delimiter, the output is not only wrong, but unreadable. Is there anything specific to CSV files for OpenOffice?
Last edited by MrProgrammer on Sun Aug 02, 2020 10:43 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
OpenOffice 4 for Mac
iso2000
 
Posts: 3
Joined: Sun Aug 02, 2020 12:54 pm

Re: csv import problem

Postby Zizi64 » Sun Aug 02, 2020 2:37 pm

Is there anything specific to CSV files for OpenOffice?

There is not. These are simple text files (textual data with a specific character as delimiter between the data values.
Maybe the character encoding is different. Have you tried to change the decoding parameter on the filter panel?

Can you upload a sample .csv file here?
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9724
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: csv import problem

Postby RoryOF » Sun Aug 02, 2020 2:58 pm

Also, have you tried opening the CSV file with a plain text editor to verify that it is in fact saved in plain text?
Apache OpenOffice 4.1.9 on Xubuntu 20.04.1 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 32181
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: csv import problem

Postby iso2000 » Sun Aug 02, 2020 3:01 pm

Thanks, guys!

It was a pretty big file, however, the encoding was the problem. Why I couldn't understand was the output, which was totally unreadable.

Solved!
OpenOffice 4 for Mac
iso2000
 
Posts: 3
Joined: Sun Aug 02, 2020 12:54 pm

Re: csv import problem

Postby iso2000 » Sun Aug 02, 2020 3:05 pm

RoryOF wrote:Also, have you tried opening the CSV file with a plain text editor to verify that it is in fact saved in plain text?


It is a valid csv (value,value1,value2 etc) but the encoding errors were not shown in particular cells, but as a whole document. It looked like I was opening a JPEG with Calc.
OpenOffice 4 for Mac
iso2000
 
Posts: 3
Joined: Sun Aug 02, 2020 12:54 pm

Re: csv import problem

Postby RoryOF » Sun Aug 02, 2020 4:58 pm

Without a sample file we can only guess.
Apache OpenOffice 4.1.9 on Xubuntu 20.04.1 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 32181
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: csv import problem

Postby Villeroy » Sun Aug 02, 2020 8:29 pm

Open some csv file and when the import dialog pops up, focus the encodings list box and navigate through different encondings watching the preview. Some use 8 bit, others use 16 bit per character, some 8 bit encodings are made for Asian languages.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 29279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 21 guests