Database Reference
In-Depth Information
When you connect for the first time, Excel will also prompt you for your storage account key. Enter that key and
click on
Save.
Click on
Edit Query
to load the
Query Editor
screen, where you can specify your filter criteria. Expand
the drop-down list under the
Name
column, and filter only the rows that have
.csv
files, as shown in Figure
9-25
.
Figure 9-25.
Filtering .csv files
Click on
OK,
and then click the
Binary
link under the
Content
column in Figure
9-25
. Doing so will load the data
from the .
csv
file into the
Query Editor
. You can rename the columns to more meaningful names before importing
them into the Excel worksheet, as illustrated in Figure
9-26
.
Figure 9-26.
Formatting the data