Questions tagged [json]

JSON (JavaScript Object Notation) is a textual data storage and interchange format.

JSON (JavaScript Object Notation) is a serializable data interchange format intended to be machine and human readable.

JSON-formatted data consists of attribute-value pairs, e.g.:

{
  "firstName": "John",
  "lastName": "Smith",
  "age": 35
}
171 questions
234
votes
4 answers

Copy JSON from console.log in developer tool to clipboard?

Using Chrome Developer Tools, i have printed a JSON object with console.log. is there a way that I can copy it to the clipboard?
Anagio
  • 3,168
  • 5
  • 24
  • 29
55
votes
9 answers

How to decode/decipher Mozilla Firefox proprietary .jsonlz4 format? (sessionstore-backups/recovery.jsonlz4)

I'm trying to get a handle on Mozilla Firefox's proprietary file format .jsonlz4, used, for example, for sessionstore-backups/recovery.jsonlz4, but to no avail. How do I get back my data, specifically, some long text I've typed in some textareas of…
cnst
  • 2,615
37
votes
6 answers

Google Chrome Plugin for JSON Reading

Is there a Chrome plugin that renders JSON files in Chrome? Currently Chrome just tries to download them, and that's kind of boring.
36
votes
4 answers

How can I enable pretty-printing in Chrome manually?

There are some great Chrome extensions around for pretty-printing JSON (great SU question here: Google Chrome Plugin for JSON Reading), but they all seem to depend on detecting whether the incoming document is in a JSON format automagically. Knowing…
A. Wilson
  • 693
24
votes
2 answers

JSON Validator for Notepad++?

I'm looking for a plugin that can check the current opened file and instantly tell me whether it is valid JSON or not (eg whether there's a comma or a bracket missing) — is there any? I'm currently using JSONView on Chrome but it's a pain to always…
Mahn
  • 882
18
votes
2 answers

How to navigate to position in Notepad++

I would like to navigate to position in text file. Not line number, but character position. Absolute character position from the beginning of file. How to do this in Notepad++? Any other plain text editor is ok. I am editing JSON file.
Dims
  • 13,414
16
votes
2 answers

How can I set Chrome (and Brave) to _always_ pretty-print JSON results without installing an extension?

I visit JSON endpoints that look like: https://dummyjson.com/test I don't want to manually click the "Pretty-print" checkbox every time. How can I change a browser setting to make the "Pretty-print" checkbox checked by default without installing…
Ryan
  • 2,388
13
votes
2 answers

Can a file system's logical structure (including symlink targets) be represented in a single lightweight file (non-binary)?

After playing with multiple SQL and NoSQL databases over the years I feel the best way for me to ensure portability in my personal apps that are data-centric is to avoid all bonafide databases entirely. I see the file system as a beautiful database…
11
votes
2 answers

parsing json in bash with pipe operators

I'm using the AWS CLI client to get the status of a snapshot but the output is in JSON. eg. { "DBClusterSnapshots": [ { "AvailabilityZones": [ "us-east-2a", "us-east-2b", …
neubert
  • 7,574
  • 39
  • 94
  • 156
11
votes
3 answers

Can't import JSON in Excel 2016 using "Get & Transform" feature

According to Microsoft's documentation I should be able to import JSON files by: Click the Data tab, then Get Data > From File > From JSON.
Gabriel Fair
  • 4,093
11
votes
6 answers

Saving Excel sheet as JSON file

Is there a simple way to convert a simple excel sheet to a JSON file? For example the source sheet could look like: A B 1 firstName age 2 Alice 22 3 Bob 33 and the saved JSON: [{firstName: 'Alice', age: 22}, {firstName:…
10
votes
1 answer

Extract element from JSON array with jq

I have the following JSON file inp.json: { "x": 0, "tx": [ { "id": "a", "t" : "t for a" }, { "id": "b", "t": "t for b" } ] } I would like to extract the value of the first occurance of the key "t" within "tx". I tried jq…
9
votes
1 answer

Loading a json file into Power Query

I am trying to load a JSON file I pulled from data.gov into Power Query for manipulation, but I can't figure out how to get Power Query to convert the JSON file to a tabular format. Is there a way to convert JSON to a table in Power Query without…
8
votes
3 answers

Import json data into Excel

I have a text file in json format and want to read it into Excel. A very simplified example of the json file has the following structure: { [ { 'a': 10, 'b': 20 }, { 'a': 20, 'b': 22 }, { 'a': 11, 'b': 24 } ] } I want to convert it to Excel…
7
votes
4 answers

Extracting a list of values from JSON file to Excel or a text file

I want to extract usernames from a JSON data file. [{"username": "Cobra", "user_id": 146231486, "event_type": 2, "title": null, "class_id": 4211, "war_state" : null, "superpower_expire_date": 1441178060.0, "role": 3, "event_state": 2, "avatar_id":…
WR20
  • 71
1
2 3
11 12