How to do CSV?

[Doug Easterbrook]

if the end result is to have the data in excel, why not export directly to Excel???

there is a great xcomp to do it (excelFormat - which is free).       you can set fonts, color, pick your row and column,  or just export a list directly with headers.     Gets you XLS and XLSX format.   All you need do is 

1) load your list
2) pick your file name
3) export the list directly.


you do not need excel on your machine.    People on mac’s can open in numbers.  or you can open in OpenOffice.




One minor note.. there is a one time licence fee of $199 for the guys that wrote the base libraries.    




Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug at artsman.com
http://www.artsman.com
Phone (403) 650-1978

> On Nov 12, 2023, at 8:06 AM, Das Goravani <goravanis at gmail.com> wrote:
> 
> 
> Dear Listers, 
> 
> I am working with the latest 10.22 on Mac. On Sonoma. 
> 
> I am exporting a report to disk. I want CSV format, that will open in a spreadsheet correctly… one column per column. 
> 
> I am exporting in comma separated way. But everything is coming up in the first column of the spreadsheet. 
> 
> I have a feeling I need quotes around each column in the output.
> 
> How do you turn on that it should have quotes?
> 
> Or how do you export CSV? In other words?
> 
> Thank you,
> 
> Das Goravani
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com