ANY-maze Help > The ANY-maze reference > The Data page > Transferring data to specific programs > Transferring data to Microsoft Excel
Transferring data to Microsoft Excel
Introduction
Microsoft Excel is the world's de-facto standard spreadsheet program. ANY-maze fully supports transfer of data to Excel, either via the Windows clipboard or by saving data to a file.
Copy and paste
The easiest way to transfer to Excel is to simply copy and paste; however the formatting of the data (font, and column widths) will be lost.
Saving data to a file
Excel supports all the file formats in which ANY-maze can save data (SYLK, dBase, CSV and text) so you can save in any of them. Nevertheless, SYLK (which was developed by Microsoft) is the best one to use, as it preserves the format of the data.
 | When you save data to a SYLK file, ANY-maze will ask you if you want to use variable names for the column titles. When transferring data to Excel, the standard column titles are fine so you can simply select Use column titles when asked. |
How to open a SYLK file in Excel
| 1. | Click the File menu, or the File tab in versions of Excel from 2013 onwards. |
| 2. | Select Open.... |
For Excel 2013 onwards, you'll also need to select the Computer option and then Browse....
The Open file window will appear.
| 3. | At the bottom right of the window is a list of the types of file you can open. Scroll down the list (it's quite long) until you find 'SYLK' and select it. |
| 4. | In the main part of the window, navigate to the file you saved from within ANY-maze and select it. |
| 5. | Click the Open button. |
See also:
| • | Selecting cells, columns or rows |
| • | Copying and saving data |
| • | The save data window |
© Copyright 2003-2026 Stoelting Co. All rights reserved
ANY-maze help topic T0888