Set up and manage data connections to import external data into Excel automatically.
Help me set up data import connections in Excel: **Data Source Type:** - [ ] CSV/Text files - [ ] Excel workbooks - [ ] Access database - [ ] SQL Server database - [ ] Web page/table - [ ] SharePoint list - [ ] OData feed - [ ] JSON/XML file - [ ] Other: [specify] **Source Location:** - Path/URL: [location of data source] - Access method: [local file / network / cloud / API] - Authentication: [none / username/password / Windows auth] **Data Details:** - Tables/sheets to import: [list] - Columns needed: [all or specific] - Rows: [all or filtered] - Data volume: [row count estimate] **Transformation Needs:** - [ ] Filter rows - [ ] Select columns - [ ] Change data types - [ ] Merge tables - [ ] Unpivot columns - [ ] Add calculated columns **Refresh Requirements:** - Refresh frequency: [manual / on open / scheduled] - Full reload or incremental: [specify] - Multiple queries to coordinate: [Yes/No] Please provide: 1. Step-by-step connection setup 2. Power Query recommendations 3. Query parameters for flexibility 4. Refresh configuration 5. Error handling for connection issues 6. Best practices for data connections
Or press ⌘C to copy