# 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><li>named ranges</li><li>sheet visibility</li><li>links</li><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>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://webix-guides.gitbook.io/spreadsheet-user-guide/excel_import_export.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.