Example CSV Header

CustomerNo,ShipToCode,ItemCode,Quantity,CustomerPONo,OrderDate,PackDate,UofM,Site,DeliveryDate,Price

Creating the CSV File in Excel

1. Paste the header row into cell A1.
2. If the data appears in a single column:
• Select Column A.
• Click Data → Text to Columns.
• Choose Delimited.
• Select Comma.
• Click Finish.
3. Enter the order information and Export as CSV

Creating the CSV File in Google Sheets

1. Paste the header row into cell A1.
2. If the data appears in a single column:
• Select Column A.
• Click Data → Split Text to Columns.
• Choose Comma as the separator.
3. Enter the order information and Download as CSV