It is no secret that a successful 1C application was developed to help accountants, allowing them to perform multiple operations quickly and as efficiently as possible. However, novice accountants sometimes have to “sweat a little” to understand all the possibilities that this software contains. Of course, having delved into the mechanism for carrying out individual operations, having understood everything to the smallest detail, accountants not only remain satisfied with the software, but also notice an increase in the productivity of their work.

One of the pressing problems faced by novice accountants who have no experience with 1C is loading into 1C from a previously created Excel. Indeed, it is difficult to figure out on your own how to save a document in Excel in 1C, and it is also problematic to figure out how to save it in Excel from 1C in order to subsequently work directly with the spreadsheet editor.

So, in order to eliminate all problems, you should concentrate and study the instructions, delving into each step of the proposed algorithm. Of course, beginners should not show their own creativity when carrying out such manipulations. Only experienced users can afford to perform more complex operations. Beginning accountants first just need to “get their teeth into it” and learn how to perform actions that make it possible to save data in Excel. Only after this can you expand your knowledge of how to import Excel into the 1C program.

Transaction mechanisms

I would also like to note that the mechanism for performing the desired actions may differ depending on which version of the 1C: Accounting program is installed on the computer. In the most recent versions, this process is no longer particularly problematic. That is why experienced users recommend monitoring for updates, and if they are found, be sure to update the program. If the latest version of the software is installed on your computer, then it will be easier to figure out how to upload it to Excel in 1C or save it in the program.

Loading algorithm

First, decide what exactly you would like to save in 1C. Open the table you created earlier in Excel, check whether all the data is important for you to load into the program. If you subsequently do not need some columns in a spreadsheet document because they are of no value, simply delete them in advance so as not to overload the 1C: Accounting program. After this, do not forget to resave the table you edited.

Now you can begin direct actions that allow you to upload to 1C from Excel. First open the program itself, find the “Directory” line on the left side, click on it. Additional subsections will open, among which select the “Nomenclature” line. Now on the horizontal panel there will be a menu in which find “Nomenclature and prices”; by clicking on it, a sublist will open in which you will find the desired word “Download”.

For the import to be successful, it is important to ensure that the downloaded document is saved in the correct format. You can import into 1C:Accounting documents that you managed to save in Excel 2003 or later versions. The document can also be saved in mxl and ods format. If you have done everything exactly this way in advance, then you can import.

It’s easy to understand how to save it in Excel in 1C by clicking on the “Download” button. The usual loading window will appear on the screen. All that remains is to indicate the path where the document you want to download is located. After the import into 1C from Excel is completed, please note that in the program it will be exactly the same as it was in the spreadsheet editor.

At this point, the import is completed, but your actions continue, especially if you did not edit the table first, so there are extra rows and columns left in it. Above the columns you will find a sentence such as “Specify details”; by clicking on it, you will need to select one of the options offered in the list. Once you have successfully worked with each column, look at the rows. If you find something unnecessary, feel free to delete it.

To perform such manipulations, select a row, and then click on the “Delete Row” button.

Studying the instructions on how to upload to 1C from an existing Excel, you will easily find advice that after editing the table, you need to fill in the missing data. If you do such manipulations meticulously, it will be easier to work with the program later. In the same way, it will be easier to search.

This completes the import of the table editor into the 1C: Accounting program. If you strictly follow the instructions on how to download from Excel in 1C, but something goes wrong, make sure that the program itself is accompanied by the latest version.

Upload algorithm

So, having thoroughly understood how to load documents previously created in Excel into 1C, you can now delve into how to save a document in Excel from 1C. Some accountants also often encounter this need. Fortunately, new versions of the program not only have this feature, but performing such tasks is already accompanied by noticeable improvements.

First of all, the uploaded document can be used as a price list that can be sent to partners and suppliers. To “force” the file to be uploaded, you should initially follow the already familiar route, first opening “Nomenclature”, then “Nomenclature and Prices”, and finally this time the line “Upload”. After this, a window will appear in which you will need to specify the columns that you would like to see later in Excel.

It is also possible to add additional columns; the “Add” and “Delete” buttons are located on the top horizontal panel to solve such intermediate tasks. After you are convinced that all the necessary data is involved and marked, you should click the “Upload” button, indicate the path where you want to save such a file and simply wait for the completion of the process carried out by the program itself.

You won't have to wait long because the operation is completed quite quickly.

When the program announces the completion of the process, all that remains is to open the downloaded file and make sure that it contains everything that will be needed for further work. Experienced accountants can create a load of not just one position, but several at once, numbering not in dozens, but in hundreds. Thanks to such actions, time is saved significantly, which is welcomed by those who previously had to spend enormous time resources to complete such tasks.

