# Mass Edit Beds with Excel {% hint style="success" %} **Route**: Site Manager/ Location Management/ **Manage Locations** {% endhint %}

Mass modifications of beds can also be done through an excel file. Please, follow the next steps described below. Select the **Mass Edit Beds(.xlsx)** option from the drop-down menu. {% hint style="warning" %} Note that you must use at least the filter **Locations** to enable the functionality of the page. {% endhint %}

### 1. Download the Excel File \ Next, click on the option **XLSX Manage** located in the upper right-hand of the page. Then, choose the option **Download Filtered**.

It will download an excel file based on the filters used.

### 2. Edit the Excel file Please, open the file. The editable variables are marked in the red square, i.e. the yellow section. {% hint style="danger" %} **Do not delete** any column or row, this file's purpose is to mass-edit the existing data only. {% endhint %}

#### Changes on Dates If changes in dates on the columns **Construction**, **Planted**, and **Production**, are needed, please, change the format to TEXT of those columns, first. The format for the dates is MM/DD/YYYY.

Make the changes you need and save it.

### 3. Upload the Excel File Go back to **Mass Edit Beds(.xlsx)** in Manage Locations. Please, locate the **XLSX Manage** button and click on **Upload Filtered**, this time.

The following option will pop up, click on **Choose File**.

Once you attach the file, please, press on **OK** button.

### 4. Validation Process of Changes If the upload is done correctly, the following message appears: "Click here to follow the upload progress.". Please, click in **Click here** to start with some steps that help to update the filed plan in a proper and careful way.

It will redirect to a new page where the number of changes made on the excel file is recognized. Example: 26 modifications are made to the excel file we're uploading.

Pulse **Start Validation,** and accept the warning message to begin the process of verification with the **Yes, Validate!** button.

The process of validation starts running.

Please, note that you have to hit on the word **refresh** to update the status of the process. {% hint style="success" %} Note that you would need to refresh more than once. {% endhint %}

If the validation is finished, records on the excel changes display in the **Saving** section.

### 5. Saving Changes and Updating the Field Plan To update the filed plan with the new changes, please hit on **Start Saving**.

Accept the warning message with the **Yes, Validate!** button.

The saving process starts running.

Please, note that you have to hit on the word **refresh** to update the status of the process.

If the saving process is finished, the message " *X* **records updated**", where *X* is the number of changes, appears in the **Saving** section.

### 6. Check Changes Please, close the above page and go back to the **Manage Locations** module. Select one of the view options, **VIEW WAREHOUSE DATA**, from the dropdown menu and verify the changes made.

**Example:** View Results By Location Field Plan before:

Field Plan after:

### 7. Take a Snapshot of the Field Plan You should always [take a snapshot](/site-manager/manage-locations/maintain-the-field-plan.md#how-to-take-a-snapshot) after the modifications are processed.

--- # 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://manual.unosofbooks.com/site-manager/manage-locations/mass-edit-beds-with-excel.md?ask= ``` 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.