Posted: Mon Oct 26, 2009 6:08 pm Post subject: Import multiple tab-delimited files into one new spreadsheet
Is it possible to import multiple tab-delimited text files into one new spreadsheet
I've got 4 tab-delimited text files, each with 7 columns and 749 rows of data. I'd like to import each file into a new spreadsheet of 28 columns, but haven't a clue how.
Any ideas/suggestions would be greatfully appreciated.
TIA _________________ Bob
NeoOffice 3.1.1 patch 1 Intel
OS X 10.6.3
You can do this, but it will take a few manual steps to do it. Can you try the following steps and tell us if they work for you?:
1. Make sure all 4 of your files have a .csv extension so that NeoOffice Calc will recognize that they are character separated values in the files.
2. Make sure NeoOffice is running. Then select all 4 files in the Finder and drag them onto the NeoOffice icon in the Dock.
3. The Text Import dialog will appear. In the "Separated by" section, make sure that only the "Tab" checkbox is checked and then press the OK button. A new Calc document will then appear. Repeat this step until 4 new Calc documents are created.
4. Select File :: New :: Spreadsheet to create a new, empty Calc document.
5. For each of the 4 new Calc documents, select the filled columns, press Command-C to copy the columns, click in the first empty cell in the first row of the Calc document that your created in the previous step, and press Command-V to paste the columns.
You can do this, but it will take a few manual steps to do it. Can you try the following steps and tell us if they work for you?:
1. Make sure all 4 of your files have a .csv extension so that NeoOffice Calc will recognize that they are character separated values in the files.
2. Make sure NeoOffice is running. Then select all 4 files in the Finder and drag them onto the NeoOffice icon in the Dock.
3. The Text Import dialog will appear. In the "Separated by" section, make sure that only the "Tab" checkbox is checked and then press the OK button. A new Calc document will then appear. Repeat this step until 4 new Calc documents are created.
4. Select File :: New :: Spreadsheet to create a new, empty Calc document.
5. For each of the 4 new Calc documents, select the filled columns, press Command-C to copy the columns, click in the first empty cell in the first row of the Calc document that your created in the previous step, and press Command-V to paste the columns.
Patrick
I'll be sure to let you know if the above steps work for me. I first need to 'create' the .csv files first. BTW, in step 2, do you want me to actually open NO and perhaps minimize it so it's still running or just open it and pres Command-W _________________ Bob
NeoOffice 3.1.1 patch 1 Intel
OS X 10.6.3
I'll be sure to let you know if the above steps work for me. I first need to 'create' the .csv files first. BTW, in step 2, do you want me to actually open NO and perhaps minimize it so it's still running or just open it and pres Command-W
For step 2, it does not matter if there are any documents open or not. Just as long as the NeoOffice icon is showing in the Dock as running is all you need.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum