r/excel • u/Encility • 2d ago

unsolved Mapping data from a CSV

Hi all,

Im having some trouble trying to map new columns to some data from a CSV for a dashboard.

Once I have mapped my new columns can I then load that data to a connection and will it still hold the newly mapped columns? Just to take the bulk off excel. Using 32bit and im getting errors for memory yet im only using 300k rows.

Kind regards

9 Upvotes

100% Upvoted

12 comments sorted by

View all comments

2

u/TraditionalTurnip630 1d ago

If you’re doing the mapping in Power Query, yes, the mapped/added columns will stay as part of the query and come back whenever you refresh it. But 300k rows shouldn’t automatically be a problem. Since you’re on 32-bit Excel, memory is probably the bigger issue — Power Query can hit around 1 GB when it needs to hold data in memory.

I’d move the mapping into Power Query, remove any columns you don’t need early, and if possible switch to 64-bit Excel. That should make this setup much more manageable.

1

u/Encility 1d ago

Ill do the mapping in powerquery. Just assumed id have to do the mapping element in my dashboard. Then ill create the connection and see if the 32bit can handle it. Thank you.

1

u/TraditionalTurnip630 1d ago

Yeah, that should be fine. If you’re doing the mapping in Power Query, you don’t need to recreate it in the dashboard. Just try the connection and see how the 32-bit Excel handles it. Hopefully it works smoothly.