Utilizing foam techniques in carbon storage projects is of recent interest, yet whether the optimized bulk foam screening method could also identify the optimal foam formulation that improves the CO2 storage potential remains under-studied. This study demonstrates the feasibility of the bulk foam test as a screening stage to select a proper foaming agent for carbon storage by investigating the consistency of the results obtained from bulk foam properties measurements, dynamic foam performance evaluations in porous media, and the quantification of CO2 storage potential at the reservoir conditions. Different foaming agents were initially screened based on their abilities to generate ample and stable foam at 13.79 MPa and 90°C. The CO2 storage potential was studied based on the CO2 breakthrough deceleration and water displacement efficiency, while the dynamic performance of supercritical CO2-foams stabilized by these selected surfactants was then evaluated in Berea sandstone using the CO2/surfactant co-injection method. Among the tested surfactants in bulk CO2 foam experiments at high pressure and temperature conditions, a sultaine-based zwitterionic surfactant was identified to exhibit the highest foamability and foam stability. In flooding experiments, the selected surfactant was able to provide decent foam generation ability that leads to the best performance in improving the CO2 storage potential by two-fold magnitude, compared to the brine-saturated core case. Besides, an immediate foam generation was observed, providing high flow resistance for the injected CO2 and, therefore, resulting in controlled CO2 mobility and improved CO2 sweep efficiency. The result coherency from CO2 storage potential evaluations and foam performance assessments both in bulk and inside porous media shows the feasibility of the bulk foam screening method for the carbon storage studies. The initial identification of high-performing surfactants based on their bulk foaming properties can provide countable insights for CO2 storage potential improvement.