# Files & Tables

- [Airtable](/sources/category/files-and-tables/airtable-addon.md): Connect Airtable bases to Google Sheets with Coupler.io. Automate data syncs, combine tables for reporting, and eliminate manual copying from your database.
- [Data Overview](/sources/category/files-and-tables/airtable-addon/data-overview.md): Airtable field types import into Google Sheets — learn how attachments, lookups, formulas, and linked records appear in your synced data.
- [Common Issues](/sources/category/files-and-tables/airtable-addon/common-issues.md): Fix Airtable connection errors like null reference errors. Use shareable grid view links instead of base links for successful imports.
- [Best Practices](/sources/category/files-and-tables/airtable-addon/best-practices.md): Airtable sync best practices — create view-specific flows, use dedicated import sheets, and manage refresh schedules for reliable data.
- [FAQ](/sources/category/files-and-tables/airtable-addon/faq.md): Do you need an Airtable API key for Coupler.io? Answers on shareable links, password protection, formula handling, and sync frequency.
- [Azure Blob Storage](/sources/category/files-and-tables/azure-blob-storage.md): Connect Azure Blob Storage to Coupler.io to sync CSV, JSON, Parquet, and Excel files into Google Sheets, BigQuery, or other destinations.
- [Data Overview](/sources/category/files-and-tables/azure-blob-storage/data-overview.md): Azure Blob Storage data types: CSV, JSONL, Parquet, Excel, and unstructured formats. Learn which file types work best for your use case.
- [Common Issues](/sources/category/files-and-tables/azure-blob-storage/common-issues.md): Troubleshoot Azure Blob Storage connection failures, missing files, permission errors, and format compatibility issues in Coupler.io.
- [Best Practices](/sources/category/files-and-tables/azure-blob-storage/best-practices.md): Optimize Azure Blob Storage syncs: manage file paths with glob patterns, choose the right format, and schedule refreshes efficiently.
- [FAQ](/sources/category/files-and-tables/azure-blob-storage/faq.md): Common questions about Azure Blob Storage in Coupler.io: authentication, file formats, incremental syncs, and refresh frequency.
- [BigQuery](/sources/category/files-and-tables/google-big-query.md): Query BigQuery datasets with custom SQL and auto-sync results to Google Sheets, Excel, or AI tools via Coupler.io.
- [Data Overview](/sources/category/files-and-tables/google-big-query/data-overview.md): Write custom SQL queries against BigQuery tables—control your data structure, joins, and transformations completely.
- [Common Issues](/sources/category/files-and-tables/google-big-query/common-issues.md): Fix BigQuery permission denied errors, service account access issues, and credential problems in Coupler.io.
- [Best Practices](/sources/category/files-and-tables/google-big-query/best-practices.md): Secure BigQuery connections with dedicated service accounts, minimal IAM roles, and query optimization strategies.
- [FAQ](/sources/category/files-and-tables/google-big-query/faq.md): BigQuery FAQs—use as source and destination, multi-table queries, project references, and data pipeline setup.
- [How to get Google Cloud key file?](/sources/category/files-and-tables/google-big-query/faq/how-to-get-google-cloud-key-file.md): Learn how to generate a Google Cloud JSON key file to use for connecting Coupler.io to your BigQuery source or destination.
- [Box](/sources/category/files-and-tables/box.md): Connect Box to Google Sheets, BigQuery, or AI tools via Coupler.io. Export files, users, admin logs, sign requests, and more.
- [Data Overview](/sources/category/files-and-tables/box/data-overview.md): Explore Box data available in Coupler.io — files, folders, users, admin logs, sign requests, events, and collaboration permissions.
- [Common Issues](/sources/category/files-and-tables/box/common-issues.md): Fix Box connection errors, missing files, permission issues, and data gaps in Coupler.io. API key and User ID troubleshooting guide.
- [Best Practices](/sources/category/files-and-tables/box/best-practices.md): Get the most from Box data in Coupler.io — tips for admin log exports, collaboration audits, and sign request tracking.
- [FAQ](/sources/category/files-and-tables/box/faq.md): Can I export Box admin logs? How does User ID work? Common questions about connecting Box to Coupler.io answered.
- [Box Data Extract](/sources/category/files-and-tables/box-data-extract.md): Connect Box folders to Google Sheets, BigQuery, or AI tools via Coupler.io. Extract text, metadata, and AI-generated insights from your Box documents.
- [Data Overview](/sources/category/files-and-tables/box-data-extract/data-overview.md): Explore Box Data Extract entities: text representations, AI Ask responses, and structured metadata pulled from Box folder documents.
- [Common Issues](/sources/category/files-and-tables/box-data-extract/common-issues.md): Fix Box Data Extract connection errors, missing files, folder ID mistakes, and AI prompt issues when syncing Box documents via Coupler.io.
- [Best Practices](/sources/category/files-and-tables/box-data-extract/best-practices.md): Get the most from Box Data Extract — folder structure tips, AI prompt design, and how to combine entities for richer document pipelines.
- [FAQ](/sources/category/files-and-tables/box-data-extract/faq.md): Can Box Data Extract read subfolders? How do AI prompts work? Common questions about pulling Box document data into Coupler.io.
- [Coda](/sources/category/files-and-tables/coda.md): Connect Coda docs, tables, and rows to Google Sheets, BigQuery, or your data warehouse via Coupler.io for seamless reporting and automation.
- [Data Overview](/sources/category/files-and-tables/coda/data-overview.md): Extract Coda rows, docs, pages, tables, categories, and permissions — pull structured workspace data for auditing and dynamic pipeline builds.
- [Common Issues](/sources/category/files-and-tables/coda/common-issues.md): Fix Coda API key errors, authentication failures, and missing data issues — validate token format and table ID configuration in Coupler.io.
- [Best Practices](/sources/category/files-and-tables/coda/best-practices.md): Master Coda row exports with correct doc and table IDs — pair structured data pulls with workspace discovery for accurate reporting pipelines.
- [FAQ](/sources/category/files-and-tables/coda/faq.md): Find your Coda API key, doc ID, and table ID — quick setup steps for connecting Coda tables to Coupler.io data workflows.
- [CSV](/sources/category/files-and-tables/csv.md): Import CSV files from Google Drive, public servers, or APIs into Google Sheets, BigQuery, and AI tools via Coupler.io.
- [Data Overview](/sources/category/files-and-tables/csv/data-overview.md): CSV imports maintain your file's structure—columns become headers, rows populate as data, with optional filtering.
- [Common Issues](/sources/category/files-and-tables/csv/common-issues.md): Fix CSV access errors: verify public URLs, use shareable Google Drive links, and test in incognito mode.
- [Best Practices](/sources/category/files-and-tables/csv/best-practices.md): Test CSV URLs before connecting, use Google Drive shareable links, and validate data structure for smooth imports.
- [FAQ](/sources/category/files-and-tables/csv/faq.md): Import publicly accessible CSVs from any source—Google Drive, servers, APIs—using direct file URLs with Coupler.io.
- [Dropbox](/sources/category/files-and-tables/dropbox.md): Automate CSV and Excel exports from Dropbox to Google Sheets, BigQuery, or AI tools via Coupler.io — no coding needed.
- [Data Overview](/sources/category/files-and-tables/dropbox/data-overview.md): Import columns and rows from Dropbox CSV or Excel files. Coupler.io reads your data as-is with headers as column names.
- [Common Issues](/sources/category/files-and-tables/dropbox/common-issues.md): Fix Dropbox file picker issues, account connection problems, and file permission errors preventing data imports.
- [Best Practices](/sources/category/files-and-tables/dropbox/best-practices.md): Set up Dropbox syncs efficiently — start with one file, use consistent headers, and append multi-sheet data properly.
- [FAQ](/sources/category/files-and-tables/dropbox/faq.md): Can you import multiple Dropbox files? How do file moves affect flows? Get answers on Dropbox data import limits.
- [Google Drive](/sources/category/files-and-tables/gdrive.md): Import Google Sheets, Excel, and CSV files from Google Drive into your data warehouse. Replace IMPORTRANGE with Coupler.io's reliable file syncing.
- [Data Overview](/sources/category/files-and-tables/gdrive/data-overview.md): Pull table data, multiple sheets, and custom ranges from Google Drive files. Structure depends on your source file layout and selection.
- [Common Issues](/sources/category/files-and-tables/gdrive/common-issues.md): Can't find your Google Drive file? Fix permission gaps, use direct URLs, and troubleshoot shared drive access issues with Coupler.io.
- [Best Practices](/sources/category/files-and-tables/gdrive/best-practices.md): Use direct file URLs for consistency, clean source data before importing, and set refresh schedules to keep Google Drive syncs accurate.
- [FAQ](/sources/category/files-and-tables/gdrive/faq.md): Import multiple Google Drive files, monitor folders for new data, and automate file selection — answers to common Google Drive setup questions.
- [Google Sheets](/sources/category/files-and-tables/google-sheets.md)
- [Data Overview](/sources/category/files-and-tables/google-sheets/data-overview.md)
- [Common Issues](/sources/category/files-and-tables/google-sheets/common-issues.md)
- [Best Practices](/sources/category/files-and-tables/google-sheets/best-practices.md)
- [FAQ](/sources/category/files-and-tables/google-sheets/faq.md)
- [JSON](/sources/category/files-and-tables/json.md): Connect to any REST API with JSON source — pull data from custom endpoints, SaaS platforms, and microservices into Google Sheets or BigQuery via Coupler.io.
- [Data Overview](/sources/category/files-and-tables/json/data-overview.md): Define JSON API structure with endpoint URL, HTTP method, authentication, and parameters. Map nested data using paths for flexible, API-driven imports.
- [Common Issues](/sources/category/files-and-tables/json/common-issues.md): Fix JSON connection errors — 401/403 auth failures, rate limits, empty responses, and malformed payloads. Verify credentials and API documentation.
- [Best Practices](/sources/category/files-and-tables/json/best-practices.md): Test JSON APIs in Postman first, extract nested data with path notation, handle pagination and large responses efficiently.
- [How to define the path for selecting JSON objects](/sources/category/files-and-tables/json/best-practices/how-to-define-the-path-for-selecting-json-objects.md)
- [FAQ](/sources/category/files-and-tables/json/faq.md): Can you connect REST APIs with JSON? Yes — OAuth tokens, API keys, custom endpoints, and microservices all supported. Learn authentication and data extraction.
- [Microsoft Excel](/sources/category/files-and-tables/microsoft-excel.md): Automate Excel data exports to Google Sheets, BigQuery, Looker Studio, and AI tools via Coupler.io — no manual copy-paste needed.
- [Data Overview](/sources/category/files-and-tables/microsoft-excel/data-overview.md): Import sheets and cell ranges from Excel workbooks in OneDrive or SharePoint — configure exactly what data flows to your destination.
- [Common Issues](/sources/category/files-and-tables/microsoft-excel/common-issues.md): Fix Microsoft 365 sign-in errors, OneDrive access issues, and conditional access policy blocks for Coupler.io Excel connections.
- [Best Practices](/sources/category/files-and-tables/microsoft-excel/best-practices.md): Store Excel files in OneDrive or SharePoint, use Range parameters for large workbooks, and schedule consistent refresh cycles.
- [FAQ](/sources/category/files-and-tables/microsoft-excel/faq.md): Connect Excel files from OneDrive or SharePoint, import multiple sheets, and sync data automatically with Coupler.io.
- [MySQL](/sources/category/files-and-tables/mysql.md): Export MySQL tables and views to Google Sheets, BigQuery, Excel, or AI tools—no SQL skills needed. Schedule automatic refreshes with Coupler.io.
- [Data Overview](/sources/category/files-and-tables/mysql/data-overview.md): MySQL table exports preserve your schema structure—all rows and columns transfer to sheets, databases, or AI destinations unless filtered.
- [Common Issues](/sources/category/files-and-tables/mysql/common-issues.md): Fix MySQL connection errors—verify hostname, port, firewall rules, and whitelist Coupler.io IPs to resolve 'connection refused' issues.
- [Best Practices](/sources/category/files-and-tables/mysql/best-practices.md): Whitelist Coupler.io IPs before connecting. Use dedicated MySQL users with SELECT-only permissions for secure, reliable data exports.
- [FAQ](/sources/category/files-and-tables/mysql/faq.md): Can't query MySQL directly? Create a view with your custom SQL logic, then export it via Coupler.io for flexible, filtered data.
- [OneDrive](/sources/category/files-and-tables/onedrive.md): Sync Excel files from OneDrive to Google Sheets, BigQuery, Looker Studio, or AI platforms with Coupler.io automation.
- [Data Overview](/sources/category/files-and-tables/onedrive/data-overview.md): Import data from OneDrive Excel files by selecting workbooks, sheets, and ranges — flexible sourcing for any spreadsheet structure.
- [Common Issues](/sources/category/files-and-tables/onedrive/common-issues.md): Fix OneDrive WAC access token errors, file availability issues, and connectivity problems preventing Excel syncs.
- [Best Practices](/sources/category/files-and-tables/onedrive/best-practices.md): Maintain consistent sheet names, headers in row one, and proper file structure for reliable OneDrive data imports.
- [FAQ](/sources/category/files-and-tables/onedrive/faq.md): OneDrive personal and Business (SharePoint) files work the same — shared files appear automatically once authenticated.
- [PostgreSQL](/sources/category/files-and-tables/postgresql.md): Export PostgreSQL tables, views, and custom SQL queries to Google Sheets, BigQuery, Excel, and AI tools via Coupler.io — automate reporting without code.
- [Data Overview](/sources/category/files-and-tables/postgresql/data-overview.md): Import PostgreSQL data via table selection or custom SQL queries. Choose tables, views, or write queries to filter, join, and transform database records.
- [Common Issues](/sources/category/files-and-tables/postgresql/common-issues.md): Fix PostgreSQL connection errors: firewall rules, IP whitelisting, authentication failures, and AWS RDS security group configuration on Coupler.io.
- [Best Practices](/sources/category/files-and-tables/postgresql/best-practices.md): Whitelist Coupler.io IPs in AWS, Azure, and on-premise firewalls early. Create read-only database users, test connections, and schedule incremental refreshes.
- [FAQ](/sources/category/files-and-tables/postgresql/faq.md): PostgreSQL IP whitelisting, firewall rules for AWS RDS and Azure, authentication setup, and refresh scheduling — quick answers on Coupler.io.
- [Redshift](/sources/category/files-and-tables/redshift.md): Export Redshift tables, views, and SQL queries to Google Sheets, BigQuery, Looker Studio, and AI tools with Coupler.io — no coding needed.
- [Data Overview](/sources/category/files-and-tables/redshift/data-overview.md): Access any Redshift table, view, or custom SQL query result. Coupler.io exports your data based on schemas and permissions in your cluster.
- [Common Issues](/sources/category/files-and-tables/redshift/common-issues.md): Fix Redshift connection timeouts and access errors — security group settings, VPC accessibility, and port configuration troubleshooting.
- [Best Practices](/sources/category/files-and-tables/redshift/best-practices.md): Optimize Redshift exports with custom SQL filters, pre-aggregation, and query testing to reduce transfer costs and keep destinations lean.
- [FAQ](/sources/category/files-and-tables/redshift/faq.md): Can you connect private VPC Redshift clusters? Public endpoints, SSH tunnels, and VPN solutions for Coupler.io Redshift integration.
- [Tableau](/sources/category/files-and-tables/tableau.md): Export Tableau view data to Google Sheets, BigQuery, Excel, and AI tools via Coupler.io — automate dashboard data pulls on schedule.
- [Data Overview](/sources/category/files-and-tables/tableau/data-overview.md): Access dimensions, measures, and raw data rows from Tableau views — export complete datasets without manual downloads.
- [Common Issues](/sources/category/files-and-tables/tableau/common-issues.md): Fix Tableau authentication errors, permission issues, and sign-in failures when connecting to Coupler.io.
- [Best Practices](/sources/category/files-and-tables/tableau/best-practices.md): Start with single-sheet Tableau views, verify permissions, and scale exports safely for reliable automated data delivery.
- [FAQ](/sources/category/files-and-tables/tableau/faq.md): Answers on exporting multi-sheet dashboards, accessing private Tableau Server behind firewalls, and data refresh timing.