Multiple data import from text files

[Nils_Junker]

Hi everybody,

I got the following problem:

I need to get data from round about 500 text files.
Problem one is that I just need a part of each text file, (the part I need always stays the same)
Problem two is that I dont have enough time to manually convert all the text files one by one.

The following link shows all the files I want to include in my excel

Index of /climate_environment/CDC/observations_germany/climate/10_minutes/air_temperature/recent/

Also how many lines can i insert in Excel?

If you need further Information, please send me an info!

Thanks for your help!

 

[Herakles]

I don't speak German.

 

[Herakles]

Can you show me the range selection box after you have selected the A2:A6 range.

 

[Nils_Junker]

Can you show me the range selection box after you have selected the A2:A6 range.

 

[Herakles]

So what does that error message mean?

 

[Nils_Junker]

So what does that error message mean?

Runtime error '9'

Index out of range

 

[Herakles]

Is "Invalid range selected." a better translation?

Did this come up when you selected A2:A6?

If not then which range did you select for that message to appear?

 

[Nils_Junker]

Is "Invalid range selected." a better translation?

Did this come up when you selected A2:A6?

If not then which range did you select for that message to appear?

yes i think thats a better translation.

yes this appeared when i clicked on ok

 

[Nils_Junker]

yes i think thats a better translation.

yes this appeared when i clicked on ok

i'm sorry no thats not the right translation

 

[Nils_Junker]

Is "Invalid range selected." a better translation?

Did this come up when you selected A2:A6?

If not then which range did you select for that message to appear?

when i google this error

there comes that there can be different sources creating the error,

First: An element isn't defined
Second: reference to a non-existent element
third: shorthand

 

[Herakles]

Lets sort this out and get onto the next stage.
I don't speak German so I cannot translate the messages.
You need the following folders as sub-folders of the workbook folder.
Downloads
ImportedData
You need a folder called Unzipped which is a sub-folder of the Downloads folder.
You can only select cells in column one.
If you select any cells outside of that column and or not containing a valid filename then
you will get a message as in the attached image.

Please confirm that you have been able to download and unzip at least one file.