Forum Discussion

Copper Contributor

Dec 13, 2022

Solved

Making sense of CSV

Hi all, I use a fuel price watch app named Fuel Map Australia....for some time now I have been recording the purchase details each time I fill up, I'd like now to export the data into Excel, the app ...

excel

Riny_van_Eekelen
Dec 14, 2022
pfgreig The point is that you should not paste the CSV data into Excel. But when you have done that, and all comes into one column, you can still use Text-to-columns to create your 8 separate columns.

But a better and more reliable manner would be to import the CSV file with Power Query as PeterBartholomew1 rightfully suggested.

pfgreig

Copper Contributor

Dec 13, 2022

Riny_van_Eekelen

Thank you for your quick response. I'm afraid my level of knowledge isn't helping me. 🙂

I'll try and reword for query...:

I pasted a CSV file into an existing Excel spreadsheet....the file contains 66 rows each row containing eight separate items of information a comma between each item.

My issue is that the information is not presented in columns...all data resides in column A only. In order for me to use this data I need to place each item in its own column.

Thank you

Paul.

peiyezhu

Bronze Contributor

Dec 13, 2022

My issue is that the information is not presented in columns..

can you share the csv?
so I can test on my side.