Abstract: Batch management of oil products is an important base in guiding the operating of long distance pipelines. Real-time and accuracy calculation play important role in increasing pipeline productivity, meeting the needs of market supply and demand, balancing supply and demand relationship. This paper describes the application of Excel software to realize real-time tracing functions for batch plan execution, stocks and batch traveling position in batch management of oil products in Southern China Pipeline Network and provides cognitions and methods in solve the issues in batch management of oil products.