Exporting to .xls (spreadsheets)

Imported from Yahoo
1

It it just me, or has the ability to export CSV files vanished from the program?

I tried the XML -format, but it doesn’t import to Excel correctly.

SaV

2

It has always been “Export series summary to a Windows clipboard”
Then past into an Excel spreadsheet.

Ian F
···

On 24/09/2014 16:12,
[sailwave] wrote:

sampo.valjus@gmail.com

      It it just me, or has the ability to export CSV files

vanished from the program?

      I tried the XML -format, but it doesn't import to Excel

correctly.

SaV

3

I find that if I do that, it copies all the data into one cell.

I copy the data into Notepad and save it as a *.csv file, then open that with Excel.

regards,
Malcolm Osborne
Sedgefield South Africa

···

On 2014/09/24 17:26, Ian Frogley ian.frogley@ntlworld.com [sailwave] wrote:

It has always been "Export series summary to a Windows clipboard"
Then past into an Excel spreadsheet.

Ian F

On 24/09/2014 16:12, sampo.valjus@gmail.com [sailwave] wrote:

It it just me, or has the ability to export CSV files vanished from the program?

I tried the XML -format, but it doesn't import to Excel correctly.

SaV

------------------------------------------------------------------------
<http://www.avast.com/>

This email is free from viruses and malware because avast! Antivirus <http://www.avast.com/> protection is active.

---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

4

Hi Malcom,

It works fine just pasting directly into Excel. Make sure you have the field separator set to Tab (which is the default)

Jon

···

Jon Eskdale
07976 709777

Skype “eskdale”

On 24 September 2014 16:50, Malcolm Osborne malcolmo@telkomsa.net [sailwave] sailwave@yahoogroups.com wrote:

  I find that if I do that, it copies all

the data into one cell.

  I copy the data into Notepad and save it as a *.csv file, then

open that with Excel.

regards,
Malcolm Osborne
Sedgefield South Africa

On 2014/09/24 17:26, Ian Frogley ian.frogley@ntlworld.com
[sailwave] wrote:

          It has always been "Export series summary to a Windows

clipboard"
Then past into an Excel spreadsheet.

          Ian F

On 24/09/2014 16:12, sampo.valjus@gmail.com
[sailwave] wrote:

              It it just me, or has the ability to export CSV

files vanished from the program?

              I tried the XML -format, but it doesn't import to

Excel correctly.

SaV


This email is free from viruses and
malware because avast! Antivirus
protection is active.




This email is free from viruses and malware because avast! Antivirus protection is active.

5

That is partly accurate. To get a CSV you need to Export to the
clipboard and then past into Notepad or a similar text-editing program
and save with the CSV extension. When exporting check the "Comma" box so
the field separator is a comma.

You can also paste directly into Excel (rather than create a CSV file)
but in that case you want the field separator to be a tab so check the
"Tab" box instead. You can then save that file as a CSV file (but the
Notepad method is slightly more straight-forward).

You can also publish to Excel but that is something completely different
as I believe it merely opens the standard HTML output file in Excel.

Art

···

On 9/24/2014 8:26 AM, Ian Frogley ian.frogley@ntlworld.com [sailwave] wrote:

It has always been "Export series summary to a Windows clipboard"
Then past into an Excel spreadsheet.

Ian F

On 24/09/2014 16:12, sampo.valjus@gmail.com [sailwave] wrote:

It it just me, or has the ability to export CSV files vanished from
the program?

I tried the XML -format, but it doesn't import to Excel correctly.

SaV