How to transfer QVD back to excel if the document size is quite big?

[#1]

as mentioned.

Thanks!

[Gysbert_Wassenaar · Accepted solution]

Qvd files are the most efficient when storing and loading data. If you really want you can store data in csv format, which excel can read. The store command can output to csv. See the help file for details.

[#3]

Store (tablename) into (path.csv) (CSV);

Try that

[#4]

This is because I do not see any method to edit QVD directly,cause sometimes we dont' have the orginal data but it might need to be revised.

[erichshiino]

It's almost this:

Store tablename into filename.csv (txt);

Regards,

Erich

[rustyfishbones]

Hi Felix,

Here ia an example of how I done this with some YouTube Data I had in a QVD file and I needed to Store back into a CSV file, the important part is (txt, Delimiter is ',');

Youtube:

LOAD Geography,

     Continent,

     Date,

     Views,

     [Monetizable views],

     [Unique cookies],

     [Estimated minutes watched]

FROM

(qvd);

Store Youtube into

(txt, delimiter is ',');

Hope it helps

Rusty