如何从Chrome开发者工具导出数据?

发布于 2024-12-05 19:05:10 字数 241 浏览 1 评论 0原文

输入图像描述这里

页面加载时由 Chrome 进行网络分析

我想将此数据导出到 Microsoft Excel,以便在不同时间加载时获得类似数据的列表。加载一次页面并不能真正告诉我太多信息,尤其是当我想比较页面时。

enter image description here

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.

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(14

蓝眼泪 2024-12-12 19:05:10

如果右键单击任何行,您可以将项目或整个数据集导出为 HAR(看起来是 JSON 格式)。

如果您确实需要在 Excel 中编写一些脚本来将其转换为 csv,那么编写脚本应该不会太困难,但如果您已经编写了脚本,那么您也可以使用脚本来询问数据问题。

如果有人知道如何从命令行驱动该过程的“加载页面,导出数据”部分,我很想听听如何

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

话少情深 2024-12-12 19:05:10

Chrome 76 开始,您有导入/导出按钮。

输入图像描述这里

from Chrome 76, you have Import/Export buttons.

enter image description here

忘年祭陌 2024-12-12 19:05:10

我试图复制从 Chrome 网络测量的尺寸数据,并偶然发现了这篇文章。我刚刚找到了一种更简单的方法将数据“导出”到 Excel,即复制表格并粘贴到 Excel。

诀窍是单击 Control + A(全选),一旦整个表格突出显示,将其粘贴到 Microsoft Excel。唯一的问题是,如果字段太多,则并非所有行都会被复制,您可能需要多次复制和粘贴。

更新:我发现只有当我关闭过滤器选项(表格上方的漏斗状按钮)时,复制数据才有效。 – 本杜尔

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

债姬 2024-12-12 19:05:10

右键单击并导出为 HAR,然后使用Jan Odvarko 的 HAR 查看器查看它,

这有助于可视化已捕获的内容HAR 日志。

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

This helps in visualising the already captured HAR logs.

在巴黎塔顶看东京樱花 2024-12-12 19:05:10

在 Chrome 中,在开发人员工具的“网络”下的“名称”列中,右键单击并选择“另存为包含内容的 HAR”。然后打开一个新标签页,转到 https://toolbox.googleapps.com/apps/har_analyzer/ 并打开保存的 HAR 文件。

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.

握住我的手 2024-12-12 19:05:10

我遇到了同样的问题,发现更简单的方法是将开发人员工具的视频取消停靠到单独的窗口! (使用开发人员工具窗口右上角的工具栏按钮)
在新窗口中,只需说全选并复制并粘贴到 Excel!

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!!

也只是曾经 2024-12-12 19:05:10

请注意,不包含响应正文。

您可以通过“Save as HAR with Content”获取响应正文,但是如果您的日志量超过微不足道的数量,它就会中断(我尝试过一次,仅使用 8k 请求,但不起作用。)要解决此问题,您可以使用 _request.contentData()

当日志太多时,即使_request.contentData()和<复制响应>也会失败,希望他们能解决这个问题。在此之前,使用 Chrome Network Inspector 无法正确检查少量网络日志,最好使用其他工具。

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.

眸中客 2024-12-12 19:05:10

您可以使用 fiddler Web 调试器导入 HAR,然后从他们开始就非常容易... Ctrl+A(全选)然后 Ctrl+c(复制摘要)然后粘贴到 excel 中并享受乐趣

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

烟织青萝梦 2024-12-12 19:05:10

我没有看到导出或另存为选项。

我使用 -.css -.js -.woff 过滤掉所有不需要的请求,然后右键单击其中一个请求,然后复制 > > 全部复制为 HAR

然后将内容粘贴到文本编辑器中并保存。

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.

昵称有卵用 2024-12-12 19:05:10

在更现代的 Chrome 版本中,您只需将 .har 文件拖到 Chrome 开发工具的网络选项卡中即可加载它。

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

娇俏 2024-12-12 19:05:10

我来这里也是为了同样的问题。经过一些试验,我发现复制多页 chrome 数据就像在问题中一样,我缩小了直到将所有数据都放在一页中,即没有滚动,字体大小非常小。现在将其复制并粘贴到 Excel 中,该 Excel 会复制所有记录并以正常字体显示。
我认为这对于几页数据来说很有用。

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.

祁梦 2024-12-12 19:05:10

Google Chrome 版本 116 可以使用“导出 HAR”功能在“网络”选项卡中导出瀑布数据

在此处输入图像描述

结果是 HAR 文件,您可以使用 Google HAR 分析器打开并分析该文件 https://toolbox.googleapps.com/apps/har_analyzer/

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

enter image description here

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

盗梦空间 2024-12-12 19:05:10

要以 Excel 或 csv 格式获取此内容 - 右键单击​​文件夹并选择“复制响应” - 粘贴到 Excel 并在列中使用文本。

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

冰雪之触 2024-12-12 19:05:10

您可以尝试使用 Haiphen,这是一个 chrome扩展允许您分析网络流量以及 Web 应用程序正在执行的 API 调用。

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.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文