Skip to main content

Connect Spreadsheets

Connect Spreadsheets

  • 5 Topics
  • 4 Replies
5 Topics
C
CDataBillyEmployee
posted in Connect Spreadsheets
What reports are you building in spreadsheets?

Hello Connect Spreadsheets community!  What kinds of reports are you connecting data to and building in Excel and Google Sheets using Connect Spreadsheets? We are looking for feedback and ideas of what reports we can standardize to come prebuilt in templates, ready to fill with data, in Connect Spreadsheets, to make it easier for users to get the report they want. Whether it’s P/L statements, sales reports, or something else, let us know and your idea may be chosen to make building your reports easier!

60
C
5 days ago
T
TrenaATApprentice
asked in Connect Spreadsheets
Connect Excel from SharePoint

Hi, I need to use cdata to bring in data from excel docs saved in a SharePoint folder. I previously build the report using the SharePoint folder link but now i need to change to use the cdata. Right now, my option is to bring in the files as individual tables but i want to automate the process. The automation in place, combines the files and brings in only 1 table into powerbi. When a new file is added to that sharepoint folder, i can simply refresh in powerbi and data from the new file will be uploaded. Is it possible to do this using cdata?

241
C
6 days ago
John
JohnCommunity Manager
posted in Connect Spreadsheets
Connect Spreadsheets Frequently Asked Questions

 Q: How do I install Connect Spreadsheets? Select your preferred spreadsheet, where you’ll be directed to install the add-in for Google Sheets or Excel in their add-in marketplaces. Then, open your spreadsheet and launch Connect Spreadsheets. You’ll be prompted to sign up for a Connect Spreadsheets account. Finally, sign in and start connecting data to your spreadsheet.  Q: Is there a free trial? All accounts start on a 15-day free trial of the unlimited Pro plan. Purchase a paid plan before your trial ends to convert automatically and never lose access to the unlimited benefits of Connect Spreadsheets.  Q: What are the limits if I stay on the free plan? Continue to use Connect Spreadsheets free forever, no credit card required, but after your 15-day free trial you’ll be limited to only 5,000 records per query, 1 user, 3 data sources, and 50 total queries per month. Upgrade to a paid plan to connect data with more users, remove size limits from the data you pull, and query as often as

110
John
6 days ago
John
JohnCommunity Manager
posted in Connect Spreadsheets
Connect Spreadsheets by CData - Video

  Connect Spreadsheets is the easiest way to get all your live data into Microsoft Excel or Google Sheets – no more downloading, wrangling, and uploading files again. Just connect to your data, select the dataset you’d like to see, and import it into your spreadsheet.  

353
A
20 days ago
John
JohnCommunity Manager
posted in Connect Spreadsheets
CData Connect Spreadsheets: Bringing Seamless Data Connectivity to Your Spreadsheets

Introducing Connect Spreadsheets, CData’s latest offering for effortless data access in Excel and Google Sheets. What is Connect Spreadsheets? Connect Spreadsheets is a free tool that connects your spreadsheets to data from 250+ sources without any of the usual hassle. Instead of exporting and copying data manually, simply connect once and access fresh data with a click or on a set schedule. No coding is needed, and it’s available right now on Google Workspace Marketplace and Microsoft AppSource. Who is it for? Connect Spreadsheets is for anyone who works in Google Sheets or Excel and needs live data without the extra steps of downloading, importing, or reformatting. From finance teams to analysts and everyday spreadsheet users, anyone can now enjoy data that’s connected, current, and completely under your control. Why Connect Spreadsheets? Spreadsheets have always been one of the most widely used data tools. Connect Spreadsheets embraces this, enabling teams to use the data they need,

170
John
21 days ago
Virtual Event: Data Virtualization, Reimagined Ma”arch 14, 2024 style=

Badge winners

Show all badges
Terms and ConditionsCookie settings