Showing results for 
Search instead for 
Did you mean: 

Want to create a single Excel file from multiple Files

New Contributor

I have multiple Json files and I want to create single Excel file using Snaplogic. It should Append the data and shouldn’t overwrite the file.


Former Employee

If you create a pipeline which reads the multiple input files, and a single output writer, that should achieve your objective. You might use the Multi-file reader Snap, or perhaps the Directory browser which gives a list of files, which you filter, and pass the names of the files to be read into the the file reader. Multiple ways to achieve it.

New Contributor

But it will overwrite the data, I want to Append the data in a single file.

New Contributor III

You may have to re-read the original file, along with the new file(s), in order to append. Several file systems don’t support append. I’m not sure if this is excel-specific, or just an append issue with your filesystem of choice.