1. Export the SQL table into an excel file.
2. Go to Site Actions > View All Site Content > Create > Import Spreadsheet
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVElRoLQviq2w_4CizGEzCgFddZXC4E9cBKBnU3ZWFY8Y1oRroUn2JokLoyq4hpXB7WlmDs-Sv5H-MOrqrEzd6NLuRadpXubaP3znYCECyvpUeL981PbswBlmayXTIuPdcgA91j5y9tdY/s400/1.png)
3. Give the list a name called Location, browse the excel file to import.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitEiEACmj7gDcBsjFUeVIuMeOufCcNQJ90HF4DnpTtLrJyN0PhW9da8HZX_JX3Rb7kp5UXL4oRg3OleK__OksXvIUQDsNEnLG6WtC76sdGFsDjbW77r-dzovBxfpDyRxin288JntCtyG8/s400/2.png)
4. Select the Range of Cells range type, click the _ button to select range.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQADKx0lzo1M1EGBEaCyc1OOqPuoI1spryzq-znoCtEoiNBhFZxhOILPa1IuYcq-sPG88Mgrak9uAR-FA4dNNQG8Ar6_RarHPDYmPsVO3em5ihL89c2uH-XMFVCpdQn4OBmbooOg7Po-k/s400/3.png)
5. Select the data you wanted to import and click the red arrow button.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyWXuJKY2ITzeXeoTjnNSQcfn_5MoPABvOEcvk5oDeXeREcTzWAuhoSGQ3x6n79_2zsXXqsb5hLXSmJDjyVQozCY4-Esv4VYnzYFyyFlRKtAzaimPBGsH7Ej9C1Mq2OVLqd_d37MUv8B4/s400/4.png)
6. Click the Import button.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxi-zfKenDjs6LYJoYkShV3-RKpyQsdce9iGs-9D0mkIIEbnaignIVUxHDWsafe-EId3k68gwd6ndrBFR6ERvvQIL8WG9oNYtWwtWRtzhxG_djXgzz-zZidPUBbl0yy20L5W9KXE41EKY/s400/5.png)
7.The Location list is created.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEih9vFL05sJ1upHKmXzLDbkuP2wvKQESoi314SAryJrYGfQo2DLdctCB-S1yHVg0ekyqtYU2_TUNtQzh1MyL9LgG0n_U0SYIU-6xEoaFoSelcmHhq41rqp2iFDQjp-craCatXOGPrXXMeQ/s400/6.png)