Humonix + Spreadsheets (Excel, Google Sheets, CSV)
Bring in what lives in spreadsheets, and take any list back out. Excel and CSV files import wherever a file is accepted; every list exports as CSV or Excel; a linked Google Sheet, OneDrive, SharePoint or Dropbox file is re-read on a schedule, and what changed waits for your approval.
Spreadsheets (Excel, Google Sheets, CSV)
Connected in production
Reads
- Excel workbooks (.xlsx), CSV and tab-separated files, the sheet you choose
- QuickBooks Desktop lists (.iif) and Xero or QuickBooks column names as they are
- A linked Google Sheet, OneDrive, SharePoint or Dropbox file, shared “anyone with the link can view”
Changes, after your yes
- Nothing in your spreadsheet: links are read-only
- Your customers, jobs, plans or deals in Humonix, only after you approve the rows added and changed
- Rows deleted from a linked sheet are shown to you and never removed in Humonix
Each re-read of a linked sheet that differs from the last one becomes a single item in your approvals queue, with the rows added, the fields changed and the rows gone. Nothing is written before a yes, and a linked sheet never deletes anything.
How to connect it
01Agent
Import: on any import, choose a CSV or Excel file; you see the columns read and any problems before anything is written.
02Agent
Export: every list has Export · CSV · Excel; customers and invoices also export in Xero’s and QuickBooks Desktop’s import formats.
03Agent
Linked sheet: share the sheet with “anyone with the link can view” (or publish it to the web as CSV), paste the link under Connections, and choose how often it is read.
Questions
Can I import an Excel file?
Yes. Excel workbooks (.xlsx) import wherever a CSV does, and you pick the sheet. Title lines a report puts above its header are skipped. An older .xls file needs to be saved as .xlsx or CSV first.
Does it work with QuickBooks Desktop and Xero?
Yes, through files. QuickBooks Desktop .iif lists and Xero or QuickBooks exports import with their own column names, and customers and invoices export in Xero’s CSV and QuickBooks Desktop’s IIF formats. Check the account names and codes against your chart before importing into your books.
Does Humonix sign in to my Google account?
No. A linked Google Sheet is read from its share link or its published CSV, so nothing else in your Drive is reachable. Signing in with Google to pick a sheet is not offered yet.
Will a linked sheet overwrite my data?
Not without you. Each change set waits in your approvals queue; a yes writes the rows added and changed, and rows removed from the sheet stay in Humonix.
Related integrations
Check your stack
Tell us what you run today. We'll tell you what connects, what's scoped work, and what Humonix would do first.