How to export data from Chrome developer tool?

C

14

187

Network analysis by Chrome when page loads

I would like to export this data to Microsoft Excel so that I will have a list of similar data when loaded at different times. Loading a page one time doesn't really tell me much especially if I want to compare pages.

Coal answered 22/9, 2011 at 21:51 Comment(1)

See also step by step: confluence.atlassian.com/kb/… – Soukup 6/12, 2016 at 11:21

Y

116

if you right click on any of the rows you can export the item or the entire data set as HAR which appears to be a JSON format.

It shouldn't be terribly difficult to script up something to transform that to a csv if you really need it in excel, but if you're already scripting you might as well just use the script to ask your questions of the data.

If anyone knows how to drive the "load page, export data" part of the process from the command line I'd be quite interested in hearing how

Yolk answered 26/7, 2012 at 3:23 Comment(6)

Surprisingly, chrome's network save to HAR saved ALL the data and not only the item – Matteroffact 17/6, 2017 at 8:34

This does not appear to work with localhost sourced requests. – Plutocracy 29/3, 2018 at 16:59

I highly recommend the tool jq (stedolan.github.io/jq), a command line JSON processor. For example, you could extract the requested urls from a HAR json file with the command cat har-log.json | jq '.log.entries[].request.url' -r – Twowheeler 18/2, 2019 at 23:36

Chrome can now import a HAR file directly into the Network tab for analysis. – Tormentil 17/12, 2019 at 20:33

HARs truncate at 100,000 bytes – Sergent 28/7, 2020 at 20:3

I used this tool hintdesk.github.io/networkhartocsv/input that I got from this answer: #31648578. It works very well. – Signorino 6/10, 2021 at 18:16

C

101

from Chrome 76, you have Import/Export buttons.

Congdon answered 16/8, 2019 at 2:27 Comment(1)

This still just exports a HAR file, same as right-clicking. You still have to somehow process the JSON and extract the file you're after. – Disinclined 8/7, 2021 at 15:8

C

33

I was trying to copy the size data measured from Chrome Network and stumbled on this post. I just found an easier way to "export" the data out to excel which is to copy the table and paste to excel.

The trick is click Control + A (select all) and once the entire table will be highlighted, paste it to Microsoft Excel. The only issue is if there are too many fields, not all rows are copied and you might have to copy and paste several times.

UPDATED: I found that copying the data only works when I turn off the filter options (the funnel-looking button above the table). – bendur

Cairo answered 16/3, 2015 at 2:49 Comment(10)

This is actually the easiest way. You can get around the "too many fields" problem by zooming the browser out (CTRL +/-). It doesn't matter if the text is too small to read, it will copy/paste into excel at normal size. – Preconception 14/4, 2015 at 14:13

did select all, but did copy only the visible files (in the scrollpane), I don't know why... :/ – Turnspit 15/1, 2016 at 13:37

you can play with columns if you right click on them so you can have more data than the default – Pontificate 25/10, 2016 at 7:37

I'm unable to get Ctrl-A to work, but I can use the mouse, start at a column towards the left, and highlight by clicking and dragging up. fyi, ymmv, tisla. – Patio 24/5, 2017 at 16:29

@dubj, CalebC, why not just export as HAR and view at softwareishard.com/har/viewer – Punchball 11/10, 2017 at 5:38

@ruffin, Yea, but still it doesn't have the content.. just the rows – Punchball 11/10, 2017 at 5:39

@Punchball I found that copying the data only works when I turn off the filter options (the funnel-looking button above the table). – Stomy 8/11, 2017 at 22:48

calebc you should add @bendur's comment to your answer – Rucksack 4/9, 2019 at 9:13

@Rucksack Done, I'm surprised its almost 4-5 years ago I posted this answer – Cairo 5/9, 2019 at 11:29

and yet still very relevant :) – Rucksack 5/9, 2019 at 15:13

F

27

Right-click and export as HAR, then view it using Jan Odvarko's HAR Viewer

This helps in visualising the already captured HAR logs.

Felly answered 27/11, 2013 at 6:42 Comment(1)

You can also re-import the HAR files into the developer tools (works with Firefox, too). – Shambles 10/9, 2021 at 9:32

S

10

In Chrome, in the Developer Tools, under Network, in the Name column, right-click and select "Save as HAR with content". Then open a new tab, go to https://toolbox.googleapps.com/apps/har_analyzer/ and open the saved HAR file.

Sheeran answered 2/10, 2018 at 13:57 Comment(0)

B

8

I came across the same problem, and found that easier way is to undock the developer tool's video to a separate window! (Using the right hand top corner toolbar button of developer tools window) and in the new window , simply say select all and copy and paste to excel!!

Blodget answered 9/4, 2015 at 12:2 Comment(0)

P

6

Note that ≪Copy all as HAR≫ does not contain response body.

You can get response body via ≪Save as HAR with Content≫, but it breaks if you have any more than a trivial amount of logs (I tried once with only 8k requests and it doesn't work.) To solve this, you can script an output yourself using _request.contentData().

When there's too many logs, even _request.contentData() and ≪Copy response≫ would fail, hopefully they would fix this problem. Until then, inspecting any more than a trivial amount of network logs cannot be properly done with Chrome Network Inspector and its best to use another tool.

Punchball answered 11/10, 2017 at 20:57 Comment(0)

S

4

You can use fiddler web debugger to import the HAR and then it is very easy from their on... Ctrl+A (select all) then Ctrl+c (copy summary) then paste in excel and have fun

Sotted answered 2/11, 2015 at 12:48 Comment(2)

fiddler web debugger ?? – Punchball 11/10, 2017 at 5:40

In Fiddler Classic you can select "Import sessions" from the File menu, then select HTTPArchive as the import format to import the .har files. – Frenzied 9/3, 2022 at 13:19

E

4

I don't see an export or save as option.

I filtered out all the unwanted requests using -.css -.js -.woff then right clicked on one of the requests then Copy > Copy all as HAR

Then pasted the content into a text editor and saved it.

Errolerroll answered 31/7, 2018 at 6:39 Comment(1)

I used this approach, it worked like charm. I want to add to the answer; the content when you paste in text editor is a json file. In fact I used powershell to parse the json and further study the request redirections (in my case). – Decoder 15/11, 2019 at 11:35

O

2

In more modern versions of Chrome you can just drag a .har file into the network tab of Chrome Dev Tools to load it.

Oilcloth answered 9/10, 2017 at 14:13 Comment(1)

I'd think he wanna export? – Punchball 11/10, 2017 at 5:32

K

1

I had same issue for which I came here. With some trials, I figured out for copying multiple pages of chrome data as in the question I zoomed out till I got all the data in one page, that is, without scroll, with very small font size. Now copy and paste that in excel which copies all the records and in normal font. This is good for few pages of data I think.

Kinelski answered 21/3, 2017 at 12:40 Comment(0)

T

0

To get this in excel or csv format- right click the folder and select "copy response"- paste to excel and use text to columns.

Tauromachy answered 4/9, 2019 at 2:39 Comment(0)

F

0

You can try use Haiphen, which is a chrome extension that allows you to analyze network traffic and what API calls a web application is making.

Frondescence answered 5/12, 2021 at 2:10 Comment(0)

N

0

Google Chrome version 116 can export the waterfall data at the Network tab by using "Export HAR" feature

The result is HAR file, which you can open and analyze using Google HAR Analyzer https://toolbox.googleapps.com/apps/har_analyzer/

Nemato answered 4/9, 2023 at 11:58 Comment(0)

Recommended topics

Hot tags