How to do CSV?

Doug Easterbrook doug at
Mon Nov 13 00:39:32 UTC 2023

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
Phone (403) 650-1978

> On Nov 12, 2023, at 8:06 AM, Das Goravani <goravanis at> 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
> Start a new message -> mailto:omnisdev-en at

More information about the omnisdev-en mailing list