topic Re: Converting Table Object into csv format in QlikView

Converting Table Object into csv format

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I am trying to convert by my table object into csv format. I exported my table into csv format but when I open my csv file, the data is not being displayed in one line. Rather it looks like a table only even though the file is saved in .csv format. Dont know what's happening.

Please Help!

Re: Converting Table Object into csv format

settu_periasamy — Tue, 16 Feb 2016 17:38:30 GMT

where did you check, in excel? May be check in notepad or other editor tool

Re: Converting Table Object into csv format

Tue, 16 Feb 2016 18:02:20 GMT

duh...my bad.....thanks for the solution

Re: Converting Table Object into csv format

HirisH_V7 — Tue, 16 Feb 2016 18:02:38 GMT

Hi,

Check this,

This may help you Link,

makeuseof.com/tag/how-to-convert-delimited-text-files-into-excel-spreadsheets/

HTH,

Hirish

Re: Converting Table Object into csv format

nagireddy_qv — Tue, 16 Feb 2016 18:11:11 GMT

Hi Akash,

You will have to write a macro to achieve this.

sub ExportToCSV

set tb = ActiveDocument.GetSheetObject("TB99")
tb.Export "Final.csv",",",0

end sub

Where 0 = ANSI, 1200 = Unicode, 65001 = UTF-8. You might need ServerSideExport or ServerSideExportEx on a server.

Re: Converting Table Object into csv format

settu_periasamy — Wed, 17 Feb 2016 01:54:57 GMT

Can you close this thread, if you got the Answer..

Re: Converting Table Object into csv format

jagan — Wed, 17 Feb 2016 02:10:31 GMT

Hi,

If you open CSV file in Excel it will display in tabular format, if you really want to see the raw data open the csv file in any Notepad software.

Hope this helps you.

Regards,

jagan.