I see Airtable and Google Sheets but I don’t see a way to select a local XLS spreadsheet that I want to load, query and update like an Airtable sheet.
Is there a way to do this or maybe this is custom node territory. I’d prefer a local sheet from a privacy point of view.
I feel this would be a common usage of n8n but maybe I’m mistaken.
Any help would be great. (Tutorials, video, walkthrough, example workflows would be even greater lol)
Thanks for any help
It looks like your topic is missing some important information. Could you provide the following if applicable.
hello @aussiemartin
To load XLSX FIle you will need Extract From File Node with Extract From XSLX Operation.
To save XLSX File you will need the Convert to File Node with Convert to XLSX Operation
umm ok, but then what about other spreadsheet opersations such as update a row etc.
I have a 10,000 row spreadsheet that I want to loop through, using a custom API, and insert addition column data.
For that n8n have only vendor specific nodes, like Excel 365 or GDrive.
Extract from file has partial functionality, like an option to use Range from returning data, with you can’t append to file.
There is a workaround, where you can convert the table into CSV file and then update the content simply with a local linux command
I ended up using the extract from file, looping through all the items and then using a Merge-combine node to write the file out.
Thanks for your help though and I’ll remember your workaround for the future.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.