import csv
with open('test.csv', 'w', newline='') as file:
writer = csv.writer(file, delimiter=';')
writer.writerow(['Name', 'Preview', 'Price', 'URL'])
writer.writerow(["name_of_product", "image_of_product", "price_of_product", "url_of_product"])