From 2020 to 2021, multimodal transportation tests were conducted in South Korea. Surrogate fuel assemblies were loaded into a full-sized transportation cask for road and sea transportation tests at Doosan Enerbility and along a South Korean seashore. The study focused on the effects of normal transport conditions on spent nuclear fuel (SNF) and its structural integrity by analyzing the data obtained. Additionally, the need to analytically assess the integrity of spent fuel under these conditions through design-basis loads has emerged. This study focuses on generating the input load. The study also addressed the practical considerations for applicants regarding the format of these design loads. For all tested conditions, design-basis power spectral density (PSD) loads were identified, covering PSDs at the basket across various transportation conditions. A comprehensive diagram capturing the PSDs at the basket, which then transmitted the load to the fuel assembly for each transport scenario, was calculated as the design load. The transportation test load data served as inputs for the shake table test, which aimed to closely evaluate the behavior of the fuel assemblies. The appropriateness and conservativeness of the derived design-basis PSD were validated through a shake table tests.