The gear checkout system replaces issues.csv at the same path each morning. Start with headers Item and Quantity, then Cable,8 and Stand,3. In a saved XLSX reserve the RawData tab for the import and put your total on a separate tab.

Import the source with headers and numeric quantities

Select RawData!A1 in Ulet, choose Data → From CSV/JSON, and review the delimiter and preview. After import, use =SUM(RawData!B2:B3) on the summary sheet for this two-record example. The initial total should be 11.

The local issues.csv has Cable 8 and Stand 3 in the starting copy.

Illustrated import. Keep a clean landing area for the incoming rows.

Change the local file and refresh

Save Cable,9 at the same CSV path. In a working copy of the XLSX choose Data → Refresh All. Confirm that RawData shows 9 and the summary shows 12. If the source moved, inspect it under Queries & Connections. If rows are added or removed, verify the destination for stale data and adjust the summary range as needed.

After refreshing, RawData shows Cable 9 and the summary total is 12.

Illustrated refresh check using one changed record.

Related Microsoft Excel reference