Hi there @NigelM,
Welcome to the Community!
Thank you for providing the details about your setup and the issue you encountered while transferring your HubSpot data to OneDrive via Excel. I understand that you followed the instructions and set up the Zap, but it didn't work as expected. I apologize for any inconvenience caused.
To clarify, you mentioned that currently, all the data is being placed in a single line in Excel. However, you would like each piece of data to be in a separate column. I would appreciate it if you could provide more specific information about the structure of the data you're trying to transfer. Are you looking to separate specific fields from HubSpot into individual columns, or are you referring to a different data structure?
Additionally, to use Microsoft Excel with Zapier you need to set up your spreadsheet in a very specific way. You can read more of that here: https://help.zapier.com/hc/en-us/articles/8496044256909-How-to-Setup-Your-Microsoft-Excel-sheet-to-Work-With-Zapier
Please keep us posted!