Skip to main content

CData Connect Spreadsheets

Share product questions and get support for CData Connect Spreadsheets

  • 9 Topics
  • 10 Replies
9 Topics
E
EugeneApprentice
asked in CData Connect Spreadsheets
Connect Spreadsheets to Sage in South Africa

I am trying to setup Connect Spreadsheets to Sage One (renamed to Sage Business Cloud Accounting) but when I want to setup the authentication via the basic setup I don’t get South Africa as a region and can therefor not authenticate to our company in Sage. Any assistance would be appreciated. 

261
Ethem Q
J
JDBApprentice
asked in CData Connect Spreadsheets
Connect Spreadsheets Error - exception: service spreadsheets timed out while accessing document with id

Connected to Sage Intacct data via Google Sheets.  When processing a basic query of 15 fields (no formulas) I receive this error after about 136,000+ rows.  This ran fine in MS Excel.  I’ve set Timeout to 0 but the issue persists.  Are there other Advanced Settings that should be changed to allow for up to 250,000 rows to load?

481
Ethem Q
D
DoctorApprentice
asked in CData Connect Spreadsheets
Functionality of Connect Spreadsheets

Greetings,I am in the process of creating an advice report to a corporate client who is interested if CData Connect Spreadsheet is a right tool for her needs.The following features are required:Load data from multiple backend Excel spreadsheets to a report sheet in Excel. Update the report sheet and push updates to the backend sheets if needed. Create joins using backend spreadsheets and display them in the report in Excel.  Joins should be created in GUI without using SQL queries. Do you think these objectives can be effectively achieved using CData add-in for Excel? Thanks,Eugene

873
A
Kellyh
KellyhEmployee
posted in CData Connect Spreadsheets
Spreadsheets Free Subscription Renewal Payment Email

Hello!  If you are on a free Spreadsheets plan every month you are receiving an email that states you may need to update your billing information.  Remember that your subscription is FREE and that you are not required to have payment details on file. However, due to regulations we need to send out a reminder that you are on an auto renewal and we have our emails worded the same for all our renewal emails if you are paying or not at this time.  Sorry if it has confused you. 

481
adamfinch
C
CDataBillyEmployee
posted in CData 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!

220
C
T
TrenaATApprentice
asked in CData 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?

531
C
A
Anonymous
posted in CData 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

630
A
A
Anonymous
posted in CData 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.  

763
A
A
Anonymous
posted in CData 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,

420
A
CData MCP Servers

Badge winners

Show all badges
Terms and ConditionsCookie settings