Is there a way to edit the exported item library?

[PPVC]

I want to create a total inventory report, and I don't want the inventory split into my 3 locations. Is there a way to have square export my library and just have it show the total number of items in stock as opposed to having to add up the numbers at each location to get my total inventory? I know I can do it in excel but it would be nice not to have to manually combine the columns every single time. Might there be a way to edit which columns are exported, like you can when you create a sales report? 

Thanks!

[RHatch]

Here is what I did. Export your inventory. Open it in your favorite spreadsheet software. Add a column to the beginning. In the first row your item list starts on, usually 2, enter the formula to add up the three cells with inventory qty. This will give you the total of the item. Copy and paste the formula down the column. 

If you have 3 locations your formula should be =(J2+P2+V2)  Just double check that these columns contain the "Current Quantity" of your stores.

Now the next time you do this open your fresh exported CSV file and copy and paste it into this sheet you created with your formulas.  The only thing you may have to watch for is more rows if you add more items. Copy the whole sheet but when you paste it make sure you start on cell B1, B2 if you don't copy the headers.