So, the process of uploading and loading Excel documents into the 1C: Accounting program was previously accompanied by increased problems. At the moment, by updating the program to the most current version and studying useful recommendations, any accountant can cope with such tasks.

In 1C 8.3 it is possible to bulk load a list from a spreadsheet document, for example, from an Excel file.

We use external processing for loading Loading Data From TabularDocument.epf for managed forms (8.2 and 8.3), which can be downloaded . It is universal and should be suitable for any configuration written for a managed application.

• If you are a programmer and want to develop “your own” download from Excel, detailed instructions for;
• An example of loading a price list in 1C Trade Management can be found at.

To start external processing, you need to go to the “File” menu, then “Open” and select this processing from the directory in which it was saved:

Processing Loading data from a spreadsheet document 1C 8.3 (managed forms)

After processing has opened in 1C, you can start working with it. First of all, we need to decide where and what we will download:

I want to give an example in the directory ““. I created a data file in xls format.

Processing can also load files in the following format:

• any other format from which you can copy data.

This is what the Excel file with the source data looks like, which we will upload to the “Nomenclature” reference book:

Get 267 video lessons on 1C for free:

I did not write down all the fields in the directory, since this is enough to understand the principle of loading. In addition, this data is enough to start working with these positions.

These positions are not yet in the 1C information database, and we will now upload them there.

Click on the “Open” icon (indicated in the figure as “Select source”) and select the file with the data. You can use simple copying of information. My example file can be downloaded. The data will be loaded into processing automatically. Now let's check if we filled out our data correctly. To do this, click the “Filling Control” button.

As you can see, we have some errors! We will eliminate it. Go to the “Settings” tab:

Before correcting errors, I want to draw your attention to one important detail. The program initially does not know in which field to look for a directory element in case it is already there. So she needs to point it out. I prefer to search by code since it is usually unique. In the “Search field” column in the “Code” line, put a checkmark. Now, if a record with such a code is found, it will be replaced, otherwise it will be created.

Important! If you do not specify a search field, duplicate items may appear. Especially after the second download of a similar file!

Now let’s see why “Unity” is swearing on the field. The fact is that units of measurement in 1C 8.3 are stored in a separate directory, and processing by default looks for this unit by name. But in fact, the word unit is written in the “Full name” field.

Unfortunately, processing can only search by “Name” and “Code” (for the programmer the possibilities are wider). If you pay attention to the pictures above, you will see that I have a code in the “Unit” column. And in processing you need to indicate that the search should be carried out by code. Double-click on the “Communication Condition” column opposite “Units” and change it to “Code”.

Now let’s see what they tell us about “Service” in the list of errors. One more important note. The columns in the file must be located strictly in the same order as the lines of the directory fields. And for us “” is located at the very bottom, and in the file after the “Comment” column.

In order to move the “Item type” line up, there are blue arrows at the top of the form. Using the “Up” arrow, raise the desired line and place it under “Comment”.

Click “Load data”, and this time everything goes without errors:

Video tutorial on loading products into 1C from Excel files:

Configuration: 1c accounting

Configuration version: 3.0.44.177

Publication date: 20.01.2017

The 1C: Accounting program now offers the ability to routinely upload and download data from Excel spreadsheet documents, without the use of third-party processing or configuration changes. Loading and unloading is so easy that experienced users will quickly fall in love with this convenient mechanism, and new users will quickly master it.

Download from Excel 1C: Accounting 8.3 ed. 3.0

For example, we have this Excel spreadsheet document for loading a list of items and prices (retail and purchasing).

Come to .

At the top click Nomenclature and Prices - Download. This is where loading and unloading from spreadsheet documents is hidden.

The download supports xls (old Excel 97-2003 format) and xlsx (new format), as well as mxl and ods formats. Now we select our file with the nomenclature and wait for it to load.

The spreadsheet document has been loaded in the form we saw it in Excel, now we’ll assign columns and delete the unnecessary ones.

Click on Please provide details and select the desired item from the list.

Select the row that contains unnecessary entries, namely the table header, and click Delete line.

Now we delete the column with the purchase price, note that processing can fill out only 1 type of price at a time!!! Then you can do this operation again and load the 2nd type of price, for the 1st load Retail for the 2nd purchase.

Fill in the blank data, Price type, Set prices for. The buttons All, Found, New, Duplicates will greatly facilitate the search and help compare items. Fill in and click Download after which the data will be loaded into 1C: Accounting.

