Import Text into Excel 2007
Nothing equals Excel for crunching of numbers, but what if your data isn't already in an Excel spreadsheet? It's as simple as using the Text Import Wizard.
Open a blank or existing Excel 2007 spreadsheet. Click the Data tab on the Ribbon and choose "From Text".
Choose the text file you want to import and double click. This will open the Text Import Wizard. Choose your data type and which row you want to start the data at and click next.
Step 2 of the Wizard allows you to manage the break lines between your data.
Step 3 of the Wizard allows you to choose column formats, provides data preview, and other advanced settings. When everything is organized click on Finish.
A final window will be displayed asking where you wish to put the data into the sheet. Here you can see I chose A6. Click OK…
Your Text Data will now be input into the Excel sheet!
In step 3 of the Text Import Wizard in Excel 2007 (SP1 included), if you
click the «Advanced» button and change the settings, and then click OK, IT
SIMPLY IGNORES YOUR CHANGES. If you click again on the «Advanced» button,
you'll notice the settings are wholly unchanged.
So it's impossible to instruct Excel 2007 to consider dots as decimal
separators, for instance. It will simply ignore it.
Does anyone know if there's a turnaround, or some fix Microsoft has issued,
or anything?
Thanks
TM
Exactly the same problem with Excel 2007 SP1. We have an ERP that exports data in txt files with (dot's) for decimal and (colon's) for numeric separator. Our regional settings for Portugal are exactly reversed, and when we try to import it in Excel 2007 SP1 it just simples ignores the Advance Text Import Settings, I tried with Excel 2003 SP3 no problem.
Same question: Does anyone know if there's a fix ou patch from Microsoft that could fix this?
Thanks
JJ
Not that I know of off hand … but I will look into this for you guys!
Thanks for the tip! I couldn't find this in the 2007 until now. Definately saves me a few hour's worth of work.
The only work-around I ahve found is to change your number separators in Regional Setting sin Control Panel. Import the text file then change your Regional Settings back. this works but is a pain when it worked just fine in Office 2003