SOLVED

How to import plain, simple, flat CSV data

%3CLINGO-SUB%20id%3D%22lingo-sub-77125%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20import%20plain%2C%20simple%2C%20flat%20CSV%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-77125%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Willem%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20exactly%2C%20old%20wizard%20is%20still%20here.%20You%20may%20add%20it%26nbsp%3Bfrom%20File-%26gt%3BOptions%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20657px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F15689i8F485112D36C5ED8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22LegacyWizards.JPG%22%20title%3D%22LegacyWizards.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESelect%20it%20from%20Lecacy%20Wizards%20in%20Get%20data%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20492px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F15690i7222EB287B2B5749%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22LegacyWizards01.JPG%22%20title%3D%22LegacyWizards01.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlternatively%20you%20may%20call%20it%20from%20Tell%20Me%20field%20start%20typing%20Get%20data%20from%20text%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20363px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F15691iA9FF6457E1CE97E8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22TellMe.JPG%22%20title%3D%22TellMe.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-77115%22%20slang%3D%22en-US%22%3EHow%20to%20import%20plain%2C%20simple%2C%20flat%20CSV%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-77115%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20old%20Text%2FCSV%20import%20wizard%20had%20not%20been%20updated%20since%20Office%202002%2FXP%2C%20looked%20old-fasioned%2C%20but%20it%20was%20very%20good%20at%20recognizing%20columns%20with%20dates.%20You%20could%20specify%20for%20instance%20YMD%20from%20a%20drop-down%20list%20and%20it%20even%20recognized%20yyyymmdd.%20Than%20suddenly%2C%20on%20a%20rainy%20monday%20morning%20you%20arrive%20in%20the%20office%2C%20fire%20up%20your%20PC%2C%20an%20Office%20365%20update%20comes%20in%20and%20without%20any%20advance%20notice%20the%20trustworthy%20old%20wizard%20is%20gone.%20Replaced%20by%20%22Get%20and%20Transform%20Data%22.%20Great%20for%20enterprises%2C%20but%20a%20small%20company%20just%20needs%20that%20data%20that%20we%20get%20from%20the%20bank%20as%20a%20.CSV.%20No%20connections%2C%20queries%2C%20tables%2C%20transforms%2C%20styles%20or%20whatever.%20Just%20the%20raw%20data%2C%20permanently.%20We%20only%20need%20to%20convert%26nbsp%3Bthat%20yyyymmdd%20dates%20to%20something%20Excel%20understands%2C%20like%20the%20old%20wizard%20did%20so%20well.%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20no%20time%20to%20do%20a%20course%20or%20watch%20video's%2C%20we%20need%20to%20get%20on%20with%20our%20own%20core%20business.%20How%20can%20we%20make%20it%20work%20again%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-77115%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EGet%20%26amp%3B%20Transform%20Data%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

The old Text/CSV import wizard had not been updated since Office 2002/XP, looked old-fasioned, but it was very good at recognizing columns with dates. You could specify for instance YMD from a drop-down list and it even recognized yyyymmdd. Than suddenly, on a rainy monday morning you arrive in the office, fire up your PC, an Office 365 update comes in and without any advance notice the trustworthy old wizard is gone. Replaced by "Get and Transform Data". Great for enterprises, but a small company just needs that data that we get from the bank as a .CSV. No connections, queries, tables, transforms, styles or whatever. Just the raw data, permanently. We only need to convert that yyyymmdd dates to something Excel understands, like the old wizard did so well. 

We have no time to do a course or watch video's, we need to get on with our own core business. How can we make it work again?

1 Reply
Best Response confirmed by Willem Bast (New Contributor)
Solution

Hi Willem,

 

Not exactly, old wizard is still here. You may add it from File->Options

 

LegacyWizards.JPG

 

Select it from Lecacy Wizards in Get data

 

LegacyWizards01.JPG

 

Alternatively you may call it from Tell Me field start typing Get data from text

 

TellMe.JPG