New items have appeared in the product list, filled and with assigned prices. If you need to load another type of price, do all the steps again, but select a column with a different price, 1C itself will find already created positions and will not try to duplicate them, but will simply add a new type of price.

As you can see, the download created 2 documents for setting item prices, for the Purchase Price and for the Retail Price. The difference between this treatment is Loading from Excel to 1C: Accounting 8.3, The fact is that this is standard processing and it works without failures and takes into account all the features of filling out the document.

Uploading to Excel from 1C: Accounting 8.3 ed. 3.0

A very useful function in edition 3.0.44.177 and higher is uploading to Excel from 1C: Accounting 8.3; this processing will help you create a company price list or transfer your list of items to suppliers or buyers immediately with prices.

It's all there in the directory Nomenclature - Nomenclature and Prices - Unload.

In point Columns, select the columns that need to be built in the Excel document. Selection serves to select items by Groups, properties, names... etc.

To upload to Excel, we will add a new column, namely the VAT rate, it doesn’t seem to be very necessary, but we are practicing.

How can you download documents from a supplier by email in 1C:Accounting 8 edition 3.0?

The video was made in the 1C: Accounting 8 program (release 3.0.42.84).

The transition to electronic document management (EDF) will help to significantly simplify the process of exchanging documents between counterparties, as well as reduce the costs of delivering documents, purchasing consumables and storing archives. Since April 8, 2011, the Federal Law of April 6, 2011 No. 63-FZ “On Electronic Signatures” has been in force, which determined the procedure for obtaining and using an electronic signature and the responsibilities of participants in the exchange of electronic documents. For more information about the exchange of electronic documents, see the directory “Exchange of Electronic Documents” in the “Accounting and Tax Accounting” section.

If the counterparties are not participants in the electronic document flow, then exchanging documents via e-mail will help simplify the process of registering the primary accounting document in the information system.

Accounting system documents Buyer's invoice, Sales (act, invoice), Invoice issued can be sent to the counterparty by email (click Send by email with an image of an envelope). The document is sent as a file attached to the letter in the format selected by the user. Also attached to the letter is a file intended for downloading by the recipient in “1C: Accounting 8” (rev. 3.0).

You can upload documents received from the supplier in the document list forms.

Invoices for payment are uploaded in the form of a list of documents Money orders. Invoices and acts - in the list Receipts (acts, invoices).

The recipient can upload documents like or UPD from files with the extension xls, mxl or in a format approved by the Federal Tax Service of Russia. You can upload documents from a file or from email. You can select the loading method in the form of the list of receipt documents by clicking the button Download. When loading, the program checks for format compliance and reports the results of the check.

When uploading documents TORG-12, Work (service) acceptance certificate or UPD an accounting system document is created Receipt (act, invoice), in which the necessary details are automatically filled in. An additional document can be created for receipt documents Invoice received.

If a product or service arrives to the recipient from the supplier for the first time, and the items of the buyer and supplier are not synchronized, then in the form that opens Comparison of data by item field must be filled in Nomenclature by selecting the appropriate position from the directory Nomenclature, and press the button Save and close .

Setting up email accounts is done in the section Administration - Organizer. The counterparty's email address must be specified in the directory element form Counterparties.

Please note that downloaded documents from e-mail (from a file) are not legally binding documents, therefore both the buyer and the seller must have properly executed documents in paper form.

Video material on the topic:

Many who work in the 1C program are faced with the need to load data from an Excel spreadsheet into 1C. When the user may need such a download:
- a report is generated and saved in Excel, processed. The processed data must be loaded into 1C in the form of a document (movement, return to the supplier)
- there is a list of items that needs to be loaded into the directory. The list of items is in Excel
- any other data that needs to be loaded into the tabular part of the document, reference book, information register
Below are instructions for loading data from Excel into the tabular part of the document “Return of goods from the buyer”.
Action 1. Preparing the document into which the data will be loaded. You need to create a blank document “Return of goods from the buyer” and write it down.

Act 2. Open external processing "Loading data from a spreadsheet document".

Act 3. In processing, select the location where we will load the data.

Act 4. Configure boot options. Do everything as shown in the picture to practice.

Action 5. Copying data from Excel into the “Spreadsheet Document” tab for processing (as in the figure). Two buttons are highlighted in red: “Control” of filling (shows errors, for example, if the unit of measurement of the loaded item is incorrectly specified) and “Load” (performs loading).

The fewer parameters you specify for uploading, the less likely there are errors during uploading, but the more data you will have to manually correct in the uploaded document.

Actually, herself processing data loading from Excel to 1C