Forum Discussion
pfgreig
Dec 13, 2022Copper Contributor
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 ...
- 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.
PeterBartholomew1
Dec 14, 2022Silver Contributor
I tend to use Power Query to import CSV files. If you do not have the correct row separator it should be possible to sort the problem before writing it to an Excel Table.
Maybe Riny_van_Eekelen will not approve of my trivialising PQ?