After a seller has downloaded items or orders to a CSV, the file can be opened with any spreadsheet software application.  

A spreadsheet software program is a powerful tool having the ability to sort data and calculate values using mathematical formulas with the data in cells.


Some common spreadsheet software applications include:


There are guides and tutorials for using different spreadsheets available online, from simple to very advanced.  It is recommended that sellers review the basics for using their own spreadsheet software application and specific version.  We have provided some very basic general tips for getting started:
  ‚Äč

When managing a CSV, it is helpful to prepare the report for easier viewing by:


MS Excel example for adding up a column

If a seller wants to add the Scheduling Fee column on a Calculating Finances report using Microsoft Excel 2013 on Windows 10, they can follow these steps:

 
  1. Click View > Freeze Panes > Freeze Top Row
  2. Click the letter AN which will select the entire column
  3. Right click and Select Format Cells > Accounting, then click OK
  4. Scroll to the very end of column AN
  5. Stop scrolling when there is no more data inside the cells
  6. Click inside the first empty cell
  7. Click Formulas, and select AutoSum > Sum
  8. The range will by default select every row in column G
  9. Press Enter, and the cell will now contain the sum of all the scheduling fees



 

Did this help?
Last updated Jun 24, 2016 01:23PM PDT.