How to open CSV as Spreadsheet in Calc

Discuss the spreadsheet application

How to open CSV as Spreadsheet in Calc

Postby hoookieee » Thu May 02, 2019 6:21 am

I have a CSV file that looks like this in Gmail:
I downloaded the CSV and tried to open with Calc
This window opens
And this is what the file looks like
I was wondering if it is possible to open the sheet and make it look the same way it does in Gmail?
Open OFfice 4.1.2 on Windows 10
Posts: 1
Joined: Thu May 02, 2019 6:12 am

Re: How to open CSV as Spreadsheet in Calc

Postby Zizi64 » Thu May 02, 2019 7:10 am

The appeared panel is the IMPORT FILTER. It is for the text based data files, what may has many various settings.
You must adjust the settings of the import filter:

- the data separator character/s/,
- the text delimiter characters,
- the locale of the date type columns
- etc...

Then the file will be appeared in the Calc as you expected.

In this case choose the Comma as Data separator character.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.3.4; AOO4.1.6
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
Posts: 8682
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Return to Calc

Who is online

Users browsing this forum: No registered users and 10 guests