All Apps and Add-ons

Why Splunk for Excel Export does not export and show full list of logs in Excel sheet?

New Member

Hii,all

i am having issue with excel export. when i am searching in splunk search head i am getting full logs. then i try to export those logs to excel,
i am getting less logs .i am not understanding what is the problem i am new to splunk..
the logs count is 149,690
the exported excel sheet contains a 65,000
i try to download in 2 sheets based on time . still i am not getting full logs in excel.. pls help me ..... it urgent requirement from client side.....
pls help me .....

thanks in advance .

0 Karma
1 Solution

Builder

As @martin_mueller mentioned, older Excel versions have a limit of ~65,000 rows; Excel 2007+ has a row limit of ~1,000,000.

View solution in original post

Builder

As @martin_mueller mentioned, older Excel versions have a limit of ~65,000 rows; Excel 2007+ has a row limit of ~1,000,000.

View solution in original post

New Member

ya man..

i got it...

thank u very much..

0 Karma

New Member

i am using 2013 ms office

0 Karma

SplunkTrust
SplunkTrust

Did you check the other worksheets in the .xls? Anything beyond 65000 is moved to splunk_results_2, splunk_results_3, etc.

New Member

first i tried to run 24 hours that time i am getting full logs in search head and less logs in excel imported sheet ,after i tried to run 12 hours ,that time it showing the wrong log count in splunk search head. thats why i am in dilema

0 Karma

SplunkTrust
SplunkTrust

I remember there was a limit in Excel to only handle 65535 rows.

0 Karma