Data Tab

Get & Transform Data

• Data Connection Options: A drop-down menu allows users to discover, connect, and combine data from various sources.

• Key Commands Include:
- From File:Import data from text, CSV, or formatted files.
- From Database:** Connect to a database for data import.
- From Azure: Integrate data from Azure services.
- From Online Services: Access new online data sources.
- From Other Sources:Additional data connection options.
- Combine Queries:Merge multiple queries for analysis.
- Launch Query Editor: A new feature for editing queries.
- Data Source Settings: Manage data source configurations.
- Query Options: Access different settings related to queries.
• From Text/CSV: Import raw data from text or formatted text files.
• From Web: Capability to extract data from a specified web page.
• From Table/Range: Create queries linked to selected tables; ranges not in tables will be converted into tables.

• From Picture: New feature allowing conversion of images with table data into editable data in Excel (includes Picture From File and Picture From Clipboard).

• Recent Sources: Quick access to manage and connect to previously used data sources.

• Existing Connections: Option to import data from frequently used sources.