-
Step 1
Open the spreadsheet you want to export.
-
Step 2
Click on the "File" button on the menu bar. Select "Save As." A dialog box appears with options you can use to adjust the properties and storage location of your file.
-
Step 3
Click the arrow next to the "Save In" field. Choose a location in which to save your file from the drop-down menu.
-
Step 4
Click the "File Name" field. Enter a name for your file if you want to change the current name.
-
Step 5
Click on the arrow next to the "Save As Type" field. Select "Text (Tab delimited)." Click "Save."
-
Step 1
Open the worksheet containing the data you want to use on a web page.
-
Step 2
Click "File" on the menu bar. Click on "Save as Web Page" on the file menu.
-
Step 3
Click on the "Publish" button. A box with the title "Publish as Web Page" pops up. Ensure that the "Choose" field shows "Items on X" and that "Sheet All Contents of X" is highlighted in the list below the field. (X represents the name of your spreadsheet.)
-
Step 4
Click on the checkbox under the list to select "Add Interactivity With." This option makes the spreadsheet interactive on the web page. You can choose to add interactivity with spreadsheet functionality or PivotTable functionality.
-
Step 5
Click the "Change" button if you want to add a title to your worksheet on the web page.
-
Step 6
Click "Browse" to select a location for your web page. You can save or publish it to a hard drive, FTP, folder, web server or web folder. Check "Open published page in browser" to see your web page when you publish it.
-
Step 7
Click "Publish." If you chose to view your web page, it will display automatically.
