Magento stores inventory data in key tables like catalog_product_entity (product info), cataloginventory_stock_item (stock levels), and inventory_source_item (stock sources). You can export relevant fields by joining these tables in a query or using Magento's API for a detailed export.