Save the document from 1C to Excel. Cannot save the document form (invoice) in Excel format - the "Save" and "Save As" buttons are not available

Signs of pregnancy after embryo implantation

It is no secret that among office workers, in particular those employed in the accounting and financial spheres, Excel programs and 1C. Therefore, quite often it is necessary to exchange data between these applications. But, unfortunately, not all users know how to quickly do this. Let's find out how to upload data from 1C to an Excel document.

If loading data from Excel into 1C is a rather complicated procedure, which can only be automated using third-party solutions, then the reverse process, namely uploading from 1C to Excel, is a relatively simple set of actions. It can be easily done using the built-in tools of the above programs, and this can be done in several ways, depending on what exactly the user needs to transfer. Let's look at how to do this using specific examples in the 1C version 8.3 .

Method 1: Copy cell contents

One unit of data is contained in cell 1C. It can be transferred to Excel using the usual copy method.


The contents of cell 1C will be inserted into Excel.

Method 2: Paste a list into an existing Excel workbook

But the above method is only suitable if you need to transfer data from one cell. When you need to transfer an entire list, you should use another method, because copying one element at a time will take a lot of time.


The list is inserted into the document.

Method 3: Create a new Excel workbook with a list

Also, the list from the 1C program can be immediately displayed in new file Excel.


The entire list will be saved as a separate book.

Method 4: copying a range from a 1C list to Excel

There are times when you need to transfer not the entire list, but only individual rows or a range of data. This option is also quite feasible using built-in tools.


Method 5: Saving documents in Excel format

In Excel, sometimes you need to save not only lists, but also documents created in 1C (invoices, invoices, etc.). This is due to the fact that for many users it is easier to edit a document in Excel. In addition, in Excel you can delete the completed data and, after printing the document, use it, if necessary, as a form for manual filling.


The document will be saved in Excel format. This file can now be opened in this program and further processed in it.

As you can see, uploading information from 1C to Excel format is not difficult. You only need to know the algorithm of actions, since, unfortunately, it is not intuitive for all users. Using the built-in 1C and Excel tools, you can copy the contents of cells, lists and ranges from the first application to the second, as well as save lists and documents in separate books. There are quite a lot of saving options and in order for the user to find the one suitable specifically for his situation, there is no need at all to resort to using a third-party software or use complex combinations of actions.

If, when saving a printed form of a document or report, the "Save" and "Save As" buttons of the "File" menu are inactive, this means that the table protection flag is set. To disable it, you should disable the "Prohibit editing tables" checkbox (menu "Tools" - "Setting configuration parameters" - tab "Auxiliary"). After this you need to re-form printed form invoice - saving to file will be available.

Prohibition of editing tables is used to exclude the possibility of personnel falsifying the data of primary documents, since it does not allow disabling the “View Only” mode, as well as copying the table or saving it in a file. Therefore in typical configuration Only an employee with “Administrator” or “Manager” rights can remove the ban on editing tables.


They find us: how to save reports in excel in 1 from 8 3, how to configure in the 1s 8 3 program find the save as button, how to save an invoice from 1c in excel, 1c is not available to save as, 1c 7 7 is not available to save as, how to save invoices from 1c in excel so that the pillars do not go astray, as in 1s 8 2 save documents in excel format, 1s 7 7 does not save report in excel, how to save a delivery note from 1s, in 1s 8 2 the functions of printing and saving printed forms are not available, the printer icon is inactive

It was a small discovery for me that 1C users do not know how to quickly upload almost any data from 1C to Excel. Recently I came across what my colleagues did, and then using FineReader they translated the data into text from a picture, because the save button in 1C did not work (see picture). Long way, isn't it? But there are more convenient ways. There is no secret in unloading from 1C; there are quite a lot of possibilities.

Let's look point by point at how we can save data from 1C to Excel:

The easiest way to save from 1C to Excel data- this is to select one cell in a document or journal and click (copy), then in Excel select the cell where you want to save the data and click v. This way you will save the contents of that cell. For the example picture it will be 42,289.23

This method works for any version of 1C.

2. How to download a large amount of data from 1C to Excel?

The previous method is good, but you can’t accumulate a large amount of data this way. Therefore, it is better to use the List tool.

In almost any document journal, reference book, or document, right-click and look for List.


For versions 8.3 and the “Taxi” interface, the button to display the list is in the More menu

A list of these elements will appear as text (you may need to select which columns to select first). This text can already be copied into any document. But I advise you to use the File - Save As menu (since large amounts of data will take a long time to process and an error may occur when copying to the buffer).

Then select the desired file format.

All files are saved in the required format.

This method also works for any version of 1C.

For version 1c 8.2 and higher in thin client or in the Taxi interface, the File - Save As tool is available in the panel in the upper right corner in the form of a floppy disk

3. How to download printed forms of documents from 1C to Excel?

