Data - Excel vs Google Sheets
The limitations of using Excel as a data source are well known. If we want to store data in spreadsheets, how does Google Sheets compare? In this post, we'll walk through how to connect to a Google Sheets, and find out whether the Google Sheets connector applies the same file and row size limits as the Excel connector.
Recent Posts
- Designer - 3 Features you may have missed in the screen designer
- Controls - How to set default control and form values
- Controls - How to reset or clear data entry controls, and form values
- What features will soon be available to better protect access to data?
- Portal - How to define section layouts with four, five, or six columns?
- Formulas - The Power Apps canvas app language now has a name!
- What does it take to become a Microsoft Partner that specialises in the Power Platform?
- COVID-19 - How schools can use the "Return to School" app to resume operations
- Model driven apps - 3 use case scenarios of how to set default record values
- Why is Microsoft 365 licensing so confusing?
- SQL - How to show distinct values in the most efficient way
- Formula - How to create comma separated (CSV) list of items
- Formulas - How to hack complex date calculations
- Dataverse - how to access tables from another environment
- Data - Excel vs Google Sheets
- Functions - How to create and use 'user defined functions'
- Power Virtual Agents - How to build and publish a basic chatbot
- Tip - Minimise your Power Platform licensing costs
- Formulas - Generating Row Numbers - Part 3
- General - How to update Office 365 profile details from an app
- General - What happens when we raise a support ticket?
- General - The easiest way to convert phone apps to tablet apps
- Connectors - How to display lists of apps from within an app
- Code - How to define a read-only table of static data
- Formula - How to use the IF and Switch functions - 3 common examples