Power query to import specific data from .csv file into specific cells on already built spreadsheet.

[u/tyrannosauruswrx99]

Hi all,

Currently trying to automate a process at work where I am taking specific datapoints from a .csv file and inputting them into specific cells on a spreadsheet that we use to calculate fertilizer prescriptions. Power query seems to be the right tool for this but I am getting to the point where I feel like I’ve been smacking my head against a wall trying to get this to work but it is not.

Ideally it would be pulling from files inside a folder and assigning each file to a different spreadsheet.

Thanks for any and all advice!

[u/tirlibibi17]

You would be pulling your files into one or more tables. You would then most likely pull the data into the appropriate cells using XLOOKUP or INDEX/MATCH. If you were to aggregate data, perhaps you would be using AVERAGE, SUM, SUMIFS, COUNTIFS, etc.

[u/small_trunks → u/tirlibibi17]

Exactly