Import From a Tab-Delimited Text File in Excel
You can import data from .txt files created in Excel. The file must take the same structural form as the Slice into which it will be imported.
To import a .txt tab-delimited text file:
1. Open Excel.
2. Choose PowerOLAP, Import and then Import to set Import File.
3. Using the Import file dialog box, locate the tab delimited text file you want to import and click Open.
4. Back in the Import file dialog box, click OK.