Forum Discussion
CSV not parsed into columns despite Get Data delimiter set
I found a solution.
Another function in the same menu - Text to Columns.
This one processed the comma separator correctly. Hurray.
Filip, good to know you found the way. However, in general it could be interesting to understand why Get Data doesn't work. Perhaps some special non-printable symbols at the beginning of the file which Text to Columns definitely ignores, perhaps something else.
Hi,
I'm having a similar problem, but I can post my .CSV file. These are the steps I have tried:
1. I tried to open the comma-delimited CSV file directly from File Explorer
2. I opened Excel, then tried to open the CSV file
3. I tried to use the Data/Get from CSV option
4. I opened the file in a text editor and replaced all the commas with semi colons
5. I created a blank text file, copy and pasted the text from the CSV file, saved the renamed the file
In every case, when the connector screen pops up, changing the delimiter type does almost nothing. I think one of them splits the data into 3 columns, but my file is many columns wide.
I'm using Windows 10 with Excel for Office 365
CannonAli , not sure why such effect. If open your csv file in Excel and save as CSV UTF-8 or CSV MS-DOS in both cases such file is imported correctly by default
At the same time your initial file is also could be imported correctly, but it's required few more steps
From here
click Transform Data, after that Split Column by Delimeter
Select Semicolon, Ok
Close and load to back to Excel with desired options
Thank you very much. I saved it as CSV MS-DOS and was able to import it. I don't know why, but with each new release of Office, Microsoft makes it harder and harder to use their programs. I never had this problem with older versions of Excel.
Here is a screenshot from the connector: