Excel: How to Insert Data from a Database (2026 Fast Process)
Tired of copying rows out of a database and pasting them into Excel every time the data changes? This tutorial walks through using Excel's built-in OData feed connection to pull live database tables straight into a blank workbook, using the Northwind sample as the source. By the end, you will be able to import multiple tables in one shot and refresh them with a single click instead of rebuilding the sheet by hand.
Covered inside:
→ Opening a blank workbook and locating the Get and Transform Data group on the Data tab.
→ Connecting through Get Data, From Other Sources, From OData Feed using the Basic URL option.
→ Handling the credentials prompt by leaving Anonymous selected and clicking Connect.
→ Using Select multiple items in the Navigator to tick Categories, Products, and Orders.
→ Previewing each table on the right before committing to the import.
→ Loading every table to its own worksheet and refreshing them later with Refresh All.
Would you have loaded all three tables at once like the video does, or imported them one at a time to keep the Queries and Connections pane simpler? Drop your approach in the comments.
#Excel #ExcelTutorial #ODataFeed #GetAndTransform #PowerQuery #NorthwindDatabase #ExcelDataImport #RefreshAll #ExcelTips2026 #DatabaseToExcel #ExcelQueries #SpreadsheetSkills