I have previously sought information on the forum about this tool and I'm surprised they have not commented ...
No use spreadsheets, but I found interesting tool that can provide this help someone. It is a free add-in to Microsoft Excel offers for original products, allowing to perform complex SQL queries on the sheets in the workbook.
Excel allows developer operations (VB code, scripting, macros, basic SQL) mode:
But with Power Query add-in you can (copy/paste from official MS web):
* Identify the data you care about from the sources you work with (e.g. relational databases, Excel, text and XML files, OData feeds, web pages, Hadoop HDFS, etc.).
* Combine data from multiple, disparate data sources and shape it in order to prepare the data for further analysis in tools like Excel and Power Pivot, or visualization in tools like Power View and Power Map.
More information (download, system requirements, instructions, tutorials) in:
And.. Google Spreadsheet drive has embebed SQL:
No use spreadsheets, but I found interesting tool that can provide this help someone. It is a free add-in to Microsoft Excel offers for original products, allowing to perform complex SQL queries on the sheets in the workbook.
Excel allows developer operations (VB code, scripting, macros, basic SQL) mode:
But with Power Query add-in you can (copy/paste from official MS web):
* Identify the data you care about from the sources you work with (e.g. relational databases, Excel, text and XML files, OData feeds, web pages, Hadoop HDFS, etc.).
* Combine data from multiple, disparate data sources and shape it in order to prepare the data for further analysis in tools like Excel and Power Pivot, or visualization in tools like Power View and Power Map.
More information (download, system requirements, instructions, tutorials) in:
And.. Google Spreadsheet drive has embebed SQL:
