Ask Your Question

Create 1 spreadsheet from many CSV [closed]

asked 2013-01-09 18:07:23 +0100

MiSt gravatar image

Hi, I have a bunch of csv data here, all exactly the same layout and I want to create one spreadsheet document with many tabs from them. Is there a way to do this by batch? Importing several dozen files takes a lot of time...

Thanks and greetings, Michael

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-20 19:10:42.184946

2 Answers

Sort by » oldest newest most voted

answered 2013-01-09 18:43:50 +0100

qubit gravatar image

This page might give you some hints for macros that can accomplish your goal:

You might have to tweak the code a little to suit your particular situation, but that looks pretty close to me.

edit flag offensive delete link more

answered 2013-01-22 16:51:44 +0100

MiSt gravatar image

Hi qubit,

tried this solution and it works very nice. Thanks for the link!

Greetings, Michael

edit flag offensive delete link more


Hi @MiSt, You're quite welcome! Did you have to change the macro code much to make it work? It would be great to have a short write-up from you so that if anyone else has the same question, they could follow your instructions. Thanks!

qubit gravatar imagequbit ( 2013-01-22 19:18:38 +0100 )edit

Hi cubit you are right, My query is still not resolve its easy but I didn't get proper solution

this is my question if you could help on this then it would be better

Many thnks

Lion gravatar imageLion ( 2015-08-28 14:29:07 +0100 )edit

Question Tools


Asked: 2013-01-09 18:07:23 +0100

Seen: 8,255 times

Last updated: Jan 22 '13