How to Export an Excel Spreadsheet

Save

Excel is a rich spreadsheet application that includes such features as graphing tools, VBA macros, pivot tables and the ability to make basic to complex calculations. It is a common practice to create and analyze data in Excel and then export it for use in other programs. Exporting an Excel spreadsheet is a straightforward process.

Export Excel Data as a Text File

  • Open the spreadsheet you want to export.

  • 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.

  • Click the arrow next to the "Save In" field. Choose a location in which to save your file from the drop-down menu.

  • Click the "File Name" field. Enter a name for your file if you want to change the current name.

  • Click on the arrow next to the "Save As Type" field. Select "Text (Tab delimited)." Click "Save."

Export an Excel Spreadsheet to a Web Page

  • Open the worksheet containing the data you want to use on a web page.

  • Click "File" on the menu bar. Click on "Save as Web Page" on the file menu.

  • 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.)

  • 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.

  • Click the "Change" button if you want to add a title to your worksheet on the web page.

  • 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.

  • Click "Publish." If you chose to view your web page, it will display automatically.

Tips & Warnings

  • Charts on a worksheet will not be included on the web page. These will have to be created and published separately.
Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!