Forum Discussion

pfgreig's avatar
pfgreig
Copper Contributor
Dec 13, 2022

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's avatar
    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.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor

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's avatar
pfgreig
Copper Contributor
Dec 14, 2022

Thanks to all who assisted here...,the issue is now corrected.

My problem was that the app would only allow me to export the records in CSV format to the clipboard...with my limited knowledge it made sense to paste it into a spreadsheet to enable analyzing....acting on the advice from Riny_van_Eekelen I have now simply converted the text to columns and the results are totally satisfactory.

 

Thanks again and a Merry Christmas to all.

Paul

Lockyer Valley

Queensland

Australia.

Resources