# Table Metadata export to Excel
**URL:** https://community.easyqlik.com/t/table-metadata-export-to-excel/21
**Category:** Uncategorized
**Created:** [June 12, 2020, 2:59pm UTC](https://community.easyqlik.com/t/table-metadata-export-to-excel/21 "2020-06-12T14:59:23Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Marty](https://community.easyqlik.com/u/Marty)
#### Post date: [June 12, 2020, 2:59pm UTC](https://community.easyqlik.com/t/table-metadata-export-to-excel/21/1 "2020-06-12T14:59:23Z")
It would be great on the Table Metadata view to be able to export straight to Excel.
---
### Author:  [@rob](https://community.easyqlik.com/u/rob)
#### Post date: [June 14, 2020, 12:01am UTC](https://community.easyqlik.com/t/table-metadata-export-to-excel/21/2 "2020-06-14T00:01:49Z")
This should be doable. Let me take a look and I’ll give you a timeframe.
---
### Author:  [@Marty](https://community.easyqlik.com/u/Marty)
#### Post date: [June 15, 2020, 3:06pm UTC](https://community.easyqlik.com/t/table-metadata-export-to-excel/21/3 "2020-06-15T15:06:54Z")
Thanks Rob - no rush.
Probably in a similar vein…could the Excel exports from the other parts of the application be “flattened” rather than grouped? (attached) - I’m dealing with qvd extracts of 500+ tables and would be processing the metadata either through a metadata scanner and/or excel. (I’m not that smart in Excel to unwind the groupings 😉)
---
### Author:  [@rob](https://community.easyqlik.com/u/rob)
#### Post date: [June 16, 2020, 9:38pm UTC](https://community.easyqlik.com/t/table-metadata-export-to-excel/21/4 "2020-06-16T21:38:55Z")
I’ll consider the flattened idea. In the meantime, here’s a Qlik script to split the grouped xlsx into Files and Fields tables.
```
// Script to load a "File and Detail" xlsx exported from QViewer.
// Load all rows, assigning a Key to each file and flag each row as either File/Field.
Files:
LOAD
if(IsNum(Rows), Folder & '/' & [File Name], Peek('Key')) as Key,
if(IsNum(Rows), 'File', 'Field') as RowType,
[Table Name],
Fields,
Rows,
[File Name],
Folder,
Modified,
[File Size],
Creator,
Comment as [Table Comment]
FROM
[C:\temp\qvdlist2.xlsx] // your export filename
(ooxml, embedded labels, table is Sheet1)
;
// Load the Fields into a table.
Fields:
LOAD
Key,
[Table Name] as [Field Name],
Fields as [Unique Values],
Rows as [Field Comment],
[File Name] as Tags
Resident Files
Where RowType = 'Field'
and [Table Name] <> 'Field Name'
;
// Keep only the File rows in the Files table.
Inner Join(Files)
LOAD 'File' as RowType
AutoGenerate 1;
Drop Field RowType;
```
---
### Author:  [@Marty](https://community.easyqlik.com/u/Marty)
#### Post date: [June 17, 2020, 2:22pm UTC](https://community.easyqlik.com/t/table-metadata-export-to-excel/21/5 "2020-06-17T14:22:15Z")
That was very kind of you to provide the code. Good old PEEK fn.
Thanks Rob!
---
### Author:  [@rob](https://community.easyqlik.com/u/rob)
#### Post date: [June 24, 2020, 3:54pm UTC](https://community.easyqlik.com/t/table-metadata-export-to-excel/21/6 "2020-06-24T15:54:47Z")
Export Table Metadata to Excel has been delivered in the 4.1.2 update.
---
### Author:  [@Marty](https://community.easyqlik.com/u/Marty)
#### Post date: [June 25, 2020, 7:40pm UTC](https://community.easyqlik.com/t/table-metadata-export-to-excel/21/7 "2020-06-25T19:40:45Z")
Fantastic! thanks…look forward to using it. (Maybe after QlikWorld sessions)
Martin.