# Excel Import/Export

## Importing data from Excel

It is possible to import data from an Excel file into a sheet of SpreadSheet.

To import data from Excel:

1\) Click the **Import from Excel** button in the **File** section:

![Import from Excel](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFMu8I0hD4GRWtAogFP%2F-LEKw8THNHNacVh2b60V%2Fimport_from_excel.png?generation=1529409478013514\&alt=media)

2\) Choose an Excel file the content of which you want to export to SpreadSheet from your computer. Its data will be displayed in the current sheet.

## Exporting data to Excel

You can export the content of a sheet to an Excel file.

To export data to Excel:

1\) Click the **Export to Excel** button in the **File** section:

![Export to Excel](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFMu8I0hD4GRWtAogFP%2F-LEKw8Tew-5FtwuznJru%2Fexport_to_excel.png?generation=1529409484801889\&alt=media)

2\) In the appeared dialog window, type the name of a new Excel file that will contain the content of the current sheet.

![Export to Excel Popup](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-LFMu8I0hD4GRWtAogFP%2F-LFMu9iuzsdjACJrAIJf%2Fexport_to_excel_popup.png?generation=1529409482642883\&alt=media)

3\) Сlick **Save** to save the file.

A new Excel file with exported data will be downloaded to your computer.

## Supported elements/settings for Excel export/import

In this section you can check what elements SpreadSheet can process and what settings it supports for Excel data export/import.

<table data-card-size="large" data-view="cards" data-full-width="false"><thead><tr><th></th><th></th><th></th></tr></thead><tbody><tr><td><strong>Export to Excel</strong></td><td><p></p><ul><li>data (including math and dates)</li><li>font</li><li>font size (converts px into pt)</li><li>bold, italic, underline, strike</li><li>background</li><li>color</li><li>borders</li><li>horizontal align</li><li>vertical align</li><li>rows/cols sizes (converts px into pt)</li><li>hidden rows/cols</li><li>merge</li><li>wrap</li><li>indent</li><li>number format</li></ul><ul><li>named ranges</li><li>sheet visibility</li><li>links</li></ul><ul><li>conditional formats (saves color and background-color)</li><li>checkbox/radio (exported as TRUE/FALSE)</li><li>images</li><li>frozen rows/columns</li><li>zoom</li><li>header visibility</li><li>gridlines</li><li>formulas mode</li></ul></td><td></td></tr><tr><td><strong>Import from Excel</strong></td><td><p></p><ul><li>data (including math and dates)</li><li>font</li><li>font size (converts <em>pt</em> into <em>px</em>)</li><li>bold, italic, underline, strike</li><li>background</li><li>color</li><li>borders</li><li>horizontal align</li><li>vertical align</li><li>rows/cols sizes (converts <em>pt</em> into <em>px</em>)</li><li>hidden rows/cols</li><li>merge</li><li>wrap</li><li>indent</li><li>number format (those supported by SpreadSheet)</li><li>named ranges</li><li>sheet visibility</li><li>links (all links are converted into the <em>HYPERLINK</em> method)</li><li>filters</li></ul><p></p><p></p><ul><li>images</li><li>frozen rows/columns</li><li>zoom</li><li>header visibility</li><li>gridlines</li><li>formulas mode</li></ul><p></p><p></p><p></p><p></p><p></p><p></p></td><td></td></tr></tbody></table>

