Skip to main content
SharePoint

Return to Answer

replaced http://stackoverflow.com/ with https://stackoverflow.com/
Source Link
Community Bot
Community Bot
  • 1

This is how the lookup data is stored internally. Your best option is to create some client side JavaScript code which reads and formats the data in the required format and dump it into a CSV file. Then open the CSV file in Excel.

You can execute the JavaScript code by opening browser console window.

  1. Querying data in JavaScript
  2. Expand lookup fields
  3. Create CSV file using JavaScriptCreate CSV file using JavaScript

Another Option

Create a REST query and execute it in a new browser tab. This will give back the JSON/XML format. Now convert this to CSV format using online tools -

  1. https://konklone.io/json/
  2. http://www.convertcsv.com/xml-to-csv.htm

This is how the lookup data is stored internally. Your best option is to create some client side JavaScript code which reads and formats the data in the required format and dump it into a CSV file. Then open the CSV file in Excel.

You can execute the JavaScript code by opening browser console window.

  1. Querying data in JavaScript
  2. Expand lookup fields
  3. Create CSV file using JavaScript

Another Option

Create a REST query and execute it in a new browser tab. This will give back the JSON/XML format. Now convert this to CSV format using online tools -

  1. https://konklone.io/json/
  2. http://www.convertcsv.com/xml-to-csv.htm

This is how the lookup data is stored internally. Your best option is to create some client side JavaScript code which reads and formats the data in the required format and dump it into a CSV file. Then open the CSV file in Excel.

You can execute the JavaScript code by opening browser console window.

  1. Querying data in JavaScript
  2. Expand lookup fields
  3. Create CSV file using JavaScript

Another Option

Create a REST query and execute it in a new browser tab. This will give back the JSON/XML format. Now convert this to CSV format using online tools -

  1. https://konklone.io/json/
  2. http://www.convertcsv.com/xml-to-csv.htm
replaced http://sharepoint.stackexchange.com/ with https://sharepoint.stackexchange.com/
Source Link
Community Bot
Community Bot
  • 1

This is how the lookup data is stored internally. Your best option is to create some client side JavaScript code which reads and formats the data in the required format and dump it into a CSV file. Then open the CSV file in Excel.

You can execute the JavaScript code by opening browser console window.

  1. Querying data in JavaScript
  2. Expand lookup fieldsExpand lookup fields
  3. Create CSV file using JavaScript

Another Option

Create a REST query and execute it in a new browser tab. This will give back the JSON/XML format. Now convert this to CSV format using online tools -

  1. https://konklone.io/json/
  2. http://www.convertcsv.com/xml-to-csv.htm

This is how the lookup data is stored internally. Your best option is to create some client side JavaScript code which reads and formats the data in the required format and dump it into a CSV file. Then open the CSV file in Excel.

You can execute the JavaScript code by opening browser console window.

  1. Querying data in JavaScript
  2. Expand lookup fields
  3. Create CSV file using JavaScript

Another Option

Create a REST query and execute it in a new browser tab. This will give back the JSON/XML format. Now convert this to CSV format using online tools -

  1. https://konklone.io/json/
  2. http://www.convertcsv.com/xml-to-csv.htm

This is how the lookup data is stored internally. Your best option is to create some client side JavaScript code which reads and formats the data in the required format and dump it into a CSV file. Then open the CSV file in Excel.

You can execute the JavaScript code by opening browser console window.

  1. Querying data in JavaScript
  2. Expand lookup fields
  3. Create CSV file using JavaScript

Another Option

Create a REST query and execute it in a new browser tab. This will give back the JSON/XML format. Now convert this to CSV format using online tools -

  1. https://konklone.io/json/
  2. http://www.convertcsv.com/xml-to-csv.htm
Source Link
Amal Hashim
Amal Hashim
  • 28.4k
  • 5
  • 32
  • 61

This is how the lookup data is stored internally. Your best option is to create some client side JavaScript code which reads and formats the data in the required format and dump it into a CSV file. Then open the CSV file in Excel.

You can execute the JavaScript code by opening browser console window.

  1. Querying data in JavaScript
  2. Expand lookup fields
  3. Create CSV file using JavaScript

Another Option

Create a REST query and execute it in a new browser tab. This will give back the JSON/XML format. Now convert this to CSV format using online tools -

  1. https://konklone.io/json/
  2. http://www.convertcsv.com/xml-to-csv.htm