Export then import list data into QuickBooks Online
You can export list data in CSV or Excel file format then import them into QuickBooks Online.
Open the original file.
Select Reports from the left menu.
Create the following reports with the columns arranged in the order shown below.You can also generate these reports automatically by right-clicking the links below then select Copy link address and paste it into your browser's address bar while signed in to QuickBooks Online.