Import data from csv to a predefined Template, data should get filled without disturbing the existing template.

Question

Hi Team,

Hope the Question I made be self-explanatory and easy to understand.

This Question shall be familliar to expert team, if so please do share some thread where i can take the readings.

Little Details on my Query, if no explanation is available yet ...

Brief on Query:

Lets say in a sheet., Column A to D and 3 rows are merged and centered, titled as X FAMILY INFO.

5A , 5B, 5C, 5D goes with headings like " S.No, Name, Age, Gender respectively.

6A, 6B, 6C, 6D and below has the data. similar to row 5.

The above should be a template and everytime i can have, different family name substituted for X in title.

and then data's from csv should fill starting from 5th row.

Brief od Query ends.

Hope my question is clear,

Please do help me how to use multiple csv to fill in this template everytime.

The rows titles and headings are color formated too, so that it should also need to be preserved.

and also I need a pie chart added with gender differentiation, at a side, can it also be added in template automatically.

Please help me

Answer 1

Thanks for your reply.

My complete work is based on UNIX shell, and I shall be generating many files best in CSV format.

So when i can generate my format like below, how to use the above template to update is my actual query.

Answer 2

You can not save such files as CSV, because CSV is just a text file.

Format the data in rows 5:10 as table

Create and format tables - Office Support

Re-create the chart from the table

Remove all data rows from the table

Save the file as XLTX

Now you can create new files based on the template and all you have to do is to copy the new data into the table. The chart will update automatically.

Andreas.

Answer 3

You may use formula to get new data to this template or macro to update values automatically.

Answer 4

This is how the template I need.

Every time, the Family name changes and data changes.,
it can start from 6th row and can go as big in number.

what shall be CSV format for this type., i should generate.,
which can fill in the table next time.,

Answer 5

Could you share us your template and test csv file? Then I will have a try.

For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.

Why a sample file is important for troubleshooting. How to do it. - Microsoft Community