How to import all columns from a JSON when not all the objects have the same keys

Anonymous , 

Here are a few steps you can follow.

1. Load JSON: Go to Data > Get Data > From File > From JSON and load your file.
   
   

2. Convert to Table: Click To Table in Power Query.
   
   

3. Expand Columns: Use the Expand Column button (next to the column name). Missing keys will appear as null.
   
   

4. Handle Missing Keys: If a key (e.g., ciudad) is not in all objects, it will still create a column with null for missing values.
   
   

5. Load to Excel: Click Close & Load to return the data to Excel.
   
   

This ensures all potential columns are imported, including those with missing keys.