Can I make a tabbed worksheet from a csv source file

[PhilDesanex]

I'm in the UK and am trying to interface our database system with Excel in order to comply with some new tax legislation (MTD - Making Tax Digital). What I want to do is make an excel file with 3 worksheets - Income, Expenditure and Analysis. I can generate all of the data in three separate csv files (although I use ~ as a list separator) and import them successfully into Excel. Is it possible to put code into the csv file that Excel would interpret and create a new tab? In this way, I could generate a complete Excel in one go, rather than combining 3 Excel sheets into one.

 

[Joe4]

CSV files are a type of text file (a "flat" text file, meaning you cannot have multiple sheets), with no formatting.
They are strictly flat data files with nothing else in them. So you are not going to be able to put VBA code in a CSV file.

I am not sure I understand the need for that anyway. You should be able to create an Excel macro that can pickup and combine all 3 CSV files into your one file all at once.
I have created many Excel Macro files that look in a certain folder for files, import them into a file, and save however you need.
Even if you have the VBA code open each CSV into separate files (instead of importing them all into one), you can simply copy/paste their contents all into one file.

 

[PhilDesanex]

Thanks Joe. I'm doing the combine thing at the moment but just thought that someone might have developed a workaround, possibly including some custom delimiters in the csv data.

 

[Joe4]

Have look here, which shows you various methods you can use, and being able to specify the exact delimiter:

How to Open CSV with Delimiter in Excel (6 Simple Ways)

This article will show you 6 simple ways to Open CSV with Delimiter in Excel. Learn them, download the workbook and practice.

www.exceldemy.com

Also note that for the non-VBA options shown there, you may be able to convert it to VBA code by turning on your Macro Recorder while performing the steps manually to get most of the VBA code you need for that part.