people
User Permissions
Build once, share widely. Flex.io enables you to create teams, manage users, set permissions, and limit the spreadsheet functions you distribute.
On-demand data from
web services
directly in your spreadsheet.
web services
Use =FLEX() to import data from any API, file, or database table into Microsoft Excel or Google Sheets.
Instant integrations for the services you love
APIs & Web Services
Get on-demand lists and enrichments from web services
Enrich lead lists with services like Hunter, FullContact, and Crunchbase. Get custom lists of data from CRMs like Intercom, Pipedrive and Hubspot.
Files & Tables
Import refreshable extracts and lookups from your own data systems
Easily snap together key value lookup functions from file stores like Dropbox, Box and S3. Broadcast data extracts to your end users from master files in Google Sheets, Postgres or MySQL.
Roll Your Own
Build your own custom spreadsheet functions with Python or Node.js
Go off-road. Access just about any data with your own code and then easily document your custom functions with YAML. Share functions with your team without sharing your credentials.
Bring your own spreadsheet
Install the Excel or Google Sheets Add-on. Log in with your Flex.io account. Enjoy.
Built for your team
Data analysis is a team sport. Flex.io streamlines the process of getting data from IT's hands into analysts' spreadsheets. Everyone can focus on what they do best.
security
Credentials Management
Keep source data secure. Flex.io enables you to share data with your team while protecting database credentials, OAuth tokens, and API keys.
Data sources and spreadsheets. Harmonized.
Flex.io acts as a proxy between spreadsheets and external data sources. When an analyst uses a custom function, Flex.io verifies permissions, processes the request, and returns the result to the spreadsheet. Almost instantly.
Do (even) more with your spreadsheet
playlist_add_check
Enrich people data
With just a name or email, utilize integrations like Hunter or FullContact to pull down additional profile information.
device_hub
Enrich company data
Doing research on organizations? Use integrations like Crunchbase or Wikipedia to gather company information.
repeat
Create refreshable reports
Stop opening and formatting new CSV files. Access remote data sets, build models or graphs, and refresh with a click.
check_circle
Assemble lists
Perform web research without copy/paste. Gather lists from services like GitHub and Twitter with a simple function.
timeline
Explore your customer data
Assemble custom lists from CRM systems like Intercom, Pipedrive and HubSpot directly from your spreadsheet.
slow_motion_video
Look up data from master tables
Get instant access to master product, item, or vendor tables and return values with a lookup function.