Printed forms of documents such as

1 - Uncheck the View Only button to be able to change the printable

2 - Save the document in the desired format, see point 2

You can also save the contents of the printed form as any text data, just like in Word.

Often a printable or report form can be saved with a simple Copy-Paste into Excel.

How to load data from Excel into 1C is a completely different story. But I’ll tell you that soon, just wait ;)

Share our article on your social networks:

Send this article to my email

The procedure for transferring data from 1C (list of directory or document elements, tabular part of a document, etc.) to Excel format is a very convenient 1C function, because allows you to save almost any data in Excel for further analysis.

1c enterprise version 8.2:

For example, we want to download data from the Nomenclature directory; to do this, open the Nomenclature directory, display the necessary data (use selections, open the desired group):

And click OK.

After this, an Excel file with the necessary data from 1C will be created in the specified path.

But, you don’t have to save the data to a file, but simply (after you have displayed the list) select the data, then save it to the clipboard (right-click - Copy), open Excel and paste the data from the clipboard into a blank sheet (right mouse button - Paste).

In the same way, you can save lists of documents and tabular parts in them.

If you want to save the report in Excel, then create a new report, and in order to upload it to Excel, you no longer need to display it in the list, but simply click in the main menu "File" - "Save a copy" and then according to the scheme described above . Or simply copy it via the clipboard.

1c enterprise version 8.3:

On the 1C platform version 8.3, the technology for saving data in Excel is slightly different from version 8.2.

Here, if you right-click on the list, you will no longer see the “Display list...” item; instead, you need to click on the “All actions” menu and select the already familiar “Display list...” item:

In the same way, you mark the required columns with checkboxes, but there is also a wonderful “Only selected” flag; when you set it, only the selected rows are displayed in the table. To select several lines in the list of the nomenclature directory, click on the lines with the mouse while holding down the "Ctrl" key, you will get something like this (selected lines are highlighted in blue):

In the end, it should look something like this:

Next, you can save this table in Excel via the clipboard (as I wrote above), or save it directly to an Excel file, for this in 1c (in the displayed list) click on special button main menu (with a down arrow) and select "File" - "Save as...", then a standard file saving window opens, in it you specify the file name and type "Excel Sheet" and click "Save".

To save the report to a file, do the same as I wrote just above:

Very often it is required to obtain data from 1C 8.3 and save the information in external file, in other words, make an unload from the 1C enterprise. The task is almost always possible without the involvement of 1C programmers.

Consider the series useful tips, with the help of which you can upload data from 1C to an external information system.

In 1C there are several methods by which you can obtain information without the involvement of specialists:

  • Uploading the entire database from 1C 8.3 - for subsequent loading on another computer
  • Save reports and printables in Excel, Word or PDF
  • Uploading tables from 1C
  • Retrieving Information Using the Query Console

More details about them:

How to download the entire database from 1C 8.3 (to a .dt file)

To do this, you will need to go to the configurator mode, then in the main menu select “Administration” - “Upload information base”:

Then you only need to indicate the name of the future file and its location on the disk.

To subsequently upload to another database, click on the “Load information base” button and select the previously uploaded file.

Uploading reports and printed forms from 1C to Excel

This method is universal and very simple. To do this, it is enough to open a printed form or report.

For example, open the TORG 12 printable form, press ctrl+S (or in the File – Save As menu) and select the file type and its name:

The same system applies - the report is downloaded in two clicks:

Get 267 video lessons on 1C for free:

Saving in the main formats is available - excel, word, pdf, html, txt, etc.

Uploading tables from 1C 8.3

Often there are such trivial tasks as “get a list of payments for the current year”, “unload a book of purchases or sales” or “unload goods from invoice No. 256”. Solving such problems is quite simple.

For example, I need to receive all receipts from the counterparty “Vector” with an amount greater than 1000. Let’s open the list form and set the necessary selections in the list:

The system will offer an output option - to a spreadsheet document or a text document, select tabular. The 1C program will display the information in the following spreadsheet document, which, like reports, can be saved in the format we need:

Similar actions can be performed for almost any tabular part in 1C 8.2. For example, we needed to unload a list of goods from receipt No. MSK00003, no problem. This is done very simply - open the document, call the context menu and after a couple of clicks we get the desired upload in the required format:


Uploading a journal of transactions from 1C to Excel:

Retrieving Information Using the Query Console

However, not all information can be found in the simple tabular part of 1C 8.2. Sometimes you need to collect data from several data sources and connect them using some fields.

This method is suitable for technically savvy people who know the basics of query language. It consists in obtaining the result of the request using and saving it in the format we need.

For example, you need to get all supplier counterparties and their phone number. To do this, we will write the following query:

The resulting table can also be downloaded into the desired file format:

You can load the received data into another 1C database using “ “. Watch the video instructions using the nomenclature as an example:

Publications on the topic